DBHelper

package database; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException; /**

• Created by root on 16-11-15. */ publicclassDatabasesManager{ publicstatic final String url =“jdbc:mysql://127.0.0.1/shop?"+ “useUnicode=true&characterEncoding=utf-8”; publicstatic final String name =“com.mysql.jdbc.Driver”; publicstatic final String user =“root”; publicstatic final String password =”"; public Connection conn =null; public PreparedStatement pst =null; public String sql =null; publicDatabasesManager(){} publicvoidcreateconn(){ try{ //1、注册连接数据库的驱动 Class.forName(name); try{ //2、创建数据库连接 conn = DriverManager.getConnection(url, user, password); //设置数据库自动提交属性为假 // conn.setAutoCommit(false); //3、创建数据库命令 pst = conn.prepareStatement(sql); }catch(SQLException e){ e.printStackTrace(); } }catch(ClassNotFoundException e){ e.printStackTrace();

} } publicvoidclose(){ try{ //关闭数据库链接 this.conn.close(); //关闭数据库命令 this.pst.close(); }catch(SQLException e){ e.printStackTrace(); } } }