註冊磁碟機並擷取串連

標籤：io   os   sp   for   檔案   on   cti   bs   ad   

1.三種註冊磁碟機的方法

(1)Class.forName("com.mysql.jdbc.Driver");

(2)System.setProperty("jdbc.drivers","com.mysql.jdbc.Driver");

(3)極不推薦 DriverManager.registerDrivers(new com.mysql.jdbc.Driver());

3.三種擷取串連的方式

(1)Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123456");

(2)Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test?user=root&password=123456");

(3)Connection conn=DriverManager.getConnection(strUrl,props);

database.properties設定檔

jdbc.drivers=com.mysql.jdbc.Driver

jdbc.url=jdbc:mysql://localhost:3306/test

jdbc.user=root

jdbc.password=123456

...

 

Properties props=new Properties();

FileInputStream in=new FileInputStream("database.properties");  //擷取database.properties設定檔

props.load(in);

in.close();

String strDriver=props.getProperty("jdbc.drivers");

String strUrl=props.getProperty("jdbc.url");

System.setProperty("jdbc.drivers",strDriver);　

Connection conn=DriverManager.getConnection(strUrl,props);

註冊磁碟機並擷取串連