一个用配制文件连接数据库的Java工具类

jdbc.drivers=sun.jdbc.odbc.JdbcOdbcDriver jdbc.url=jdbc:odbc:mydata jdbc.username=system jdbc.password=manager

package community.database; import java.io.*; import java.util.*; import java.sql.*; /** *//** * Title: Database Manager * Description: Connect Database * Copyright: Copyright  2002 YaoGuodong * Company: * @author unascribed YaoGuodong 姚国栋 * @version 1.0 * @email net_spirit@163.com * @QQ 16898283 * @转载的时候请保留版权信息 */ public class DBManager ...{ /** *//**getConnection() 得到连接数据库的属性文件内容，并返回连接结果集   @throws SQLException   @throws IOException   @throws Exception   声明drivers，得到数据库的驱动程序   声明url，得到连接远程数据库的URL   声明username，得到连接远程数据库的用户名   声明password，得到连接远程数据库的密码   @return DriverManger.getConnection(url,username,passowrd);   */ public Connection getConnection() throws SQLException,IOException,Exception ...{    Properties props = new Properties();    //String fileName = "e:/Database.Property";    //FileInputStream in = new FileInputStream(fileName);    InputStream in = getClass().getResourceAsStream("/Database.Property") ;    props.load(in);    String drivers = props.getProperty("jdbc.drivers");    if (drivers!=null)        ...{ System.setProperty("jdbc.drives",drivers); }    String url = props.getProperty("jdbc.url");    String username = props.getProperty("jdbc.username");    String password = props.getProperty("jdbc.password");    Class.forName(drivers);    return DriverManager.getConnection(url,username,password); } /** *//**DBManager()   * 连接数据库   */ public DBManager() ...{    try...{      conn = getConnection();      stmt=conn.createStatement();      System.out.println("Connect Database is Ok!");    }    catch(Exception e)...{      System.out.println("Connect Database Failed!:"+e);      } } /** *//** executeQuery()方法,查询SQL结果   @param sqlwords 为传入的查询的sql语句   @return rs　为返回的查询结果集   */ public ResultSet executeQuery(String sqlwords) ...{    this.sqlwords=sqlwords;    try...{      rs=stmt.executeQuery(sqlwords);    }    catch(SQLException ex)...{      System.out.println("Execute Query Sql Failed!:" + ex.getMessage());    }    return rs; } /** *//** executeUpdate()方法，修改数据库记录   @param sqlwords 为传入的查询的sql语   @return true|false   */ public boolean executeUpdate(String sqlwords) ...{    this.sqlwords=sqlwords;    try ...{      stmt.executeUpdate(sqlwords);      return true;    }    catch(SQLException ex) ...{      System.err.println("Execute Update Sql Failed!: " + ex.getMessage());      return false;    } } /** *//** executeInsert()方法，插入新的数据库记录   @param sqlwords 为传入的插入的sql语   @return true|false   */   public boolean executeInsert(String sqlwords) ...{    this.sqlwords=sqlwords;    try ...{      stmt.executeUpdate(sqlwords);      return true;    }    catch(SQLException ex) ...{      System.err.println("Execute Insert Sql Failed!: " + ex.getMessage());      return false;    } } /** *//** executeDelete()方法，删除数据库记录   @param sqlwords 为传入的删除的sql语   @return true|false   */   public boolean executeDelete(String sqlwords) ...{    this.sqlwords=sqlwords;    try ...{      stmt.executeUpdate(sqlwords);      return true;    }    catch(SQLException ex) ...{      System.err.println("Execute Delete Sql Failed!: " + ex.getMessage());      return false;    } } /** *//** close()方法，断开数据库的连接   @return true|false   */ public boolean close() ...{    try ...{      if(rs != null)...{ rs.close(); }      if(stmt != null)...{ stmt.close(); }      if(conn != null)...{ conn.close(); }      return true;    }    catch(Exception e) ...{      System.out.print("Clost Database Connect Failed!:"+e);      return false;    } } /** *//**   * 声明conn   * 声明rs结果集   * 声明stmt语气   * 声明sqlwords关键字   */ Connection conn = null; ResultSet rs = null; Statement stmt = null; private String sqlwords = null;