connaccess.java

学校在线测试系统 jsp+acce

package test;

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

public class ConnAccess
{

   
    String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
    String sConnStr="jdbc:odbc:test";
    Connection connect=null;
    ResultSet rs=null;
public ConnAccess()
    {
       
      
        try
        {
            Class.forName(sDBDriver);
        }
        catch(ClassNotFoundException classnotfoundexception)
        {
            System.err.println(classnotfoundexception.getMessage());
        }
    }

    public ResultSet executeQuery(String s)
    {
        try
        {
            connect = DriverManager.getConnection(sConnStr);
            Statement statement = connect.createStatement();
            rs = statement.executeQuery(s);
        }
        catch(SQLException sqlexception)
        {
            System.err.println(sqlexception.getMessage());
        }
        return rs;
    }

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