com.utils

来源：互联网发布：java web课程设计题目编辑：程序博客网时间：2024/05/02 20:12

dbutils.java

//大小写自己修改

package com.neuedu.utils;import java.io.IOException;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.util.Properties;public class DBUtils {String url = "";String user = "";String password = "";//提供私有的构造方法private DBUtils(){Properties prop = new Properties();try {prop.load(this.getClass().getResourceAsStream("db.properties"));} catch (IOException e1) {e1.printStackTrace();}try {Class.forName(prop.getProperty("driver"));} catch (ClassNotFoundException e) {e.printStackTrace();}//获取与数据库的连接 url = prop.getProperty("url");user = prop.getProperty("user");password = prop.getProperty("password");}//私有的静态的实例化对象private static DBUtils dbUtils = new DBUtils();//提供给外部获取对象的方法public  static DBUtils getInstance(){return dbUtils;}//获取数据库连接的方法public Connection getConn(){Connection conn = null;try {conn = DriverManager.getConnection(url, user, password);} catch (SQLException e) {e.printStackTrace();}return conn;}//开启事务的方法public static void beginTransaction(Connection conn){try {conn.setAutoCommit(false);} catch (SQLException e) {e.printStackTrace();}}//提交public static void  commit(Connection conn ){try {conn.commit();} catch (SQLException e) {e.printStackTrace();}}//回滚public static void  rollback(Connection conn ){try {conn.rollback();} catch (SQLException e) {e.printStackTrace();}}}

0 0