資源簡介
本文是題為民航管理售票系統的數據庫系統,含有代碼實現
代碼片段和文件信息
package?qxz;
import?java.sql.*;
import?javax.swing.JComboBox;
import?javax.swing.JList;
import?javax.swing.JOptionPane;
import?javax.swing.table.DefaultTableModel;
public?class?Database?{
public?static?Connection?cn;
public?static?Statement?st;
public?static?Statement?st2;
public?static?ResultSet?rs;
public?static?String?dbms;
//?below?for?SQL?Server
static?String?user?=?ConfigIni.getIniKey?(“UserID“);
static?String?pwd??=?ConfigIni.getIniKey?(“Password“);
static?String?ip???=?ConfigIni.getIniKey?(“IP“);
static?String?acc??=?ConfigIni.getIniKey?(“Access“);
static?String?dbf??=?ConfigIni.getIniKey?(“Database“);
//?below?for?Oracle
static?String?UID=ConfigIni.getIniKey?(“UID“);
static?String?Passd=ConfigIni.getIniKey?(“Passd“);
static?String?Server=ConfigIni.getIniKey?(“Server“);
static?String?DB=ConfigIni.getIniKey?(“DB“);
static?String?Port=ConfigIni.getIniKey?(“Port“);
//?below?for?MySQL
static?String?UID2=ConfigIni.getIniKey?(“UID2“);
static?String?Passd2=ConfigIni.getIniKey?(“Passd2“);
static?String?Server2=ConfigIni.getIniKey?(“Server2“);
static?String?DB2=ConfigIni.getIniKey?(“DB2“);
static?String?Port2=ConfigIni.getIniKey?(“Port2“);
//?below?for?PostgreSQL
static?String?UID3=ConfigIni.getIniKey?(“UID3“);
static?String?Passd3=ConfigIni.getIniKey?(“Passd3“);
static?String?Server3=ConfigIni.getIniKey?(“Server3“);
static?String?DB3=ConfigIni.getIniKey?(“DB3“);
static?String?Port3=ConfigIni.getIniKey?(“Port3“);
static?{
??try?{
????if(ConfigIni.getIniKey?(“Default_link“).equals?(“1“))?{//JDBC--SQL?Server?2005
??DriverManager.registerDriver?(new?com.microsoft.sqlserver.jdbc.SQLServerDriver());??//注冊驅動
??String?url=“jdbc:sqlserver://“+ip+“:“+acc+“;“+“databasename=“+dbf;//獲得一個連接
??cn?=?DriverManager.getConnection?(url?user?pwd);
??dbms=“SQL?Server“;
}
else?if(ConfigIni.getIniKey?(“Default_link“).equals?(“2“))?{//JDBC-SQL?Server?2000
DriverManager.registerDriver?(new?com.microsoft.jdbc.sqlserver.SQLServerDriver());?//注冊驅動
String?url??=?“jdbc:microsoft:sqlserver://“?+?ip?+?“:“?+?acc?+?“;“?+?“databasename=“?+?dbf;???//獲得一個連接
cn?=?DriverManager.getConnection?(url?user?pwd);
dbms=“SQL?Server“;
}
else?if(ConfigIni.getIniKey?(“Default_link“).equals?(“4“))?{//JDBC-ODBC?to?Oracle
DriverManager.registerDriver(new?sun.jdbc.odbc.JdbcOdbcDriver());
cn?=?DriverManager.getConnection?(“jdbc:odbc:“+ConfigIni.getIniKey(“linkNameORA“).trim()UIDPassd);?//獲得一個連接
dbms=“Oracle“;
}
else?if(ConfigIni.getIniKey?(“Default_link“).equals?(“5“))?{//JDBC?to?Oracle
? ???DriverManager.registerDriver(new?oracle.jdbc.driver.OracleDriver());
???String?url?=?“jdbc:oracle:thin:@“+Server+“:“+Port+“:“+DB;
???cn?=DriverManager.getConnection?(url?UID?Passd);
???dbms=“Oracle“;
}
else?if(ConfigIni.getIniKey(“Default_link“).equals?(“6“))?{//JDBC?to?MySQL
???try?{?Class.forName(“com.mysql.jdbc.Driver“).newInstance();
???}?catch?(Exception?ex)?{??}
????????String?ur
評論
共有 條評論