1.DB.java
package com.bn.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Iterator;
import java.util.Properties;
import org.dom4j.Document;
import org.dom4j.DocumentException;
import org.dom4j.Element;
import org.dom4j.io.SAXReader;
public class DB {
private static String dbServer;
private static String dbName;
private static String dbUser;
private static String dbPwd;
//java 專案 www.fhadmin.org
public void readXML(){
SAXReader sr = new SAXReader();//獲取讀取xml的物件，
Document doc = null;
String path1 = String.valueOf(Thread.currentThread().getContextClassLoader().getResource(""));
//System.out.println(path1);
path1 = path1 + "../DB.xml";
//System.out.println(path1);
try {
doc = sr.read(path1);
} catch (DocumentException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}//得到xml所在位置，然后開始讀取，并將資料放入doc中
Element el_root = doc.getRootElement();//向外取資料，獲取xml的根節點，
Iterator it = el_root.elementIterator();//從根節點下依次遍歷，獲取根節點下所有子節點
while(it.hasNext()){//遍歷該子節點
Object o = it.next();//再獲取該子節點下的子節點
Element el_row = (Element)o;
String s = el_row.getText();
Iterator it_row = el_row.elementIterator();
int i =1;
while(it_row.hasNext()){//遍歷節點
Element el_ename = (Element)it_row.next();//獲取該節點下的所有資料，
if(i == 1){
this.setDbServer(el_ename.getText());
//System.out.println(this.getDbServer());
//dbServer = el_ename.getText();
}
if(i == 2){
this.setDbName(el_ename.getText());
// System.out.println(this.getDbName());
//dbName = el_ename.getText();
}
if(i == 3){
this.setDbUser(el_ename.getText());
// System.out.println(this.getDbUser());
//dbUser = el_ename.getText();
}
if(i == 4){
this.setDbPwd(el_ename.getText());
// System.out.println(this.getDbPwd());
//dbPwd = el_ename.getText();
}
// System.out.println(i);
i++;
//System.out.println(el_ename.getText());
}
//System.out.println(o);
}
}
static {
DB dbxml = new DB();
dbxml.readXML();
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static Connection createConn(){
DB dbxml = new DB();
//String name = dbxml.dbName;
//System.out.println(name);
//System.out.println(dbxml.getDbServer() + dbxml.getDbName() + dbxml.getDbUser() + dbxml.getDbPwd());
Connection conn = null;
try {
conn = DriverManager.getConnection("jdbc:mysql://"+ dbxml.getDbServer() +":3306/"+ dbxml.getDbName() +"?user="+ dbxml.getDbUser() +"&password="+ dbxml.getDbPwd());
//conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/bnss?user=root&password=root");
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
public static PreparedStatement createPstmt(Connection conn, String sql){
PreparedStatement pstmt = null;
try {
pstmt = conn.prepareStatement(sql);
} catch (SQLException e) {
e.printStackTrace();
}
return pstmt;
}
public static void close(Connection conn){
if(conn == null)return;
try {
conn.close();
conn = null;
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void close(Statement stmt){
try {
stmt.close();
stmt = null;
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void close(ResultSet rs){
try {
rs.close();
rs = null;
} catch (SQLException e) {
e.printStackTrace();
}
}
public String getDbName() {
return dbName;
}
public void setDbName(String dbName) {
this.dbName = dbName;
}
public String getDbServer() {
return dbServer;
}
public String getDbUser() {
return dbUser;
}
public String getDbPwd() {
return dbPwd;
}
public void setDbServer(String dbServer) {
this.dbServer = dbServer;
}
public void setDbUser(String dbUser) {
this.dbUser = dbUser;
}
public void setDbPwd(String dbPwd) {
this.dbPwd = dbPwd;
}
}
2.ParseXML.java
package com.bn.util;
import java.util.Properties;
import javax.xml.parsers.ParserConfigurationException;
import javax.xml.parsers.SAXParser;
import javax.xml.parsers.SAXParserFactory;
import org.xml.sax.SAXException;
import java.net.URL;
//java專案www.fhadmin.org
public class ParseXML{
//定義一個Properties 用來存放 dbhost dbuser dbpassword的值
private Properties props;
//這里的props
public Properties getProps() {
return this.props;
}
public void parse(String filename) {
//將我們的決議器物件化
ConfigParser handler = new ConfigParser();
//獲取SAX工廠物件
SAXParserFactory factory = SAXParserFactory.newInstance();
factory.setNamespaceAware(false);
factory.setValidating(false);
//獲取SAX決議
SAXParser parser=null;
try {
parser = factory.newSAXParser();
} catch (Exception e1) {
e1.printStackTrace();
}
URL confURL = null;
//得到組態檔myenv.xml所在目錄. tomcat中是在WEB-INF/classes
//下例中BeansConstants是用來存放xml檔案中配置資訊的類,可以自己代替或定義
try{
confURL = ParseXML.class.getClassLoader().getResource(filename);
//只需要將我們所需要的XML檔案名字輸入進去就可以了！
}catch(Exception e){
System.out.print(e.toString());
}
try
{ //將決議器和決議物件myenv.xml聯系起來,開始決議
parser.parse(confURL.toString(), handler);
//獲取決議成功后的屬性 以后 我們其他應用程式只要呼叫本程式的props就可以提取出屬性名稱和值了
props = handler.getProps();
}catch(Exception e){
System.out.println(e.toString());
}finally{
factory=null;
parser=null;
handler=null;
}
}
}3.ConfigParser.java
package com.bn.util;
import org.xml.sax.Attributes;
import org.xml.sax.helpers.DefaultHandler;
import org.xml.sax.SAXException;
import java.util.Properties;
//使用DefaultHandler的好處 是 不必陳列出所有方法,
//java專案www.fhadmin.org
public class ConfigParser extends DefaultHandler {
////定義一個Properties 用來存放 dbhost dbuser dbpassword的值
private Properties props;
private String currentSet;
private String currentName;
private StringBuffer currentValue = https://www.cnblogs.com/teacher11/archive/2021/06/24/new StringBuffer();
//構建器初始化props
public ConfigParser() {
this.props = new Properties();
}
public Properties getProps() {
return this.props;
}
//定義開始決議元素的方法. 這里是將中的名稱xxx提取出來.
public void startElement(String uri, String localName, String qName, Attributes attributes)throws SAXException {
currentValue.delete(0, currentValue.length());
this.currentName =qName;
}
//這里是將 結束后,將之前的名稱和值一一對應保存在props中
public void endElement(String uri, String localName, String qName) throws SAXException {
props.put(qName.toLowerCase(), currentValue.toString().trim());
}
}轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/288365.html
標籤：其他