conn.java

用J2EE开发的网站,可以应用到图书馆,图书超市

package ksnb;

import java.util.*;
import java.sql.*;
import java.net.*;

public class conn {
   Connection con=null;
   public conn() throws connException{
       String driver = null;
       String user = null;
       String pass = null;
       String dbURL = null;
       //生成Properties对象，用来获取配置文件（config）内容
       java.util.Properties properties = null;
       try {
           properties = PropertiesManager.getProperties("config");
           driver = properties.getProperty("jdbc.driver");
           user = properties.getProperty("jdbc.user");
           pass = properties.getProperty("jdbc.password");
           dbURL = properties.getProperty("jdbc.dbURL");
           //连接数据库
           Class.forName(driver);
           con= DriverManager.getConnection(dbURL, user, pass);
           System.out.println("连接数据库成功！");
       }
       catch (java.io.FileNotFoundException e) {
            throw new connException("JDBC Properties File Read Error!");
        } catch (MissingResourceException e) {
            throw new connException("JDBC Properties File Not Found!");
        } catch (ClassNotFoundException e) {
            throw new connException("No Driver Available!");
        } catch (SQLException se) {
            throw new connException(se.getMessage());
        }
   }

    public Connection getConncetion() throws connException {
        return con;
    }
    public void conClose(){
        try{
        con.close();
        }catch(Exception e){}
    }
}