|
/**
? * 读取properties文件内容，放到Dbdata对象中
? * getProp
? * @param filePath
? * @return
? * @throws IOException
? * @author tf.li
? * @data Feb 28,2011
? */
?public Dbdata getProp(String filePath) throws IOException {
??Dbdata dbData = new Dbdata();
??Properties props = new Properties();
??InputStream ips = null;
??ips = new BufferedInputStream(new FileInputStream(filePath));
??props.load(ips);
?
??ips.close();
??
??// 将键值逐一从property中取出
??if(props.getProperty("jdbc.driverClassName") != null) { //properties文件中有内容
???String url = props.getProperty("jdbc.url");
???String username = props.getProperty("jdbc.username");
???String password = props.getProperty("jdbc.password");
???String maxActive = props.getProperty("jdbc.maxActive");
???
???dbData.setUserName(username);
???dbData.setPass(password);
???dbData.setMaxActive(maxActive);
???
???String[] urlArr = url.split(":");
???for(int i=0; i<urlArr.length; i++) {
????if("mysql".equalsIgnoreCase(urlArr[i])) { //数据库是mysql
?????dbData.setDatabaseType(1);
?????//url="jdbc:mysql://localhost:3306/ngbstzq?zeroDateTimeBehavior=convertToNull";
?????dbData.setUrl(urlArr[2].substring(2));
?????String[] portDbname = urlArr[3].split("/");
?????dbData.setPort(portDbname[0]);
?????dbData.setDatabaseName(portDbname[1].split("//?")[0]);
?????break;
????} else if("sqlserver".equalsIgnoreCase(urlArr[i])) { //数据库是sqlserver
?????dbData.setDatabaseType(2);
?????//url="jdbc:jtds:sqlserver://localhost:1433;databaseName=ngbstzq;SelectMethod=cursor";
?????dbData.setUrl(urlArr[3].substring(2));
?????String[] portDbname = urlArr[4].split(";");
?????dbData.setPort(portDbname[0]);
?????dbData.setDatabaseName(portDbname[1].split("=")[1]);
?????break;
????}
???}
??}
??return dbData;
?}
?
?
其中properties文件格式如下：
?
jdbc.driverClassName = com.mysql.jdbc.Driverjdbc.url = jdbc:mysql://localhost:3306/ngbstzq?zeroDateTimeBehavior=convertToNulljdbc.username = rootjdbc.password = 123jdbc.maxActive = 20
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
