?? dbconnection.java
字號:
package cn.com.edu.gui.model;
import java.io.File;
import java.io.FileInputStream;
import java.sql.*;
import java.util.Enumeration;
import java.util.Properties;
public class DBConnection {
public static Connection getConnect(Properties pro,String dbType){
Connection con = null;
try{
Enumeration enumer = pro.propertyNames();
String name= null;
while(enumer.hasMoreElements()){
name= (String)enumer.nextElement();
if(name.startsWith(dbType)){
String orl = name.substring(0,name.lastIndexOf('.'));
String driver = pro.getProperty(orl+".driver");
String url = pro.getProperty(orl+".url");
String user = pro.getProperty(orl+".user");
String pwd = pro.getProperty(orl+".password");
Class.forName(driver);
con = DriverManager.getConnection(url,user,pwd);
return con;
}
}
}catch(Exception e){
System.out.println(e.getMessage());
}
return con;
}
public static Properties getProperties(){
Properties pro = new Properties();
File f = new File("db.properties");
try{
FileInputStream in = new FileInputStream(f);
pro.load(in);
}catch(Exception e){
System.out.println(e.getMessage());
}
return pro;
}
public static void main(String[] args){
Connection con=getConnect(getProperties(),"oracle");
if(con!=null){
System.out.println("數據庫連接成功");
}else{
System.out.println("數據庫連接失敗");
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -