addpricedate.java

网吧管理系统JAVA代码

package netbar;

import java.sql.*;

public class AddPriceDate {
    public AddPriceDate() {
    }

    //更具卡号添加金额
    public void addprice(String cardId,String money){
        int balance=0;
    SQLDate.sqldate();
    try{
    Connection con=DriverManager.getConnection("jdbc:odbc:netbar");
    Statement st=con.createStatement();
    ResultSet rs=st.executeQuery("select Balance from Card where Id='"+cardId+"'");
    rs.next();
    balance=rs.getInt(1);
    balance=balance+Integer.parseInt(money);
    st.executeUpdate("update Card set Balance='"+balance+"' where Id='"+cardId+"'");
    }catch(SQLException ee){
    System.out.println(ee);
    }
    }

    //是否有该卡号
    public boolean ishave(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");
    while(rs.next()){
    if(rs.getString(1).equals(cardId)){
        avaiable=true;
        break;
    }
    else
        avaiable=false;
    }
    }catch(SQLException ee){
    System.out.println(ee);
    }
    return avaiable;
    }
}