xml文件:Conn.xml
<?xml version="1.0" encoding="utf-8"?>
<reportenv>
<datasource>
<host>127.0.0.1</host>
<database>test</database>
<username>root</username>
<password>******</password>
</datasource>
</reportenv>
读取xml文件:ReadConfigXml.java
package classes;
import org.xml.sax.Attributes;
import org.xml.sax.helpers.DefaultHandler;
import org.xml.sax.SAXException;
import java.util.Properties;
import javax.xml.parsers.SAXParser;
import javax.xml.parsers.SAXParserFactory;
import java.net.URL;
class ConfigParser extends DefaultHandler {
定义一个Properties 用来存放属性值
private Properties props;
private String currentSet;
private String currentName;
private StringBuffer currentValue = new StringBuffer();
//构建器初始化props
public ConfigParser() {
this.props = new Properties();
}
public Properties getProps() {
return this.props;
}
//定义开始解析元素的方法. 这里是将<xxx>中的名称xxx提取出来.
public void startElement(String uri, String localName, String qName, Attributes attributes)
throws SAXException {
currentValue.delete(0, currentValue.length());
this.currentName =qName;
}
//这里是将<xxx></xxx>之间的值加入到currentValue
public void characters(char[] ch, int start, int length) throws SAXException {
currentValue.append(ch, start, length);
}
//在遇到</xxx>结束后,将之前的名称和值一一对应保存在props中
public void endElement(String uri, String localName, String qName) throws SAXException {
props.put(qName.toLowerCase(), currentValue.toString().trim());
}
}
class ParseXML{
//定义一个Properties 用来存放属性值
private Properties props;
public Properties getProps() {
return this.props;
}
public void parse(String filename) throws Exception {
//将我们的解析器对象化
ConfigParser handler = new ConfigParser();
//获取SAX工厂对象
SAXParserFactory factory = SAXParserFactory.newInstance();
factory.setNamespaceAware(false);
factory.setValidating(false);
//获取SAX解析
SAXParser parser = factory.newSAXParser();
try{
//将解析器和解析对象xml联系起来,开始解析
parser.parse(filename, handler);
//获取解析成功后的属性
props = handler.getProps();
}finally{
factory=null;
parser=null;
handler=null;
}
}
}
public class ReadConfigXml
{
private Properties props;
public ReadConfigXml(String url){
ParseXML myRead = new ParseXML();
try {
myRead.parse(url);
props = new Properties();
props = myRead.getProps();
} catch (Exception e) {
e.printStackTrace();
}
}
public String getHost(){
return props.getProperty("host");
}
public String getDataBase(){
return props.getProperty("database");
}
public String getUserName(){
return props.getProperty("username");
}
public String getPassWord(){
return props.getProperty("password");
}
}
连接数据库:Conn.java
//--------------数据库连接---------------------
class Conn{
private Connection conn = null;
private Statement stmt = null;
public static void main(String args[]){
try{ //加载驱动
Class.forName("com.mysql.jdbc.Driver").newInstance();
System.out.println("Success loading Mysql Driver!");
}catch(Exception e){
System.out.println("Error loading Mysql Driver!");
}
ReadConfigXml r = new ReadConfigXml("Conn.xml"); //读取xml文件中数据库相关信息
try{ //连接数据库
conn = DriverManager.getConnection("jdbc:mysql://"+r.getHost()+"/"+r.getDataBase()+"?user="+r.getUserName()+"&password="+r.getPassWord()+"&characterEncoding=gb2312");
System.out.println("Success connect Mysql Database!");
}catch(SQLException e){
System.out.println(e.getMessage());
}
}
}
<?xml version="1.0" encoding="utf-8"?>
<reportenv>
<datasource>
<host>127.0.0.1</host>
<database>test</database>
<username>root</username>
<password>******</password>
</datasource>
</reportenv>
读取xml文件:ReadConfigXml.java
package classes;
import org.xml.sax.Attributes;
import org.xml.sax.helpers.DefaultHandler;
import org.xml.sax.SAXException;
import java.util.Properties;
import javax.xml.parsers.SAXParser;
import javax.xml.parsers.SAXParserFactory;
import java.net.URL;
class ConfigParser extends DefaultHandler {
定义一个Properties 用来存放属性值
private Properties props;
private String currentSet;
private String currentName;
private StringBuffer currentValue = new StringBuffer();
//构建器初始化props
public ConfigParser() {
this.props = new Properties();
}
public Properties getProps() {
return this.props;
}
//定义开始解析元素的方法. 这里是将<xxx>中的名称xxx提取出来.
public void startElement(String uri, String localName, String qName, Attributes attributes)
throws SAXException {
currentValue.delete(0, currentValue.length());
this.currentName =qName;
}
//这里是将<xxx></xxx>之间的值加入到currentValue
public void characters(char[] ch, int start, int length) throws SAXException {
currentValue.append(ch, start, length);
}
//在遇到</xxx>结束后,将之前的名称和值一一对应保存在props中
public void endElement(String uri, String localName, String qName) throws SAXException {
props.put(qName.toLowerCase(), currentValue.toString().trim());
}
}
class ParseXML{
//定义一个Properties 用来存放属性值
private Properties props;
public Properties getProps() {
return this.props;
}
public void parse(String filename) throws Exception {
//将我们的解析器对象化
ConfigParser handler = new ConfigParser();
//获取SAX工厂对象
SAXParserFactory factory = SAXParserFactory.newInstance();
factory.setNamespaceAware(false);
factory.setValidating(false);
//获取SAX解析
SAXParser parser = factory.newSAXParser();
try{
//将解析器和解析对象xml联系起来,开始解析
parser.parse(filename, handler);
//获取解析成功后的属性
props = handler.getProps();
}finally{
factory=null;
parser=null;
handler=null;
}
}
}
public class ReadConfigXml
{
private Properties props;
public ReadConfigXml(String url){
ParseXML myRead = new ParseXML();
try {
myRead.parse(url);
props = new Properties();
props = myRead.getProps();
} catch (Exception e) {
e.printStackTrace();
}
}
public String getHost(){
return props.getProperty("host");
}
public String getDataBase(){
return props.getProperty("database");
}
public String getUserName(){
return props.getProperty("username");
}
public String getPassWord(){
return props.getProperty("password");
}
}
连接数据库:Conn.java
//--------------数据库连接---------------------
class Conn{
private Connection conn = null;
private Statement stmt = null;
public static void main(String args[]){
try{ //加载驱动
Class.forName("com.mysql.jdbc.Driver").newInstance();
System.out.println("Success loading Mysql Driver!");
}catch(Exception e){
System.out.println("Error loading Mysql Driver!");
}
ReadConfigXml r = new ReadConfigXml("Conn.xml"); //读取xml文件中数据库相关信息
try{ //连接数据库
conn = DriverManager.getConnection("jdbc:mysql://"+r.getHost()+"/"+r.getDataBase()+"?user="+r.getUserName()+"&password="+r.getPassWord()+"&characterEncoding=gb2312");
System.out.println("Success connect Mysql Database!");
}catch(SQLException e){
System.out.println(e.getMessage());
}
}
}