读取配置文件的封装Dao

来源：互联网发布：理水鲁迅公知编辑：程序博客网时间：2024/05/21 04:25

1.配置文件

mysql=com.mysql.jdbc.Driverurl=jdbc:mysql://localhost:3306/mysql-meusername=rootpassword=123456

2.DBUtil

package com.cdsxt.utils;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 mysql;private static String url;private static String username;private static String password;static{try{InputStream is=DBUtil.class.getResourceAsStream("/db.properties");Properties ps=new Properties();ps.load(is);mysql=ps.getProperty("mysql");url=ps.getProperty("url");username=ps.getProperty("username");password=ps.getProperty("password");//加载驱动Class.forName(mysql);}catch(Exception e){e.printStackTrace();}}//获取数据库连接public static Connection getConn(){Connection conn=null;try{conn=DriverManager.getConnection(url,username,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