jdbc_conn.java

本系统采用jsp编写,数据库采用的是MYSQL,使用JDBC驱动

package note;
import java.sql.*;

public class Jdbc_conn{
    String sDBDriver="org.gjt.mm.mysql.Driver";
    String sConnStr="jdbc:mysql://localhost:3306/note?user=root&password=";
    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;
    }
}