通用数据库

 

通用数据库连接

 

Db.properties conn_type= conn_url=jdbc:mysql:// 10.26.24 .31:3306/buy conn_user=root conn_pwd=root conn_driver=com.mysql.jdbc.Driver

 

管理数据库连接

 

package com.buy.bean.comm.database;   import java.io.IOException; import java.util.Properties;   public class Config {        private static Properties prop = new Properties();        static {               try {                      prop.load(Config.class                                    .getResourceAsStream("config.properties"));                                    } catch (IOException e) {                      System.out.println("File:config.properties no find,PLS check out!");                      e.printStackTrace();               }        }            public static String CONNECTION_TYPE = prop.getProperty("conn_type");        public static String CONNECTION_URL = prop.getProperty("conn_url");        public static String CONNECTION_USER = prop.getProperty("conn_user");        public static String CONNECTION_PWD = prop.getProperty("conn_pwd");        public static String CONNECTION_DRIVER = prop.getProperty("conn_driver");               }

 

 

 

Config 类用来得到配置文件中的各个参数值

package com.buy.bean.comm.database;   import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement;     public class DBConnect {          public static Connection getConnection() {               Connection conn = null;                      try {                             System.out.println(Config.CONNECTION_DRIVER);                             Class.forName(Config.CONNECTION_DRIVER).newInstance();                             System.out.println(Config.CONNECTION_URL+                                           Config.CONNECTION_USER+Config.CONNECTION_PWD);                             conn = DriverManager.getConnection(Config.CONNECTION_URL,                                           Config.CONNECTION_USER, Config.CONNECTION_PWD);                      } catch (Exception e) {                             e.printStackTrace();                      }               if (conn == null) {                      System.out.println("no get connection!throws Exception");               }               return conn;        } }

将它们放在同一个包中，就可连接到数据库了。

如果数据库改动只要改变配置文件就可。