使用java语言编写的数据库连接池,实现数据库与jsp文件的连接.zip

package admin.dbmanagement; import java.net.URI; public class DBParameterConfiger { private DBParameterConfiger() { } public static void main(String[] args) { DBParameterConfiger DBParameterConfiger1 = new DBParameterConfiger(); try{ DBParameterConfiger1.reloadProp(null); }catch(Exception e){ System.out.println(e.toString()); } } private static DBParameterConfiger myDBParameterConfiger=null; private static java.util.Properties dbparameters=null; public static DBParameterConfiger getInstance(){ synchronized("DBParameterConfiger"){ if(DBParameterConfiger.myDBParameterConfiger==null){ DBParameterConfiger.myDBParameterConfiger=new DBParameterConfiger(); } } return DBParameterConfiger.myDBParameterConfiger; } public java.util.Properties reloadProp(java.util.Properties prop) throws java.lang.Exception{ synchronized(this){ try{ try{ if(this.dbparameters==null){ this.dbparameters=new java.util.Properties(); java.io.File file=new java.io.File("conf","conf.xml"); javax.xml.parsers.DocumentBuilderFactory dbf=javax.xml.parsers.DocumentBuilderFactory.newInstance(); javax.xml.parsers.DocumentBuilder db=dbf.newDocumentBuilder(); //root node org.w3c.dom.Document doc=db.parse(file); org.w3c.dom.NodeList nodelist=doc.getChildNodes(); //first node org.w3c.dom.Node node=nodelist.item(0); org.w3c.dom.NodeList nodeChildlist=node.getChildNodes(); int childindex=nodeChildlist.getLength(); for(int i=0;i<childindex;i++){ //seconde node org.w3c.dom.Node nodeChild=nodeChildlist.item(i); if(nodeChild.getNodeType()==org.w3c.dom.Node.TEXT_NODE){ }else{ org.w3c.dom.Node nodechildchild=nodeChild.getChildNodes().item(0); this.dbparameters.put(nodeChild.getNodeName(),nodechildchild.getNodeValue().trim()); System.out.println(nodechildchild.getNodeValue().trim()); } } }//end of if(this.dbparameters==null) }catch(Exception e){ throw new Exception("从配置参数文件中读数错误！"+e.toString()); // System.out.println(e.toString()); } try{ if(prop==null){ java.util.Properties propReturn=(java.util.Properties )this.dbparameters.clone(); return propReturn; } }catch(Exception e){ throw new Exception("数据参数属性页拷贝复制错误!"+e.toString()); } try{ this.dbparameters=new java.util.Properties(); java.io.File file=new java.io.File("conf","conf.xml"); javax.xml.parsers.DocumentBuilderFactory dbf=javax.xml.parsers.DocumentBuilderFactory.newInstance(); javax.xml.parsers.DocumentBuilder db=dbf.newDocumentBuilder(); //root node org.w3c.dom.Document doc=db.parse(file); org.w3c.dom.NodeList nodelist=doc.getChildNodes(); //first node org.w3c.dom.Node node=nodelist.item(0); org.w3c.dom.NodeList nodeChildlist=node.getChildNodes(); int childindex=nodeChildlist.getLength(); for(int i=0;i<childindex;i++){ //seconde node org.w3c.dom.Node nodeChild=nodeChildlist.item(i); if(nodeChild.getNodeType()==org.w3c.dom.Node.TEXT_NODE){ }else{ org.w3c.dom.Node nodechildchild=nodeChild.getChildNodes().item(0); if(nodeChild.getNodeName().equalsIgnoreCase("Databasetype")){ this.dbparameters.put("Databasetype",prop.get("Databasetype")); nodechildchild.setNodeValue(prop.get("Databasetype").toString()); } else if(nodeChild.getNodeName().equalsIgnoreCase("DatabaseDirver")){ this.dbparameters.put("DatabaseDirver",prop.get("DatabaseDirver")); nodechildchild.setNodeValue(prop.get("DatabaseDirver").toString()); } else if(nodeChild.getNodeName().equalsIgnoreCase("DatabaseUrl")){ this.dbparameters.put("DatabaseUrl",prop.get("DatabaseUrl")); nodechildchild.setNodeValue(prop.get("DatabaseUrl").toString()); } else if(nodeChild.getNodeName().equalsIgnoreCase("DatabaseUser")){ this.dbparameters.put("DatabaseUser",prop.get("DatabaseUser")); nodechildchild.setNodeValue(prop.get("DatabaseUser").toString()); } else if(nodeChild.getNodeName().equalsIgnoreCase("DatabasePassword")){ this.dbparameters.put("DatabasePassword",prop.get("DatabasePassword")); nodechildchild.setNodeValue(prop.get("DatabasePassword").toString()); } else if(nodeChild.getNodeName().equalsIgnoreCase("DatabasePoolsize")){ this.dbparameters.put("DatabasePoolsize",prop.get("DatabasePoolsize")); nodechildchild.setNodeValue(prop.get("DatabasePoolsize").toString()); } System.out.println(nodechildchild.getNodeValue().trim()); } } return this.dbparameters; }catch(Exception e){ throw new Exception("设置数据参数属性页错误!"+e.toString()); } }catch(Exception e){ this.dbparameters=null; throw new Exception(e.toString()); } } } }