在J2EE的开发中,我们最开始的时候就是搭建工程,建立数据库的基本连接和框架。以及一些基本的公共类。
首先就是数据库的连接类:(这里使用jdbc)
- import java.io.File;
- import javax.xml.parsers.DocumentBuilder;
- import javax.xml.parsers.DocumentBuilderFactory;
- import org.w3c.dom.Document;
- /**
- *
- * <p>application name:{XML读取器}</p>
- * <p>application describing:{用于读取数据库配置xml文件中的相关信息}</p>
- * <p>Copyright:Copyright *******</p>
- * <p>company:</p>
- * <p>time:{时间,如2008.11.16}</p>
- * @author {}
- * @version {v1.0}
- */
- public class XMLReader
- {
- File f = new File("WebRoot/WEB-INF/connect-config.xml");
- /**
- *
- * {方法功能中文描述}
- *
- * @return
- * @see: {参照的方法}
- * @author:{创建者中文名字}
- */
- public String geturl()
- {
- String url = null;
- try
- {
- DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
- DocumentBuilder builder = factory.newDocumentBuilder();
- Document doc = builder.parse(f);
- url = doc.getElementsByTagName("url").item(0).getFirstChild().getNodeValue().toString();
- }
- catch (Exception e)
- {
- e.printStackTrace();
- }
- return url;
- }
- /**
- *
- * {获得drive字符串}
- *
- * @return
- * @see: {参照的方法}
- * @author:{创建者中文名字}
- */
- public String getDrivername()
- {
- String url = null;
- try
- {
- DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
- DocumentBuilder builder = factory.newDocumentBuilder();
- Document doc = builder.parse(f);
- url = doc.getElementsByTagName("drivername").item(0).getFirstChild().getNodeValue().toString();
- }
- catch (Exception e)
- {
- e.printStackTrace();
- }
- return url;
- }
- /**
- *
- * {方法功能中文描述}
- *
- * @return
- * @see: {参照的方法}
- * @author:{创建者中文名字}
- */
- public String getUsername()
- {
- String url = null;
- try
- {
- DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
- DocumentBuilder builder = factory.newDocumentBuilder();
- Document doc = builder.parse(f);
- url = doc.getElementsByTagName("username").item(0).getFirstChild().getNodeValue().toString();
- }
- catch (Exception e)
- {
- e.printStackTrace();
- }
- return url;
- }
- /**
- *
- * {方法功能中文描述}
- *
- * @return
- * @see: {参照的方法}
- * @author:{创建者中文名字}
- */
- public String getPwd()
- {
- String url = null;
- try
- {
- DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
- DocumentBuilder builder = factory.newDocumentBuilder();
- Document doc = builder.parse(f);
- url = doc.getElementsByTagName("password").item(0).getFirstChild().getNodeValue().toString();
- }
- catch (Exception e)
- {
- e.printStackTrace();
- }
- return url;
- }
- }
上面的类就是读取下面数据库连接文件的connect-config.xml的相关字段(上面代码的File f = new File("WebRoot/WEB-INF/connect-config.xml")部分)
- <?xml version="1.0" encoding="UTF-8"?>
- <databases>
- <drivername>oracle.jdbc.driver.OracleDriver</drivername>
- <url>jdbc:oracle:thin:@10.10.21.120:1521:ORCL</url>
- <username>music</username>
- <password>music</password>
- <poolmin>2</poolmin>
- <poolmax>1000</poolmax>
- </databases>
下面就使用上面的工具进行JDBC的连接(得到Connection对象)
- import java.sql.*;
- /**
- *
- * <p>application name:{数据库获得Connection对象
- }</p>
- * <p>application describing:{}</p>
- * <p>Copyright:Copyright 2008 p>
- * <p>company:</p>
- * <p>time:{时间,如2008.11.20}</p>
- * @author {}
- * @version {v1.0}
- */
- public class OperateDB
- {
- XMLReader xr = new XMLReader();
- String url = xr.geturl();
- String pwd = xr.getPwd();
- String drive = xr.getDrivername();
- String name = xr.getUsername();
- /**
- *
- * {获得jdbc的Connection对象}
- *
- * @return Connection对象
- * @see: {参照的方法}
- * @author:{}
- */
- public Connection getConnection()
- {
- Connection con = null;
- try
- {
- Class.forName(drive);
- con = DriverManager.getConnection(url, name, pwd);
- if (con != null && con.isClosed() == false)
- {
- System.out.println("数据库连接成功");
- }
- }
- catch (Exception e)
- {
- System.out.println("发现异常:" + e.toString());
- }
- return con;
- }