conndb.java

这是一个JSP+SQL Server论坛管理系统 基本实现了论坛的所有功能 数据库文件在上传的文件中

package beans;
import java.sql.*;
public class connDB{
		Connection conn=null;
		Statement stmt=null;
		ResultSet rs=null;

	public connDB(){
		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(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			rs=stmt.executeQuery(sql);
		}catch(SQLException ex){
			System.err.println(ex.getMessage());
			}
		return rs;
	}
	public int executeUpdate(String sql){
		int result=0;
		try{
			conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db_board;user=sa;password=");
			stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			result=stmt.executeUpdate(sql);
		}catch(SQLException ex){
			//System.err.println(ex.getMessage());
			result=0;
			}
		return result;
	}

}