dbbean.java

来自「它统一管理各个应用系统用户的身份验证」· Java 代码 · 共 68 行

package dbBean;
import java.sql.*;
public class DBBean 
{
	String driverName="com.mysql.jdbc.Driver";
	String userName="root";  			//数据库用户名
	String userPasswd="123";			//密码	
	String dbName="dbVote";				//数据库名
	String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd;
		
	private Connection conn = null;
	private Statement stmt = null;

	public DBBean() 
	{
		try {
			Class.forName(driverName); 
		}
		catch(ClassNotFoundException ex) {
			System.out.println(ex.getMessage());
		}
	}
	public void setDriverStr(String dn)
	{
		driverName=dn;
	}
	public void setConnStr(String ul)
	{
		url=ul;
	}
	public ResultSet executeQuery(String sql) 
	{
		ResultSet rs = null;
		try {
			conn = DriverManager.getConnection(url); 
			stmt = conn.createStatement();
			rs = stmt.executeQuery(sql);
		} 
		catch(SQLException ex) { 
			System.out.println(ex.getMessage());
		}
		return rs;
	}
	public int executeUpdate(String sql)
	{
		int result=0;
		try{
			conn = DriverManager.getConnection(url);
			stmt = conn.createStatement();
			result = stmt.executeUpdate(sql);
		}
		catch(SQLException ex){
			System.out.println(ex.getMessage());
		}
		return result;
	}
	public void close()
	{
		try{
			stmt.close();
			conn.close();
		}
		catch(SQLException ex){
			System.out.println(ex.getMessage());
		}
	}
}