usercondb.java~49~

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

package 毕业设计;
import java.sql.*;
import javax.swing.JOptionPane;
import java.util.Vector;
public class UserConDB {
    private Connection con;
    private Statement st;
    private ResultSet rs;
    private PreparedStatement pst;
    public UserConDB()
    {
        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 出错");
        }
    }
    public boolean VerifyPassword(String Id, String Password)
   {
       boolean psw = false;
       try {
           String str = "select * from Operator where Id = '" + Id +
                        "' and Password = '" + Password + "'";
           rs = st.executeQuery(str);
           if (rs.next()) {
               psw = true;
           }
           rs.close();
       } catch (SQLException ex) {
       }
       return psw;
   }

   public void setIsUsing()
   {
       boolean psw = false;
       try {
           String str = "Update Operator set IsUsing = '0' where IsUsing = '1'";
           pst = con.prepareStatement(str);
           pst.executeUpdate();
           pst.close();
       } catch (SQLException ex) {
       }
   }

   public void UpdateIsUsing(String Id)
   {
       boolean psw = false;
       try {
           String str = "Update Operator set IsUsing = '1' where Id = '" + Id + "'";
           pst = con.prepareStatement(str);
           pst.executeUpdate();
           pst.close();
       } catch (SQLException ex) {
       }
   }

   public void UpdatePassword(String newPassword)
   {
       boolean psw = false;
       try {
           String str = "Update Operator set Password = '" + newPassword +
                        "' where IsUsing = '1'";
           pst = con.prepareStatement(str);
           pst.executeUpdate();
           pst.close();
       } catch (SQLException ex) {
       }
   }
   public Vector SearchAll()
   {
       Vector vt = new Vector();
       try {
           String str = "select * from Operator";
           rs = st.executeQuery(str);
           while (rs.next()) {
               Vector tempvt = new Vector();
               for(int i=1;i<=rs.getMetaData().getColumnCount();i++)
               {
                   if(i!=4)
                       tempvt.add(rs.getString(i));
               }
               vt.add(tempvt);
           }
           rs.close();
      } catch (SQLException ex) {
      }
      return vt;
   }

   public Vector SearchUser(String content, String sort,boolean isnot)
   {
       Vector vt = new Vector();
       if(isnot)
       {
           if (sort.equals("卡号")) {
               try {
                   String str = "select * from Operator where Id = '" + content +
                                "'";
                   rs = st.executeQuery(str);
                   while (rs.next()) {
                       Vector tempvt = new Vector();
                       for (int i = 1; i <= rs.getMetaData().getColumnCount();
                                    i++) {
                           if (i != 4)
                               tempvt.add(rs.getString(i));
                       }
                       vt.add(tempvt);
                   }
                   rs.close();
               } catch (SQLException ex) {
               }
           } else if (sort.equals("姓名")) {
               try {
                   String str = "select * from Operator where Name = '" +
                                content +
                                "'";
                   rs = st.executeQuery(str);
                   while (rs.next()) {
                       Vector tempvt = new Vector();
                       for (int i = 1; i <= rs.getMetaData().getColumnCount();
                                    i++) {
                           if (i != 4)
                               tempvt.add(rs.getString(i));
                       }
                       vt.add(tempvt);
                   }
                   rs.close();
               } catch (SQLException ex) {
               }
           } else if (sort.equals("权限")) {
               try {
                   String str = "select * from Operator where Popedom = '" +
                                content + "'";
                   rs = st.executeQuery(str);
                   while (rs.next()) {
                       Vector tempvt = new Vector();
                       for (int i = 1; i <= rs.getMetaData().getColumnCount();
                                    i++) {
                           if (i != 4)
                               tempvt.add(rs.getString(i));
                       }
                       vt.add(tempvt);
                   }
                   rs.close();
               } catch (SQLException ex) {
               }
           }
       }
       else
       {
           if (sort.equals("卡号")) {
               try {
                   String str = "select * from Operator where Id like '%" + content +
                                "%'";
                   rs = st.executeQuery(str);
                   while (rs.next())
                   {
                       Vector tempvt = new Vector();
                       for(int i=1;i<=rs.getMetaData().getColumnCount();i++)
                       {
                           if(i!=4)
                               tempvt.add(rs.getString(i));
                       }
                       vt.add(tempvt);
                   }
                   rs.close();
               } catch (SQLException ex) {
               }
           } else if (sort.equals("姓名")) {
               try {
                   String str = "select * from Operator where Name like '%" + content +
                                "%'";
                   rs = st.executeQuery(str);
                   while (rs.next()) {
                       Vector tempvt = new Vector();
                       for(int i=1;i<=rs.getMetaData().getColumnCount();i++)
                       {
                           if(i!=4)
                                tempvt.add(rs.getString(i));
                       }
                       vt.add(tempvt);
                   }
                   rs.close();
               } catch (SQLException ex) {
               }
           } else if (sort.equals("权限")) {
               try {
                   String str = "select * from Operator where Popedom like '%" +
                                content + "%'";
                   rs = st.executeQuery(str);
                   while (rs.next()) {
                       Vector tempvt = new Vector();
                       for(int i=1;i<=rs.getMetaData().getColumnCount();i++)
                       {
                           if(i!=4)
                               tempvt.add(rs.getString(i));
                       }
                       vt.add(tempvt);
                   }
                   rs.close();
               } catch (SQLException ex) {
               }
           }
       }
       return vt;
   }

   public Vector SearchUser(String Id, String Name, String Popedom, boolean isnot)
   {
       Vector vt = new Vector();
       if(isnot)
       {
           if (!Id.equals("") && Name.equals("") && Popedom.equals("")) {
               try {
                   String str = "select * from Operator where Id = '" + Id +
                                "'";
                   rs = st.executeQuery(str);
                   while (rs.next()) {
                       Vector tempvt = new Vector();
                       for(int i=1;i<=rs.getMetaData().getColumnCount();i++)
                       {
                           if(i!=4)
                               tempvt.add(rs.getString(i));
                       }
                       vt.add(tempvt);
                   }
                   rs.close();
               } catch (SQLException ex) {
               }
           } else if (Id.equals("") && !Name.equals("") && Popedom.equals("")) {
               try {
                   String str = "select * from Operator where Name = '" + Name +
                                "'";
                   rs = st.executeQuery(str);
                   while (rs.next()) {
                       Vector tempvt = new Vector();
                       for(int i=1;i<=rs.getMetaData().getColumnCount();i++)
                       {
                           if(i!=4)
                               tempvt.add(rs.getString(i));
                       }
                       vt.add(tempvt);
                   }
                   rs.close();
               } catch (SQLException ex) {
               }
           } else if (Id.equals("") && Name.equals("") && !Popedom.equals("")) {
               try {
                   String str = "select * from Operator where Popedom = '" +
                                Popedom + "'";
                   rs = st.executeQuery(str);
                   while (rs.next()) {
                       Vector tempvt = new Vector();
                       for(int i=1;i<=rs.getMetaData().getColumnCount();i++)
                       {
                           if(i!=4)
                               tempvt.add(rs.getString(i));
                       }
                       vt.add(tempvt);
                   }
                   rs.close();
               } catch (SQLException ex) {
               }
           } else if (!Id.equals("") && !Name.equals("") && Popedom.equals("")) {
               try {
                   String str = "select * from Operator where Id = '" + Id +
                                "' and Name = '" + Name + "'";
                   rs = st.executeQuery(str);
                   while (rs.next()) {