dbconnect.java

来自「基于权限控制-登陆注册-register-login-manager-syste」· Java 代码 · 共 71 行

package permission;
import java.sql.* ;
import java.util.*;
public class DBConnect
{
	private String sdbDriver = "sun.jdbc.odbc.JdbcOdbcDriver";//JDBC-ODBC驱动程序
	private String sdbUrl = "jdbc:odbc:permission";//permission为本地ODBC数据源
        private String sdbUsername = "";//用户名
	private String sdbPassword = "";//口令
        public Statement stmt;
	public Connection conn = null;
        ResultSet rs=null;
	public DBConnect() throws ClassNotFoundException,SQLException{
		try {
			Class.forName(sdbDriver);//加载JDBC-ODBC驱动程序
			conn=DriverManager.getConnection(sdbUrl,sdbUsername,sdbPassword);
			//与本地ODBC数据源permission建立连接,sdbUsername,sdbPassword是用户名与口令
		}
		catch(Exception e){//捕捉错误
			System.out.print("Exception occur. Message is:"+e.getMessage());
			}
	}

	public Connection getConn()
	{
     		//getConn()返回Connection对象
		System.out.println("数据库连接成功");
		return(conn);
	}
public ResultSet executeQuery(String sql)
{//执行SQL语句
	rs = null;
	try {
	  stmt = conn.createStatement();//创建语句对象
	  rs = stmt.executeQuery(sql);//执行SQL语句
	  System.out.println("rs返回成功");
	}
	catch(SQLException ex) {
	System.err.println("aq.executeQuery: " + ex.getMessage());
	System.err.println("aq.executeQuerystrSQL: " + sql);
	}
	return rs;//返回结果集
}
public void executeUpdate(String sql) {//执行SQL语句
try {
stmt = conn.createStatement();//创建语句对象
stmt.executeUpdate(sql);//执行SQL语句
}
catch(SQLException ex) {
System.err.println("aq.executeUpdate: " + ex.getMessage());
System.err.println("aq.executeUpadatestrSQL: " + sql);
}
}
	/**
	* 关闭数据库连接
	*/
	public void destroy()
	{
		try
		{
			stmt.close();//关闭语句对象
			conn.close();//关闭数据库连接
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}
	}
}