faq2.java

《Java程序设计实践教程》代码

package ckstudio.db;

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

public class faq2
{

    public faq2()
    {
        sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
        sConnStr = "jdbc:odbc:zsmshop";
        conn = null;
        rs = null;
        try
        {
            Class.forName(sDBDriver);
        }
        catch(ClassNotFoundException classnotfoundexception)
        {
            System.err.println("faq(): " + classnotfoundexception.getMessage());
        }
    }

    public void executeInsert(String s)
    {
        try
        {
            conn = DriverManager.getConnection(sConnStr);
            Statement statement = conn.createStatement();
            int i = statement.executeUpdate(s);
        }
        catch(SQLException sqlexception)
        {
            System.err.println("faq.executeUpdate:" + sqlexception.getMessage());
        }
    }

    public ResultSet executeQuery(String s)
    {
        rs = null;
        try
        {
            conn = DriverManager.getConnection(sConnStr);
            Statement statement = conn.createStatement(1004, 1008);
            rs = statement.executeQuery(s);
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery: " + sqlexception.getMessage());
        }
        return rs;
    }

    public void executeDelete(String s)
    {
        try
        {
            conn = DriverManager.getConnection(sConnStr);
            Statement statement = conn.createStatement();
            statement.executeUpdate(s);
        }
        catch(SQLException sqlexception)
        {
            System.err.println("faq.executeDelete: " + sqlexception.getMessage());
        }
    }

    public int executeUpdate(String s)
    {
        int i = 0;
        try
        {
            conn = DriverManager.getConnection(sConnStr);
            Statement statement = conn.createStatement();
            i = statement.executeUpdate(s);
        }
        catch(SQLException sqlexception)
        {
            System.err.println("faq.executeDelete: " + sqlexception.getMessage());
        }
        return i;
    }

    public void Close()
    {
        try
        {
            if(rs != null)
                rs.close();
            if(conn != null)
                conn.close();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("faq.executeDelete: " + sqlexception.getMessage());
        }
    }

    String sDBDriver;
    String sConnStr;
    Connection conn;
    ResultSet rs;
}