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());      }    };}