81,092
社区成员
发帖
与我相关
我的任务
分享
package com.Xml.dom4j;
import java.io.File;
import org.dom4j.Document;
import org.dom4j.DocumentException;
import org.dom4j.Element;
import org.dom4j.io.SAXReader;
public class MyDom4j {
private static Document doc;
private static SAXReader saxReader;
private static Element element;
private static File getFile(String filePath)
{
File file = new File(filePath);
return file;
}
public Element getDocument(String filePath)
{
try {
File file = getFile(filePath);
saxReader = new SAXReader();
doc = saxReader.read(file);
element = doc.getRootElement();
} catch (DocumentException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
return element;
}
}
package com.source.DAO;
import java.sql.*;
import org.dom4j.Element;
import java.util.Iterator;
import com.Xml.dom4j.MyDom4j;
public class DBConnection {
private String url = "";
private String driver ="";
private String password = "";
private String user = "";
private Element e ;
private Element element;
private Connection conn = null;
public DBConnection(String xPath)
{
MyDom4j dom4j = new MyDom4j();
e = dom4j.getDocument(xPath);
for(Iterator it = e.elementIterator("connection");it.hasNext();)
{
element = (Element)it.next();
}
this.url = element.elementText("url");
this.driver = element.elementText("driver");
this.password = element.elementText("pwd");
this.user = element.elementText("user");
}
private Connection setConn()
{
try {
Class.forName(driver);
conn = DriverManager.getConnection(url, user, password);
} catch (ClassNotFoundException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
return conn;
}
public Connection getConn()
{
return setConn();
}
public void closeConn()
{
try {
conn.close();
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
}