bbsdb.java

用JSP写的论坛源代码 走过路过的各位千万不要错过啊！！！！

package serv;
import java.sql.*;
public class bbsdb {
	String sdbDriver;
	String sconnStr;
	Connection conn;
	ResultSet rs;
	public bbsdb()
	{
		sdbDriver="sun.jdbc.odbc.JdbcOdbcDriver";
		sconnStr="jdbc:odbc:db";
		conn=null;
		rs=null;
		try{
			Class.forName(sdbDriver);
			}
		catch(ClassNotFoundException classnotfoundexception){
			System.err.println("bssdb():"+classnotfoundexception.getMessage());
			}
		}
	
	//处理语句到结果集中
	public ResultSet executeQuery(String sql)
	{
		rs=null;
		try{
			conn=DriverManager.getConnection(sconnStr);
			Statement statement=conn.createStatement();
			rs=statement.executeQuery(sql);
			}catch(SQLException sqlexception)
			{
				System.err.println("aq.executeQuery:"+sqlexception.getMessage());
				System.err.println("aq.executeQuerystrSQL:"+sql);}
		return rs;
	}
	public int executeUpdate(String sql)//执行指定数据更新操作
	{
		int k=0;
		try{
			
			conn=DriverManager.getConnection(sconnStr);
			Statement statement=conn.createStatement();
			statement.executeUpdate(sql);
			k=1;
			}catch(SQLException sqlexception){
				k=-10;
				System.err.println("aq.executeUpdate:"+sqlexception.getMessage());
				System.err.println("aq.executeUpdatestrSQL:"+sql);
			}
			return k;
	}
}