databse.java~52~

来自「一个完整的门户网站,基于JSP环境下开发的,使用SQL数据库.」· JAVA~52~ 代码 · 共 62 行

package com.bwm.core;

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

/**
 * <p>Title: </p>
 * <p>Description: 数据库连接</p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: MR</p>
 * @author BWM
 * @version 1.0
 */

public class Databse {
    private Connection con;
    private String proxool = "org.logicalcobwebs.proxool.ProxoolDriver";
    private String poolname = "proxool.mingri";
    public Databse() {
    }

    public Connection getConnection() {
        try {
            Class.forName(proxool);
            con = DriverManager.getConnection(poolname);
        } catch (ClassNotFoundException e) {
            System.out.println(e.getMessage());
        } catch (SQLException e) {
            System.out.println(e.getMessage());
        }
        if (con == null) {
            System.out.println("没有获取到数据库连接");
        }
        return con;
    }

    public PreparedStatement getPreparedStatement(String sql) throws SQLException {
        con=getConnection();
        PreparedStatement ps=con.prepareStatement(sql);
        return ps;
    }
    public PreparedStatement getPreparedStatement(String sql) throws SQLException {
        con=getConnection();
        PreparedStatement ps=con.prepareStatement(sql);
        return ps;
    }

    public void close() {
        if (con != null) {
            try {
                con.close();
            } catch (SQLException e) {
                con = null;
                System.out.println(e.getMessage());
            } finally {
                con = null;
            }
        }
    }
}