1、mysql加载数据库driver=com.mysql.jdbc.Driver数据库的链接url=jdbc:mysql://localhost:3306/demo1用户名username=root密码password=123456设置配置文件信息
2、属性的定义public class DBUtil {private static Properties properties = new Properties();private static String driver;private static String url;private static String username;private static String password;static{
3、// 获取配置文件中的相关参数值try {读取配置文件properties.load(DBUti盟敢势袂l.class.getCl锾攒揉敫assLoader().getResourceAsStream("db.properties"));driver = properties.getProperty("driver"); url=properties.getProperty("url"); username=properties.getProperty("username"); password=properties.getProperty("password");
4、 try {Class.forName(driver);} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();}} catch (IOException e) {System.out.println("加载文件失败");}}
5、 //连接数据库的方法public static Connection getConnection() throws SQLEx艘早祓胂ception{Connection con=null;con=DriverManager.getConnection(url,username,password);return con;} //关闭数据库的方法public static void closeConnection(Connection con){try {con.close();} catch (SQLException e) {System.out.println("关闭资源失败");}}}
6、public class Test {public static void main(String[] args) {Connection con =null;try {con=DBUtil.getConnection();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}finally{DBUtil.closeConnection(con);}System.out.println(con);}}
