recordcondb.java~6~

用java实现的一个应用程序,源码非常完整,可以直接运行

package 毕业设计;
import java.sql.*;
public class RecordConDB {
    private Connection con;
    private Statement st;
    private ResultSet rs;
    private PreparedStatement pst;
    public RecordConDB() {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        } catch (ClassNotFoundException ex) {
            System.out.println("Driver 出错");
        }
        try {
             String url = "jdbc:odbc:lib";
             con = DriverManager.getConnection(url);
             st = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                                     ResultSet.CONCUR_UPDATABLE);
        } catch (SQLException ex1) {
            System.out.println("lib 出错");
        }
        try {
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    public void AddRecord(String ReaId, String LibId, String BarCode, String LoanTime, String RevertibleTime, String Operator)
    {
        try {
            String strSQL = "insert Record values ( '" + ReaId + "', '" +
                            LibId + "', '" + BarCode + "', '" + LoanTime + "', '', '" +
                           RevertibleTime + "', '" + Operator + "')";
            pst = con.prepareStatement(strSQL);
            pst.executeUpdate();
            pst.close();
        } catch (SQLException ex) {
        }
    }
    public void CloseRecordDB()
    {
     try {
         st.close();
         con.close();
     } catch (SQLException ex) {
     }
   }

    private void jbInit() throws Exception {
    }
}