operation_client.java~15~

本系统为六合彩网上投注系统

package operation;

// 业务流程处理类 --- 客户端
import java.sql.*;
import java.util.Random;

public class Operation_client
{
  private Connection conn;
  private String url = "jdbc:mysql://localhost:3306/liuhecai";
  private PreparedStatement pstmt;
  private Statement stmt;
  private String sql = "insert into lottery(lotteryNum,qiNum,oneNum,twoNum,threeNum"
      + ",fourNum,fiveNum,sixNum,speNum,username,zhuNum) values(?,?,?,?,?,?,?,?,?,?,?)";

  public Operation_client()
  {
  }

  public int now_QiNum() throws ClassNotFoundException, SQLException {
    ResultSet rs;
    Class.forName("org.gjt.mm.mysql.Driver");
    conn = DriverManager.getConnection(url);
    stmt = conn.createStatement();
    rs = stmt.executeQuery("select * from nowQiNum");
    int nowQiNum = 0;
    while(rs.next())
    {
      nowQiNum = rs.getInt(1);
    }
    System.out.println("nowQiNum="+nowQiNum);
    return nowQiNum;
  }

  private void changeLevel(int zjlevel,int lotteryNum) throws ClassNotFoundException,
      SQLException {
    Class.forName("org.gjt.mm.mysql.Driver");
    Connection conn = DriverManager.getConnection(url);
    Statement stmt = conn.createStatement();
    String sql = "update lottery set zjlevel=" + zjlevel + " where lotteryNum=" + lotteryNum;
    int re = stmt.executeUpdate(sql);
  }

  // 用户下注处理
  public long chip_in(int oneNum,int twoNum,int threeNum,int fourNum,int fiveNum,int sixNum,int speNum,String username,int zhuNum) throws
      ClassNotFoundException, SQLException {
    int nextQiNum = now_QiNum() + 1;
    Random ran = new Random();
    int lotteryNum = ran.nextInt(80000000);
    Class.forName("org.gjt.mm.mysql.Driver");
    conn = DriverManager.getConnection(url);
    pstmt = conn.prepareStatement(sql);
    pstmt.setInt(1,lotteryNum);
    pstmt.setInt(2,nextQiNum);
    pstmt.setInt(3,oneNum);
    pstmt.setInt(4,twoNum);
    pstmt.setInt(5,threeNum);
    pstmt.setInt(6,fourNum);
    pstmt.setInt(7,fiveNum);
    pstmt.setInt(8,sixNum);
    pstmt.setInt(9,speNum);
    pstmt.setString(10,username);
    pstmt.setInt(11,zhuNum);
    int INSERT_RESULT = pstmt.executeUpdate();
    if(INSERT_RESULT != 1)
    {
      System.out.println("投注失败！");
      return 0;
    }
    return lotteryNum;
  }
  // 用户投注状态查询处理
  public ResultSet statusQuery(String username) throws ClassNotFoundException,
      SQLException {
    ResultSet rs;
    Class.forName("org.gjt.mm.mysql.Driver");
    conn = DriverManager.getConnection(url);
    stmt = conn.createStatement();
    rs = stmt.executeQuery("select * from lottery where username='" + username + "'");
    return rs;
  }

  // 本期奖金额度
  public ResultSet resultMoneyQuery(int qiNum) throws
      ClassNotFoundException, SQLException {
    ResultSet rs;
    Class.forName("org.gjt.mm.mysql.Driver");
    conn = DriverManager.getConnection(url);
    stmt = conn.createStatement();
    rs = stmt.executeQuery("select * from resultMoney where qiNum='" + qiNum + "'");
    return rs;
  }

  // 本期开奖结果
  public ResultSet realResult(int qiNum) throws ClassNotFoundException,
      SQLException {
    Class.forName("org.gjt.mm.mysql.Driver");
    conn = DriverManager.getConnection(url);
    stmt = conn.createStatement();
    ResultSet rs = stmt.executeQuery("select * from result where qiNum='" + qiNum + "'");
    return rs;
  }

