public
class
ConDB
... {
private Connection _con;
private String _driver;
private String _userName;
private String _password;
private String _dburl;
private Statement _stmt;
public ConDB()
...{
_dburl = "jdbc:mysql://localhost:3306/mysql";
_userName = "root";
_password = "123456789";
_driver ="com.mysql.jdbc.Driver";
try
...{
Class.forName(_driver); //加载MYSQL JDBC驱动程序
}
catch (Exception e)
...{
System.out.print("Error loading Mysql Driver!");
e.printStackTrace();
}
try
...{
Connection connect = DriverManager.getConnection(
_dburl,_userName,_password);
//System.out.println("Success connect Mysql server!");
}
catch (Exception e)
...{
System.out.print("get data error!");
e.printStackTrace();
}
}
//按照给定的sql进行数据库查询
public ResultSet executeQuery(String sql)
...{
ResultSet rset = null;
try
...{
Class.forName(_driver);
_con = DriverManager.getConnection(_dburl,_userName,_password);
_stmt = _con.createStatement();
rset = _stmt.executeQuery(sql);
}catch(Exception e)
...{
System.out.println("Query Error!!!!!!!!!");
}
return rset;
}
//修改、插入、删除
public void updateDB(String sql)
...{
try
...{
Class.forName(_driver);
_con = DriverManager.getConnection(_dburl,_userName,_password);
_stmt = _con.createStatement();
_stmt.executeUpdate(sql);
}catch(Exception e)
...{
System.out.println("UpDate Error!!!!!!!");
}
}
//关闭数据库链接
public void closeDB()
...{
try
...{
_con.close();
}catch(SQLException ex)
...{
System.err.println(ex.getMessage());
}
}
}
... {
private Connection _con;
private String _driver;
private String _userName;
private String _password;
private String _dburl;
private Statement _stmt;
public ConDB()
...{
_dburl = "jdbc:mysql://localhost:3306/mysql";
_userName = "root";
_password = "123456789";
_driver ="com.mysql.jdbc.Driver";
try
...{
Class.forName(_driver); //加载MYSQL JDBC驱动程序
}
catch (Exception e)
...{
System.out.print("Error loading Mysql Driver!");
e.printStackTrace();
}
try
...{
Connection connect = DriverManager.getConnection(
_dburl,_userName,_password);
//System.out.println("Success connect Mysql server!");
}
catch (Exception e)
...{
System.out.print("get data error!");
e.printStackTrace();
}
}
//按照给定的sql进行数据库查询
public ResultSet executeQuery(String sql)
...{
ResultSet rset = null;
try
...{
Class.forName(_driver);
_con = DriverManager.getConnection(_dburl,_userName,_password);
_stmt = _con.createStatement();
rset = _stmt.executeQuery(sql);
}catch(Exception e)
...{
System.out.println("Query Error!!!!!!!!!");
}
return rset;
}
//修改、插入、删除
public void updateDB(String sql)
...{
try
...{
Class.forName(_driver);
_con = DriverManager.getConnection(_dburl,_userName,_password);
_stmt = _con.createStatement();
_stmt.executeUpdate(sql);
}catch(Exception e)
...{
System.out.println("UpDate Error!!!!!!!");
}
}
//关闭数据库链接
public void closeDB()
...{
try
...{
_con.close();
}catch(SQLException ex)
...{
System.err.println(ex.getMessage());
}
}
}