java mysql dbhelper_Java版DBHelper【简单】（MySQL数据库）

packagecom.hebut.util;

importjava.sql.Connection;

importjava.sql.DriverManager;

importjava.sql.PreparedStatement;

importjava.sql.ResultSet;

importjava.sql.SQLException;

importjava.sql.Statement;

publicfinalclassDBHelper {

//此方法为获取数据库连接

publicstaticConnection getConnection() {

Connection conn = null;

try{

String driver = "com.mysql.jdbc.Driver"; //数据库驱动

String url = "jdbc:MySQL://127.0.0.1:3306/school";//数据库

String user = "root"; //用户名

String password = "hadoop"; //密码

Class.forName(driver); //加载数据库驱动

if(null== conn) {

conn = DriverManager.getConnection(url, user, password);

}

} catch(ClassNotFoundException e) {

System.out.println("Sorry,can't find the Driver!");

e.printStackTrace();

} catch(SQLException e) {

e.printStackTrace();

} catch(Exception e) {

e.printStackTrace();

}

returnconn;

}

/**

*增删改【Add、Del、Update】

*

* @paramsql

* @returnint

*/

publicstaticintexecuteNonQuery(String sql) {

intresult = 0;

Connection conn = null;

Statement stmt = null;

try{