Java_数据库操作对象DAO浅谈；

来源：互联网发布：云计算视频教程百度云编辑：程序博客网时间：2024/05/21 06:24

特别说明：如果能帮助到您，请您留下点滴痕迹，让我知道我的存在是有意义的；如果不能帮助到您，请接受我的歉意；

文章简介：本文主要简单说说DAO(Data Access Object)数据库操作对象类如何与数据库进行交互；

package lee;import java.sql.*;/** * DbDao_class * description：数据库操作对象； * @date 10:53 2014-10-28 * @author cyb_23 * @version  1.0 */public class DbDao {private Connection conn;private String driver;private String url;private String username;private String pass;public DbDao(){}public DbDao(String driver, String url, String username, String pass){this.driver = driver;this.url = url;this.username = username;this.pass = pass; }///下面是各个成员属性的setter和getter方法public void setDriver(String driver) {this.driver = driver; }public void setUrl(String url) {this.url = url; }public void setUsername(String username) {this.username = username; }public void setPass(String pass) {this.pass = pass; }public String getDriver() {return (this.driver); }public String getUrl() {return (this.url); }public String getUsername() {return (this.username); }public String getPass() {return (this.pass); }//数据库连接public Connection getConnection() throws Exception{if (conn == null){Class.forName(this.driver);conn = DriverManager.getConnection(url,username,pass);}return conn;}//插入记录public boolean insert(String sql , Object... args) throws Exception{PreparedStatement pstmt = getConnection().prepareStatement(sql);for (int i = 0; i < args.length ; i++ ){pstmt.setObject( i + 1 , args[i]);}if (pstmt.executeUpdate() != 1){return false;}pstmt.close();return true;}//执行查询public ResultSet query(String sql , Object... args) throws Exception{PreparedStatement pstmt = getConnection().prepareStatement(sql);for (int i = 0; i < args.length ; i++ ){pstmt.setObject( i + 1 , args[i]);}return pstmt.executeQuery();}//执行修改public void modify(String sql, Object... args) throws Exception{PreparedStatement pstmt = getConnection().prepareStatement(sql);for (int i = 0; i < args.length ; i++ ){pstmt.setObject( i + 1 , args[i]);}pstmt.executeUpdate();pstmt.close();}//关闭数据库连接的方法public void closeConn() throws Exception{if (conn != null && !conn.isClosed()){conn.close();}}}

0 0