JDBC:Mysql数据库连接基础工具类

         //初始化数据库连接对象
public static Connection initConnection(){
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "");
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
return conn;
}

//执行SQL语句方法,添加，修改，删除。
public static boolean execSQL(String sql){
Connection conn = null;
Statement stmt = null;
boolean flag =false;
try {
conn = initConnection();
stmt= conn.createStatement();
flag = stmt.execute(sql);
stmt.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
return flag;
}

//执行SQL查询语句方法，返回结果集对象
public static ResultSet querySQL(String sql){
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
conn = initConnection();
stmt= conn.createStatement();
rs = stmt.executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
}
return rs;
}

评论

3 楼 Javakeith 2010-09-29  

jdbc基础东西，永远不会过时的！

2 楼 halk 2009-04-07  

yangzhibin_java 写道

现在谁还用jdbc啊，换连接池了

JDBC是基础，很重要
连接池也是以JDBC为基础的

1 楼 yangzhibin_java 2008-09-05  

现在谁还用jdbc啊，换连接池了