dbconnect.java

jsp做得一个分页例子

package data;

import   java.sql.*; 
public   class   DBConnect   { 
String   driver   = "com.mysql.jdbc.Driver"; 
String   url= "jdbc:mysql://localhost:3306/mysql"; 
String   username= "root"; 
String   password= "123"; 
Connection   conn; 
ResultSet   rs; 
public   DBConnect() 
{ 
try 
{ 
Class.forName(driver);//创建数据库连接驱动 
} 
catch(ClassNotFoundException   e) 
{ 
System.out.println( "jdbc: "+   e.getMessage()); 
} 

} 
public   void   executeUpdate(String   sql)throws     Exception   
{ 
//sql=new   String(sql.getBytes( "BG2312 "), "ISO8859_1 "); 
try 
{ 
conn=DriverManager.getConnection(url,username,password); 
Statement   stmt=conn.createStatement(); 
stmt.executeUpdate(sql); 
                        //stmt.close(); 
//conn.close(); 


} 
catch(SQLException   eX) 
{ 
System.out.println( "jdbc: "+   eX.getMessage()); 
} 
} 
public   ResultSet   executeQurey(String   sql)throws     Exception   
{ 
rs=null; 
//sql=new   String(sql.getBytes( "BG2312 "), "ISO8859_1 "); 
try 
{ 
conn=DriverManager.getConnection(url,username,password); 
Statement   stmt=conn.createStatement(); 
rs=stmt.executeQuery(sql); 
        //stmt.close(); 
//conn.close(); 


} 
catch(SQLException   eX) 
{ 
System.out.println( "jdbc: "+   eX.getMessage()); 
} 
return   rs; 
} 

}