deletedate.java

网吧管理系统JAVA代码

package netbar;

import java.sql.*;

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

    //删除数据
    public void deleteManager(String cardId){
    SQLDate.sqldate();
    try{
    Connection con=DriverManager.getConnection("jdbc:odbc:netbar");
    Statement st=con.createStatement();
    st.executeUpdate("delete from Manager where Id='"+cardId+"'");
    st.close();
    con.close();
    }catch(SQLException ee){
    System.out.println(ee);
    }
    }

    //判断该管理员是不是高级管理员
    public String isdelete(String cardId){
        Connection con=null;
         Statement st=null;
         ResultSet rs=null;
         String name="";
         SQLDate.sqldate();
         try{
             con=DriverManager.getConnection("jdbc:odbc:netbar");
             st=con.createStatement();
             rs=st.executeQuery("select LevelOfManager from Manager where Id='"+cardId+"'");
             rs.next();
             name=rs.getString(1);
             rs.close();
             st.close();
             con.close();
         }catch(SQLException ee){
        }
        return name;
    }
    private void jbInit() throws Exception {
    }
}