java基础JDBC之Basedao

packagecom.model.comm;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.Statement;/***封装数据访问的通用功能***/publicclassBaseDao{//访问数据的字符串常量privatefinalStringDB_DRIVER=oracle.jdbc.driver.OracleDriver;privatefinalStringDB_URL=jdbc:oracle:thin:@localhost:1521:XE;privatefinalStringDB_USER=xq;privatefinalStringDB_PWD=xq;/***获得数据链接对象***/publicConnectiongetConn(){Connectionconn=null;try{Class.forName(DB_DRIVER);conn=DriverManager.getConnection(DB_URL,DB_USER,DB_PWD);}catch(Exceptionex){ex.printStackTrace();}returnconn;}/***释放数据库相关资源***/publicvoidcloseAll(Connectionconn,Statementstat,ResultSetres){try{if(res!=null){res.close();}if(stat!=null){stat.close();}if(conn!=null){conn.close();}}catch(Exceptionex){ex.printStackTrace();}}}