database.java

来自「这个也是关于图书管理系统的代码」· Java 代码 · 共 80 行

package com.xmspk.ebp.books;

/**
 * Created by IntelliJ IDEA.
 * User: Administrator
 * Date: Apr 18, 2003
 * Time: 10:43:34 AM
 * To change this template use Options | File Templates.
 */
import java.sql.*;

public class Database
{

    private Database()
    {
    }

    public static Connection Connect()
    {
        try
        {
            Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
            String url = "jdbc:oracle:thin:@172.31.0.28:1521:oradb";
            String user = "EbpUser";
            String password = "EbpUser";
            Connection conn = DriverManager.getConnection(url, user, password);
            return conn;
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        return null;
    }

    public static void DisConnect(Connection conn)
    {
        try
        {
            if(conn != null)
                conn.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
    }

    public static PreparedStatement getStatement(Connection conn, String sql)
    {
        try
        {
            if(conn != null)
            {
                PreparedStatement stmt = conn.prepareStatement(sql, 1004, 1007);
                return stmt;
            }
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        return null;
    }

    public static void releaseStatement(PreparedStatement stmt)
    {
        try
        {
            if(stmt != null)
                stmt.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
    }
}