开始
我们这次的作业是从 Oracle生成XML 把这个XML解析出来给SqlServer
卸载我们开始:生成一个Properties文件 把这两个数据库的链接词账号密码保存进去当我们需要的时候 get一下就ok ()
准备好 两个数据库的连接词 我这里做了一个晓晓的封装
public class Cons {
static String path = "F://xx.xml" ;
static Properties properties = new Properties();
public static void load(){
try {
properties.load( new FileInputStream( path ));
} catch (Exception e) {
e.printStackTrace();
}
}
public static void builder () throws FileNotFoundException, IOException{
Properties properties = new Properties();
OutputStream stream = new FileOutputStream( "F://xx.xml" );
properties.setProperty("Oracle","oracle.jdbc.driver.OracleDriver,jdbc:oracle:thin://127.0.0.1:1521:orcl,scott,accp" );
properties.setProperty("SqlServer", "com.microsoft.sqlserver.jdbc.SQLServerDriver,jdbc:sqlserver://localhost:1433;databaseName=USERS,sa,123");
properties.store( stream , "连接词" );
stream.close();
}
public static String[] getOracle () throws FileNotFoundException, IOException{
builder();
load();
String Oralce = properties.getProperty("Oracle");
String[] Oralces = Oralce.split(",");
return Oralces;
}
public static String[] getSqlServer(){
String Sqlserver = properties.getProperty("SqlServer");
String[] sqlServers = Sqlserver.split(",");
return sqlServers;
}
}
BaseDao
同样BaseDao 也根据上面的方法进行封装啦
我只需要 传进去一个数组就ok啦 而数组 就从上面的方法既可以得到啦
public static Connection getCon(String[] s){
Connection con = null;
try {
Class.forName( s[0] );
con = DriverManager.getConnection( s[1],s[2],s[3]);
} catch (Exception e) {
e.printStackTrace();
}
return con;
}