addassociatordate.java

网吧管理系统JAVA代码

package netbar;

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

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

    //获得最大卡号,并连接下一个卡号
    public int getcardId(){
         int  max=0;
         SQLDate.sqldate();
    try{
        Connection con=DriverManager.getConnection("jdbc:odbc:netbar");
        Statement st=con.createStatement();
        ResultSet rs=st.executeQuery("select * from Card");
    while(rs.next()){
        max++;
    }
    }catch(SQLException ee){
    System.out.println(ee);
    }
    return max;
    }
    public void noteofCard(String cardId,String pass,String sex,String address,String email,String money){
    SQLDate.sqldate();
    try{
        Connection con = DriverManager.getConnection("jdbc:odbc:netbar");
        Statement st=con.createStatement();
        st.executeUpdate("insert into Card(Id,Password,Sex,Address,[E-Mail]) values('"+cardId+"','"+pass+"','"+sex+"','"+address+"','"+email+"')");
        st.executeUpdate("update Card set Balance='"+Integer.parseInt(money)+"' where Id='"+cardId+"'");
    }
    catch(SQLException ee){
    System.out.println(ee);
    }
    }

    private void jbInit() throws Exception {
    }
}