databaseconn.java

来自「用Jsp实现的图书管理系统代码」· Java 代码 · 共 93 行

//数据库连接
//源程序名：DatabaseConn.java
import java.sql.*;
public class DatabaseConn
{
	String driverName="sun.jdbc.odbc.JdbcOdbcDriver";
	String ConnStr="jdbc:odbc:bookmanage";
	Connection conn=null;
	ResultSet rs=null;
	public DatabaseConn()
		{
			try
			{
				Class.forName(driverName);
			}
			catch (java.lang.ClassNotFoundException e)
			{
				System.out.println("数据库连接--构建器："+"\n"+e.getMessage());
			}
		}
	public void setDBDriver(String driverName)
		{
			this.driverName=driverName;
		}
	public String getDBDriver()
		{
		return driverName;
		}
	public void setConnStr(String ConnStr)
		{
		this.ConnStr=ConnStr;
		}
	public String getConnStr()
		{
		return ConnStr;
		}
	public ResultSet executeQuery(String sql)
		{
			try
			{
				conn=DriverManager.getConnection(ConnStr);
				Statement stmt=conn.createStatement();
				rs=stmt.executeQuery(sql);
			}
			catch (SQLException ex)
			{
				System.out.println("方法：executeQuery "+"\n"+ex.getMessage());
			}
			return rs;
		}
	public int executeUpdate(String sql)
		{	
			int result=0;
			try
			{
				conn=DriverManager.getConnection(ConnStr);
				Statement stmt=conn.createStatement();
				result=stmt.executeUpdate(sql);
			}
			catch (SQLException ex)
			{
				System.out.println("方法：executeUpdate "+"\n"+ex.getMessage());
			}
			return result;
		}
	public void close()
		{
			try
			{
				if (conn!=null)
				{
					conn.close();
				}
			}
			catch (Exception e)
			{
				System.out.println("方法：close"+"\n"+e.getMessage());
			}
			try
			{
				if (rs!=null)
				{
					rs.close();
				}
			}
			catch (Exception e)
			{
				System.out.println("方法：close"+"\n"+e.getMessage());
			}
			
		}
		}