jsp链接mysql类

package condb;
import java.sql.*;
public class mysql_conn
{String conn_str="jdbc:mysql://localhost/txl";
String username="myname";
String password="123";
private Connection conn=null;
private Statement stmt=null;
ResultSet rs=null;
public void dbclass()
{
try{Class.forName("org.gjt.mm.mysql.Driver");}
catch(java.lang.ClassNotFoundException e) {
System.err.println("dbclass():"+e.getMessage());}
}
//####################
public void conn()
{dbclass();
try{conn=DriverManager.getConnection(conn_str,username,password);}
catch(SQLException ex) {System.err.println("conn():"+ex.getMessage());}
}
//#################
public ResultSet query(String sql)
{dbclass();
try{
conn=DriverManager.getConnection(conn_str,username,password);
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);}
catch(SQLException ex) {System.err.println("query():"+ex.getMessage());}
return rs;
}
//###################
public void update(String sql)
{
try{conn=DriverManager.getConnection(conn_str,username,password);
stmt=conn.createStatement();
stmt.executeUpdate(sql);}
catch(SQLException ex) {System.err.println("update():"+ex.getMessage());}
}
//######################
public void closestmt()
{try{stmt.close();}
catch(SQLException ex) {System.err.println("closestmt():"+ex.getMessage());}
}
//######################
public void closeconn()
{try{conn.close();}
catch(SQLException ex) {System.err.println("closeconn()"+ex.getMessage());}
}
//####################
}



更新时间:2024-12-18 20:26