-Rice Zone-

accp.bbs.xml.ConfigServlet

package accp.bbs.xml;

import java.io.IOException;
import java.io.InputStream;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;

import org.jdom.Document;
import org.jdom.Element;
import org.jdom.JDOMException;
import org.jdom.input.SAXBuilder;

import accp.bbs.db.ConDB;

public class ConfigServlet extends HttpServlet {

    public ConfigServlet() {
 super();
    }

    public void destroy() {
 super.destroy();
    }

    public void init() throws ServletException {
 try{
       initConfigXML();
     }catch(Exception e){
       e.printStackTrace();
     }
    }
   
    protected void initConfigXML() throws JDOMException, IOException{ 
 
 //从web.xml读取<init-param>元素值
 String configfile = getServletConfig().getInitParameter("configXML");
 //将<init-param>值指向的xml文件写入服务器内存
 InputStream input = getServletContext().getResourceAsStream(configfile);
 
 //jdom解析xml文件
 String dbUser,dbPwd,url,driver;
 SAXBuilder builder = new SAXBuilder();
 Document doc = builder.build(input);
 Element root = doc.getRootElement();
 dbUser = root.getChildText("dbUserName");
 dbPwd = root.getChildText("dbUserPwd");
 url = root.getChildText("dbUrl");
 driver = root.getChildText("dbDriver"); 
 //配置数据库Connection
 ConDB.setDriver(driver);
 ConDB.setUrl(url);
 ConDB.setDbUser(dbUser);
 ConDB.setDbPwd(dbPwd);
    }
}

----------------------------无敌分割线二号----------------------------

/WEB-INF/XML/accp_bbs.xml

<?xml version="1.0" encoding="UTF-8"?>
<accp_bbs>
 <dbDriver>com.microsoft.jdbc.sqlserver.SQLServerDriver</dbDriver>
 <dbUrl>jdbc:microsoft:sqlserver://localhost:1433;databasename=bbsDB</dbUrl>
 <dbUserName>accpbbs</dbUserName>
 <dbUserPwd>accpbbs</dbUserPwd>
</accp_bbs>

---------------------------无敌分割线终结版？-------------------------

accp.bbs.db.ConDB

package accp.bbs.db;

import java.sql.*;

public class ConDB {
 
    private static String driver ;

    private static String url;

    private static String dbUser;

    private static String dbPwd;

    public ConDB() {

    }

    // 返回Connection对象
 public static Connection getConnection() {
 Connection con = null;
 try {
     Class.forName(driver);
     con = DriverManager.getConnection(url, dbUser, dbPwd);
 } catch (ClassNotFoundException ex) {
     ex.printStackTrace();
 } catch (SQLException ex) {
     ex.printStackTrace();
 }
 return con;
 }

    public static void setDbPwd(String dbPwdi) {
 dbPwd = dbPwdi;
    }

    public static void setDbUser(String dbUseri) {
 dbUser = dbUseri;
    }

    public static void setDriver(String driveri) {
 driver = driveri;
    }

    public static void setUrl(String urli) {
 url = urli;
    }
}

---------------------------无敌分割线终结版---------------------------

我不信有人能看完...仅希望对以后的我有所帮助

---完