jdbc_conn.java

JSP留言板源码

package javafan;
import java.sql.*;

public class Jdbc_conn{
    String sDBDriver="org.gjt.mm.mysql.Driver";
    String sConnStr="jdbc:mysql://localhost:3306/guestbook?user=root&password=&useUnicode=true&characterEncoding=ISO-8859-1";
    Connection conn=null;
    ResultSet rs=null;
    
	public Jdbc_conn(){
		try{
            Class.forName(sDBDriver);
        }
        catch(java.lang.ClassNotFoundException e){
            System.out.println("Jdbc_conn():"+e.getMessage());
        }
    }
	
	public void executeUpdate(String sql)throws Exception{
		sql=new String(sql.getBytes("GBK"),"ISO8859_1");
		try{
			conn=DriverManager.getConnection(sConnStr);
            Statement stmt=conn.createStatement();
            stmt.executeUpdate(sql);
			conn.close();
			stmt.close();
        }
        catch(SQLException ex){
            System.out.println("sql.executeUpdate:"+ex.getMessage());
        }
    }
	public ResultSet executeQuery(String sql)throws Exception{
        rs=null;
		try{
			sql=new String(sql.getBytes("GBK"),"ISO8859_1");
            conn=DriverManager.getConnection(sConnStr);
            Statement stmt=conn.createStatement();
            rs=stmt.executeQuery(sql);
			conn.close();
			stmt.close();
        }
        catch(SQLException ex){
            System.out.println("sql.executeQuery:"+ex.getMessage());
        }
		return rs;
    }
}