JAVA/读取XML文件中SQLSERVER数据源配置(sax)

 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 getServerName() {
  return props.getProperty("servername");
 }

 public String getServerPort(){
  return props.getProperty("serverport");
 }
 
 public String getDatabaseName() {
  return props.getProperty("databasename");
 }

 public String getUserName() {
  return props.getProperty("username");
 }

 public String getPassWord() {
  return props.getProperty("password");
 }

}

数据库连接类:DBConnection.java

package com.onchen.data.operator;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import com.onechen.data.config.ReadConfigXml;

public class DBConnection {

 private Connection con;
 
 private DBConnection() {
  
 }

 public static DBConnection newInstance(){
  return new DBConnection();
 }
 
 public Connection getConnection(){
  ReadConfigXml r = new ReadConfigXml("mssql.xml");    //读取xml文件中数据库相关信息
  String url = "jdbc:microsoft:sqlserver://"+r.getServerName()+":"+r.getServerPort()
                     +";DatabaseName="+r.getDatabaseName();
  String username = r.getUserName();
  String password = r.getPassWord();
  try {
   Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
   con = DriverManager.getConnection(url, username, password);
  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException e) {
   e.printStackTrace();
  }
  return con;
 }
 

  //测试连接
  public static void main(String args[]){
   Connection con = DBConnection.newInstance().getConnection();
  }
}