连接数据库的封装类

来源：互联网发布：win10系统优化工具编辑：程序博客网时间：2024/05/16 15:34

连接数据库的封装类

1.db.properties文件:

driver="com.mysql.jdbc.Driver"url=jdbc:mysql://localhost:3306/mysql-meuser=rootpassword=123456

2.封装方法

package com.cdsxt.utils;import java.io.IOException;import java.io.InputStream;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.util.Properties;public class DBUtil {private static String driver;private static String url;private static String user;private static String password;static{try {//读取配置文件db.properties的信息InputStream is=DBUtil.class.getResourceAsStream("/db.properties");Properties ps=new Properties();ps.load(is);driver=ps.getProperty("driver");url=ps.getProperty("url");user=ps.getProperty("user");password=ps.getProperty("password");Class.forName(driver);} catch (Exception e) {e.printStackTrace();}}//获取数据库连接public static Connection getConn(){Connection conn=null;try{conn=DriverManager.getConnection(url,user,password);}catch(Exception e){e.printStackTrace();System.out.println("获取数据库连接异常");}return conn;}//关闭资源public static void close(Object...objs){if(objs!=null&&objs.length>0){for(int i=0;i<objs.length;i++){try{if(objs[i] instanceof Connection){((Connection) objs[i]).close();}else if(objs[i] instanceof PreparedStatement){((PreparedStatement) objs[i]).close();}else if(objs[i] instanceof ResultSet){((ResultSet)objs[i]).close();}}catch(Exception e){e.printStackTrace();System.out.println("关闭资源异常");}}}}}

0 0