db.java

基于Struts的学校新闻发布系统

// Decompiled by Jad v1.5.7f. Copyright 2000 Pavel Kouznetsov.
// Jad home page: http://www.geocities.com/SiliconValley/Bridge/8617/jad.html
// Decompiler options: packimports(3) 
// Source File Name:   DB.java

package StudyNews;

import java.io.PrintStream;
import java.sql.*;
import javax.sql.DataSource;

public class DB
{

    public DB(DataSource dataSource)
    {
        connect = null;
        rs = null;
        try
        {
            connect = dataSource.getConnection();
        }
        catch(SQLException e)
        {
            System.out.println("\u5B57\u7B26\u96C6\u8BBE\u7F6E\u5931\u8D25");
            e.printStackTrace();
        }
    }

    public ResultSet OpenSql(String sql)
    {
        try
        {
            Statement stmt = connect.createStatement(1004, 1007);
            rs = stmt.executeQuery(sql);
            System.out.println("sql:        " + sql);
        }
        catch(SQLException ex)
        {
            System.out.println("sql:        " + sql);
            ex.printStackTrace();
        }
        return rs;
    }

    public int ExecSql(String sql)
    {
        int result = 0;
        try
        {
            Statement stmt = connect.createStatement();
            System.out.println("sql:        " + sql);
            result = stmt.executeUpdate(sql);
        }
        catch(SQLException ex)
        {
            System.out.println("sql:        " + sql);
            System.err.println(ex.getMessage());
        }
        return result;
    }

    public void close()
    {
        if(connect != null)
            try
            {
                connect.close();
                connect = null;
            }
            catch(SQLException ex)
            {
                System.err.println(ex.getMessage());
            }
    }

    Connection connect;
    ResultSet rs;
}