www.javainfo.com.cn 上干货 欢迎收藏

MYSQL链接方式

mysql:

    jdbc.driver=com.mysql.jdbc.Driver

    jdbc.url=jdbc\:mysql\://127.0.0.1\:3306/db

    jdbc.username=root

    jdbc.password=yujinxiang

SQLser:    

    jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver

    jdbc.url=jdbc:sqlserver://192.168.2.13:21985;DatabaseName=db

    jdbc.username=sa

    jdbc.password=12345678

oracle:

    jdbc.driver=oracle.jdbc.driver.OracleDriver

    jdbc.url=jdbc:oracle:thin:@192.168.2.123:1521:orcl

    jdbc.username=user

    jdbc.password=pass

JAVA的JDBC链接方式

    public class MysqlConnUtil {

     String dbDriver;

     String dbUri;

     String dbName;

     String dbPass;

    

     public MysqlConnUtil() {

     super();

     loadDBconfig();

     }

    

     // 读取数据库配置信息

     void loadDBconfig() {

     InputStream is = this.getClass().getResourceAsStream(

     "sqldb.properties");

     Properties p = new Properties();

     try {

     p.load(is);

     dbDriver = p.getProperty("jdbc.driver");

     dbUri = p.getProperty("jdbc.url");

     dbName = p.getProperty("jdbc.username");

     dbPass = p.getProperty("jdbc.password");

     p.clear();

     is.close();

     } catch (Exception e) {

     e.printStackTrace();

     }

     }

    

       public  Connection getConnection() {

     Connection conn = null;

     try {

     Class.forName(dbDriver);

     conn = DriverManager.getConnection(dbUri, dbName, dbPass);

     } catch (Exception e) {

     e.printStackTrace();

     }

     return conn;

     }

    ｝

如有疑问 请留言 欢迎提供建议