sqll.java

java+sql 图书管理系统

package MyLibraryok.books.untitled1;

//import tushuguanli.SqlDb;

//import java.sql.*;
//import java.util.*;
//
///**
// * <p>Title: </p>
// *
// * <p>Description: </p>
// *
// * <p>Copyright: Copyright (c) 2006</p>
// *
// * <p>Company: </p>
// *
// * @author not attributable
// * @version 1.0
// */
//public class sqlL {
//    static String driver = "com.microsoft.jdbc.sqlserver.SQLSererDriver";
//    static String url =
//            "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=tushuguan";
//    private ArrayList alist;
//    private TableModelTest tm;
//
//
//
//    public sqlL() {
//        try {
//            Class.forName(driver);
//            Connection con = DriverManager.getConnection(url, "sa",
//                    "");
//            String sqlStr = "select * from manage";
//            Statement stmt = connection.createStatement();
//            ResultSet rs = stmt.executeQuery(sqlStr);
//
//            String sqlStr1 = "insert into manage  ";
//            Statement stmt1 = connection.createStatement();
//            stmt.execute(sqlStr);
//            ArrayList alist = this.alist;
//            TableModelTest tm = this.tm;
//
//            alist.clear();
//
//        } catch (SQLException ex) {
//            System.out.println("SQL语句错误" + ex);
//        } catch (ClassNotFoundException ex) {
//            System.out.println("数据库驱动错误" + ex);
//        }
//
//        public Statement getsta() throws SQLException {
//        Connection con = DriverManager.getConnection(url, "sa", "");
//        return con.createStatement();
//    }
//






import java.sql.*;

public class sqlL{
  //使用ODBC数据源连库
  //String driver="sun.jdbc.odbc.JdbcOdbcDriver";
  //String url="jdbc:odbc:mydb";
  //使用家包连库
  String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
  String url = "jdbc:microsoft:sqlserver://192.168.4.128:1433;DatabaseName=TUSHUGUAN";
  public sqlL() {
      try {
          Class.forName(driver);
      } catch (ClassNotFoundException e) {
          System.out.print(e.getMessage());
      }
  }

  public Statement getsta() throws SQLException {
      Connection con = DriverManager.getConnection(url, "sa", "");
      return con.createStatement();
  }

  public ResultSet sqlcha(String ss) throws SQLException {
      return getsta().executeQuery(ss);
  }

  public void sqlgai(String ss) throws SQLException {
      getsta().executeUpdate(ss);
  }

  public void sqlzen(String ss) throws SQLException {
      getsta().execute(ss);
  }

  /**
   * sqlzen
   *
   * @return ResultSet
   */


  public ResultSet sqlzen() {
      return null;
  }
}