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()); } }}