dbconn.java

本例讲述了如何使用JSP技术编写聊天室系统

package reg;
import java.sql.*;

public  class dbconn
{
	String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
	String sConnStr="jdbc:odbc:chat";
	Connection conn=null;
	ResultSet rs=null;	
	
	public dbconn()
	{
		try
		{
			Class.forName(sDBDriver);
		}
		catch(java.lang.ClassNotFoundException e)
		{
			System.err.println("Class dbconnect not found!"+e.getMessage());
			
		}
	}
	
	public ResultSet executeQuery(String sql)
	{
		rs=null;
		try
		{
			conn=DriverManager.getConnection(sConnStr);
			Statement stmt=conn.createStatement();
			rs=stmt.executeQuery(sql);
		}
		catch(SQLException ex)
		{
			System.err.println(ex.getMessage());
		}
		return rs;
	}
	public ResultSet executeUpdate(String sql)
	{
		rs=null;
		try
		{
			conn=DriverManager.getConnection(sConnStr);
			Statement stmt=conn.createStatement();
			rs=stmt.executeQuery(sql);
		}
		catch(SQLException ex)
		{
			System.err.println(ex.getMessage());
		}
		return rs;
	}
}