conn.java

JSP+SQL Server2000 附有数据库和完整代码

package beans;
import java.sql.*;
public class conn
{
	Connection conn=null;
	Statement stmt=null;
	ResultSet rs=null;
			
	public conn()
	{
		try
		{
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); 	
		}
		catch(java.lang.ClassNotFoundException e)
		{
			System.err.println(e.getMessage());
		}
	}
	public ResultSet executeQuery(String sql)
	{
		try
		{
			conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db_board;user=sa;password=");
			stmt=conn.createStatement();
			rs=stmt.executeQuery(sql);
		}
		catch(SQLException ex)
		{
			System.err.println(ex.getMessage());
		}
		return rs;
	}	
		
}