deleteassociatordate.java

java 网吧项目 源码

package netbar;

import java.sql.*;
import java.util.*;

public class DeleteAssociatorDate {
    public DeleteAssociatorDate() {
    }


    //获取金额为0的卡号
    public ArrayList getcardId(){
        ArrayList array=new ArrayList();
    SQLDate.sqldate();
    try{
    Connection con=DriverManager.getConnection("jdbc:odbc:netbar");
    Statement st=con.createStatement();
    ResultSet rs=st.executeQuery("select Id from Card where Balance=0");
    while(rs.next()){
    array.add(rs.getString(1));
    }
    rs.close();
    st.close();
    con.close();
     }catch(SQLException ee){
    System.out.println(ee);
    }
    return array;
    }

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

    }
}