下面是双色球模拟程序,代码如下:
[java]
package Test;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import Test.util.ConnectionUtil;
/**6个为红球(1—33),1个为蓝球(1—16)*/
public class ColorBall {
public static void main(String[] args) {
try {
Connection conn=ConnectionUtil.getConnection();
Statement stmt = conn.createStatement();
PreparedStatement ps=null;
String sql = "insert into ball values(BALLID_SEQ.NEXTVAL, , , , , , , ,sysdate)";
ps=conn.prepareStatement(sql);
//循环购买双色球2400000注
for(int c=0;c<2400000;c++){
List luckBalls=makeLuck();
for(int i=0;i
String num=Integer.toString((Integer)luckBalls.get(i));
ps.setString(i+1,num);
}
ps.executeUpdate();
}
stmt.close();
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
//产生一期幸运球
public static List makeLuck(){
List balls=new ArrayList();
List luckBalls=new ArrayList();
for(int i=0;i<33;i++){
balls.add(i+1);
}
for(int i=0;i<6;i++){
int luckIndex=(int)(Math.random()*(balls.size()));
luckBalls.add(balls.get(luckIndex));
balls.remove(luckIndex);
}
luckBalls.add((int)(Math.random()*16)+1);
return luckBalls;
}
}
package Test;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import Test.util.ConnectionUtil;
/**6个为红球(1—33),1个为蓝球(1—16)*/
public class ColorBall {
public static void main(String[] args) {
try {
Connection conn=ConnectionUtil.getConnection();
Statement stmt = conn.createStatement();
PreparedStatement ps=null;
String sql = "insert into ball values(BALLID_SEQ.NEXTVAL, , , , , , , ,sysdate)";
ps=conn.prepareStatement(sql);
//循环购买双色球2400000注
for(int c=0;c<2400000;c++){
List luckBalls=makeLuck();
for(int i=0;i
String num=Integer.toString((Integer)luckBalls.get(i));
ps.setString(i+1,num);
}
ps.executeUpdate();
}
stmt.close();
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
//产生一期幸运球
public static List makeLuck(){
List balls=new ArrayList();
List luckBalls=new ArrayList();
for(int i=0;i<33;i++){
balls.add(i+1);
}
for(int i=0;i<6;i++){
int luckIndex=(int)(Math.random()*(balls.size()));
luckBalls.add(balls.get(luckIndex));
balls.remove(luckIndex);
}
luckBalls.add((int)(Math.random()*16)+1);
return luckBalls;
}
}
数据库情况:
建表语句:
[sql]
-- Create table
create table BALL
(
OPENID VARCHAR2(10) not null,
RED1 VARCHAR2(10) not null,
RED2 VARCHAR2(10) not null,
RED3 VARCHAR2(10) not nul