那就写个.properties文件,里面包括这么几项
driver=COM.ibm.db2.jdbc.net.DB2Driver
url=jdbc:db2://localhost:6789/SAMPLE
user=db2admin
password=dove
用java.util.Properties读取你得properties文件就行了
driver=COM.ibm.db2.jdbc.net.DB2Driver
url=jdbc:db2://localhost:6789/SAMPLE
user=db2admin
password=dove
用java.util.Properties读取你得properties文件就行了
p.load(new java.io.FileInputStream ("conf/Database.properties")) ;
connectstring = (String)p.get("ConnectionString") ;
username = (String)p.get("Username") ;
password = (String)p.get("Password") ;
//return "0";
// System.out.println(connectstring+ "*******"+username+"@@@@@@@@@@"+password);
}catch(Exception e){
System.out.println(e.getMessage() );
}
//ConnectionFactory.java
package connectionfactory;import java.sql.*;
import java.util.Properties;public class ConnectionFactory {
String filename;
static Properties p;
public ConnectionFactory(String filename) {
this.filename=filename;
}
public Connection getConnection() throws SQLException {
try{
Properties p = new Properties() ;
p.load(new java.io.FileInputStream (filename)) ;
Class.forName(p.getProperty("jdbcdriver"));
return DriverManager.getConnection(p.getProperty("urlConnection"));
}catch (Exception e) {e.printStackTrace();return null;}
} public static void main(String[] args){
try{
ConnectionFactory temp=new ConnectionFactory(args[0]);
Statement stmt=temp.getConnection().createStatement();
ResultSet result=null;
result = stmt.executeQuery("select * from Course");
while (result.next()){
String id=result.getString(1);
System.out.println(id);
}
}catch (Exception e) {e.printStackTrace();}
}
}2、属性文件database.properties内容
jdbcdriver=sun.jdbc.odbc.JdbcOdbcDriver
urlConnection=jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=d:\\testsql1.mdb;user="";password=""3、执行
F:\java>javac ConnectionFactory.java -d .F:\java>java connectionfactory.ConnectionFactory database.properties
1
2
3
4
5
6
7
部分:
#connection types = pooling, direct
system.database.connection.type=directsystem.database.connection.pooling.initialContextFactory=weblogic.jndi.WLInitialContextFactory
system.database.connection.pooling.providerURL=t3://localhost:7001
system.database.connection.pooling.dataSourceName=XXXXXX#specify = config, appServer, default
#"default" is equal to "appServer".
system.database.connection.direct.specify=default
#system.database.connection.direct.userID=scott
#system.database.connection.direct.password=tiger
system.database.connection.direct.url=jdbc:weblogic:pool:ttg
system.database.connection.direct.driverName=weblogic.jdbc.pool.Driver
修改配置不重新启动应用程序?--这得看服务气的实现。有的实现方式是应用程序第一次启动的时候,就把配置文件给读入了内存。所以修改了配置文件得重新启动项目/服务器
谁能告诉我怎么用XML编?