  // 中奖的判断过程   如果返回 -1 则没有此彩票号， 否则返回中彩等级
  public int isorWin(int lotteryNum,int qiNum) throws ClassNotFoundException,
      SQLException {
    Class.forName("org.gjt.mm.mysql.Driver");
    conn = DriverManager.getConnection(url);
    String sql = "select * from lottery where lotteryNum='" + lotteryNum + "' and qiNum='" + qiNum + "'";
    stmt = conn.createStatement();
    ResultSet rs,rs2;
    int zjlevel = 0;
    rs = stmt.executeQuery(sql);
    if(rs != null)
    {
      rs.next();
      int oneNum = rs.getInt("oneNum");
      int twoNum = rs.getInt("twoNum");
      int threeNum = rs.getInt("threeNum");
      int fourNum = rs.getInt("fourNum");
      int fiveNum = rs.getInt("fiveNum");
      int sixNum = rs.getInt("sixNum");
      int speNum = rs.getInt("speNum");
      int zhuNum = rs.getInt("zhuNum");
      rs2 = realResult(qiNum);
      rs2.next();
      int realOneNum = rs2.getInt("oneNum");
      int realTwoNum = rs2.getInt("twoNum");
      int realThreeNum = rs2.getInt("threeNum");
      int realFourNum = rs2.getInt("fourNum");
      int realFiveNum = rs2.getInt("FiveNum");
      int realSixNum = rs2.getInt("SixNum");
      int realSpeNum = rs2.getInt("speNum");
      if((oneNum == realOneNum)&&(twoNum == realTwoNum)&&(threeNum == realThreeNum)&&(fourNum == realFourNum)
         &&(fiveNum == realFiveNum)&&(sixNum == realSixNum))
      {
        zjlevel = 1;
        changeLevel(zjlevel,lotteryNum);
        return zjlevel;
      }
      else if(((oneNum != realOneNum)&&(twoNum == realTwoNum)&&(threeNum == realThreeNum)&&(fourNum == realFourNum)
        &&(fiveNum == realFiveNum)&&(sixNum == realSixNum)&&(speNum == realSpeNum))
      ||((oneNum == realOneNum)&&(twoNum != realTwoNum)&&(threeNum == realThreeNum)&&(fourNum == realFourNum)
        &&(fiveNum == realFiveNum)&&(sixNum == realSixNum)&&(speNum == realSpeNum))
      ||((oneNum == realOneNum)&&(twoNum == realTwoNum)&&(threeNum != realThreeNum)&&(fourNum == realFourNum)
        &&(fiveNum == realFiveNum)&&(sixNum == realSixNum)&&(speNum == realSpeNum))
      ||((oneNum == realOneNum)&&(twoNum == realTwoNum)&&(threeNum == realThreeNum)&&(fourNum != realFourNum)
        &&(fiveNum == realFiveNum)&&(sixNum == realSixNum)&&(speNum == realSpeNum))
      ||((oneNum == realOneNum)&&(twoNum == realTwoNum)&&(threeNum == realThreeNum)&&(fourNum == realFourNum)
        &&(fiveNum != realFiveNum)&&(sixNum == realSixNum)&&(speNum == realSpeNum))
      ||((oneNum == realOneNum)&&(twoNum == realTwoNum)&&(threeNum == realThreeNum)&&(fourNum == realFourNum)
        &&(fiveNum == realFiveNum)&&(sixNum != realSixNum)&&(speNum == realSpeNum)))
      {
        zjlevel = 2;
        changeLevel(zjlevel,lotteryNum);
        return zjlevel;
      }
      else if(((oneNum != realOneNum)&&(twoNum == realTwoNum)&&(threeNum == realThreeNum)&&(fourNum == realFourNum)
        &&(fiveNum == realFiveNum)&&(sixNum == realSixNum)&&(speNum != realSpeNum))
      ||((oneNum == realOneNum)&&(twoNum != realTwoNum)&&(threeNum == realThreeNum)&&(fourNum == realFourNum)
        &&(fiveNum == realFiveNum)&&(sixNum == realSixNum)&&(speNum != realSpeNum))
      ||((oneNum == realOneNum)&&(twoNum == realTwoNum)&&(threeNum != realThreeNum)&&(fourNum == realFourNum)
        &&(fiveNum == realFiveNum)&&(sixNum == realSixNum)&&(speNum != realSpeNum))
      ||((oneNum == realOneNum)&&(twoNum == realTwoNum)&&(threeNum == realThreeNum)&&(fourNum != realFourNum)
        &&(fiveNum == realFiveNum)&&(sixNum == realSixNum)&&(speNum != realSpeNum))
      ||((oneNum == realOneNum)&&(twoNum == realTwoNum)&&(threeNum == realThreeNum)&&(fourNum == realFourNum)
        &&(fiveNum != realFiveNum)&&(sixNum == realSixNum)&&(speNum != realSpeNum))
      ||((oneNum == realOneNum)&&(twoNum == realTwoNum)&&(threeNum == realThreeNum)&&(fourNum == realFourNum)
        &&(fiveNum == realFiveNum)&&(sixNum != realSixNum)&&(speNum != realSpeNum)))
      {
        zjlevel = 3;
        changeLevel(zjlevel,lotteryNum);