sql_data.java

这是一个jsp + sql server在线测试系统,可供初学者参考

package webtest;
import java.sql.*;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: 天津财经学院  信息管理与信息系统——高职升本0101班
 * @author 王刚
 * @version 1.0
 */

public class Sql_data {
    String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
    //String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
    String sConnStr="jdbc:odbc:SQLServer";
    //String sConnStr="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test";
    Connection conn=null;
    ResultSet rs=null;

  public Sql_data() {
  try{
    Class.forName(sDBDriver);
        }
        catch(java.lang.ClassNotFoundException e)
        {
            System.err.println("Sql_data():"+e.getMessage());
        }
  }

  public void getConn()
  {
    try
    {conn=DriverManager.getConnection(sConnStr,"sa","");}
    catch(SQLException ex)
    {System.err.println("Sql_data.executeUpdate:"+ex.getMessage());}
  }

  public void insert(String sql)
  {
    try
    {
      Statement stmt=conn.createStatement();
      stmt.executeUpdate(sql);
    }
    catch(SQLException e)
    {
      System.err.println("Sql_data.insert:"+e.getMessage());
    }
  }

  public ResultSet query(String sql)
  {
    try
    {
      Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
      rs=stmt.executeQuery(sql);
    }
    catch(SQLException e)
    {
      System.err.println("Sql_data.query()"+e.getMessage());
    }
    return rs;
  }
  public void executeInsert(String sql)
    {
        try
        {
            conn=DriverManager.getConnection(sConnStr,"sa","");
            Statement stmt=conn.createStatement();
            stmt.executeUpdate(sql);
        }
        catch(SQLException ex)
        {
            System.err.println("Sql_data.executeUpdate:"+ex.getMessage());
        }
    }

    public ResultSet executeQuery(String sql)
    {
        rs=null;
        try
        {
            conn=DriverManager.getConnection(sConnStr,"sa","");
            Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
            rs=stmt.executeQuery(sql);
        }
        catch(SQLException ex)
        {
            System.err.println("Sql_data.executeQuery:"+ex.getMessage());
        }
        return rs;
    }
    public void executeDelete(String sql)
    {
        try
        {
            conn=DriverManager.getConnection(sConnStr,"sa","");
            Statement stmt=conn.createStatement();
            stmt.executeUpdate(sql);
        }
        catch(SQLException ex)
        {
            System.err.println("Sql_data.executeDelete:"+ex.getMessage());
        }
    }
    public void close()
    {
      try
      { rs.close();
        conn.close();
      }
      catch (SQLException e)
      {
        System.err.println(e.getMessage());
      }
    }
    public void closeconn()
    {
      try{
        conn.close();
      }
      catch(SQLException e)
      {
        System.err.println(e.getMessage());
      }
    };
}