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

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

文章简介：本文主要简单说说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();
		}
	}
}