dbconnbean.java

Ajax技术简明手册（内有jsp示例）,希望对初学者有帮助

package com.db;  
import java.sql.*;  
import java.io.*;  

public class dbConnBean   
{  
//	 String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";  
//	 String sConnStr = "jdbc:odbc:bookSystem";  
//	 Connection   connect   =   null;  

	private String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";   //加载JDBC驱动
	private String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=booklib"; 
	private String userName = "root";      //默认用户名
	private String userPwd = "123";   //密码
	private Connection dbConn = null;


	public dbConnBean()
	{  
		 try   
		{  
			Class.forName(driverName);  
		}  
		catch(java.lang.ClassNotFoundException e)
		{  
			System.err.println(e.getMessage());  
		}  
	}
	public dbConnBean(String uName,String uPwd)
    {
		this.userName=uName;
		this.userPwd=uPwd;
    }
	public void setConn(String uName,String uPwd)
    {
		this.userName=uName;
		this.userPwd=uPwd;
    }
	public String getUserName()
    {
		return this.userName;
	}
	public String getPwd()
	{
		return this.userPwd;
	}
	public ResultSet executeQuery(String sql)
	{  
		ResultSet   rs   =   null;  
		Statement   stmt   =   null;  
		try
		{  
		//	dbConn = DriverManager.getConnection(sConnStr);
			dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
			stmt = dbConn.createStatement();  
			rs = stmt.executeQuery(sql);  
		}  
		 catch(SQLException  ex)
		{  
			System.err.println(ex.getMessage());  
		}  
		return  rs;  
	}
	public String execute(String sql)
	{  
		ResultSet rs = null;  
		Statement stmt = null; 
		String Str="";
		try
		{  
		//	connect = DriverManager.getConnection(sConnStr); 
			dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
			stmt = dbConn.createStatement();  
			stmt.execute(sql); 
			Str="OK";
		}  
		catch(SQLException   ex)
		{  
			System.err.println(ex.getMessage());  
		}  
		return Str;  
	}  
}