lockedassociatordate.java

网吧管理系统JAVA代码

package netbar;

import java.sql.*;

public class LockedASSociatorDate {
    public LockedASSociatorDate() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    //根据卡号锁定卡号
    public void locked(String cardId){
    SQLDate.sqldate();
    try{
    Connection con=DriverManager.getConnection("jdbc:odbc:netbar");
    Statement st=con.createStatement();
    st.executeUpdate("update Card set OnUse='1' where Id='"+cardId+"'");
    st.close();
    con.close();
    }catch(SQLException ee){
    System.out.println(ee);
    }
    }

    //判断是否有此卡
    public boolean ishavecard(String cardId){
        boolean avaiable=false;
        SQLDate.sqldate();
        try{
        Connection con=DriverManager.getConnection("jdbc:odbc:netbar");
        Statement st=con.createStatement();
        ResultSet rs=st.executeQuery("select Id from Card where OnUse='0'");
        while(rs.next()){
        if(rs.getString(1).equals(cardId)){
        avaiable=true;
        break;
        }
        else
            avaiable=false;
        }
        rs.close();
        st.close();
        con.close();
        }catch(SQLException ee){
            avaiable=false;
        }
        return avaiable;
    }

    private void jbInit() throws Exception {
    }
}