/*
public MakeMysqlBean(){
try{
//驱动拷贝到lib中
Class.forName(driverName);
con = DriverManager.getConnection("jdbc:mysql://"+serverName+":3306/"+mydatabase+"? user="+username+"&password="+password+"&useUnicode=true&characterEncoding=GBK");
}
catch(Exception e)
{
System.out.print("连接出错"+e);
}
}
*/
package common;
import java.sql.*;
public class MakeMysqlBean
{
private Connection con = null;
private ResultSet rs;
private String driverName = "org.gjt.mm.mysql.Driver"; // MySQL MM JDBC driver
private String serverName = "localhost";
private String mydatabase = "demo";
private String username = "root";
private String password = "123456";
public MakeMysqlBean(){
try{
String url = "jdbc:mysql://" + serverName + "/" + mydatabase; // a JDBC url
Class.forName(driverName);
//con = DriverManager.getConnection(url, username, password);
con = DriverManager.getConnection("jdbc:mysql://"+serverName+":3306/"+mydatabase+"?user="+username+"&password="+password+"&useUnicode=true&characterEncoding=GBK");
//con.setAutoCommit(false);
}
catch (ClassNotFoundException e) {
// Could not find the database driver
System.out.println("Could not find the database driver");
} catch (SQLException e) {
// Could not connect to the database
System.out.println("Could not connect to the database");
}
}
public Connection getCon(){
return con;
}
public ResultSet getRs(String sql)throws Exception{
try{
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
}
catch(Exception e){
e.printStackTrace();
}
return rs;
}
public int executeUpdate( String sql ) {
int count = 0;
try {
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
count = stmt.executeUpdate( sql );
if(count !=0 ) ;
//con.commit();
else ;
//con.rollback();
}
catch ( SQLException ex ) {
ex.printStackTrace();
}
return count;
}
public void close(){
try{
if(con != null)
con.close();
}
catch(Exception e){
e.printStackTrace();
}
}
}
MakeMysqlBean.java
最新推荐文章于 2016-10-01 19:18:03 发布