package com.test;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.junit.Test;
import java.io.FileOutputStream;
import java.sql.Connection;
import java.util.ArrayList;
import java.util.List;
import java.util.Random;
import java.util.Scanner;
public class Gouzao {
public static String tables = "学生的信息";
public static String outputFile = "D:\\工程认证\\15级成绩录入\\15级课程成绩单\\计算机网络原理\\随机数.xls";
public static int i=0;
public static List<Shiyan> list=new ArrayList<>();
public static Integer total=40;
public static void excel(List<Shiyan> list) {
try {
HSSFWorkbook workbook = new HSSFWorkbook();
int rowNum = 1;
try {
HSSFSheet sheet = workbook.createSheet(tables);
try {
HSSFRow row1 = sheet.createRow(0);
for (int i = 1; i <= 10; i++) {
sheet.autoSizeColumn(i);
HSSFCell cell1 = row1.createCell(i - 1);
cell1.setCellValue("作业"+i);
}
} catch (Exception e) {
e.printStackTrace();
}
while (i<total) {
HSSFRow row = sheet.createRow(rowNum);
for (int j = 0; j < 10; j++) {
HSSFCell cell = row.createCell(j);
sheet.autoSizeColumn(i);
if(j==0){
cell.setCellValue(list.get(i).getS1());
}else if(j==1){
cell.setCellValue(list.get(i).getS2());
}else if(j==2){
cell.setCellValue(list.get(i).getS3());
}else if(j==3){
cell.setCellValue(list.get(i).getS4());
}else if(j==4){
cell.setCellValue(list.get(i).getS5());
}else if(j==5){
cell.setCellValue(list.get(i).getS6());
}else if(j==6){
cell.setCellValue(list.get(i).getS7());
}else if(j==7){
cell.setCellValue(list.get(i).getS8());
}else if(j==8){
cell.setCellValue(list.get(i).getS9());
}else if(j==9){
cell.setCellValue(list.get(i).getS10());
}
}
rowNum++;
i++;
}
}catch (Exception e1) {
e1.printStackTrace();
}
FileOutputStream fOut = new FileOutputStream(outputFile);
workbook.write(fOut);
fOut.close();
} catch (Exception e) {
e.printStackTrace();
}
}
public static void jisun(Integer input[]){
for (int i=0;i<input.length;i++){
while(true){
int s5max=5;
int s5min=0;
Random random = new Random();
int s1 = random.nextInt(s5max)%(s5max-s5min+1) + s5min;
int s2 = random.nextInt(s5max)%(s5max-s5min+1) + s5min;
int s3 = random.nextInt(s5max)%(s5max-s5min+1) + s5min;
int s4 = random.nextInt(s5max)%(s5max-s5min+1) + s5min;
int s9 = random.nextInt(s5max)%(s5max-s5min+1) + s5min;
int s10 = random.nextInt(s5max)%(s5max-s5min+1) + s5min;
int s20max=20;
int s20min=5;
int s5 = random.nextInt(s20max)%(s20max-s20min+1) + s20min;
int s15max=15;
int s15min=5;
int s7 = random.nextInt(s15max)%(s15max-s15min+1) + s15min;
int s8= random.nextInt(s15max)%(s15max-s15min+1) + s15min;
int s6=input[i]-s1-s2-s3-s4-s5-s8-s7-s9-s10;
if(s6<0){
continue;
}else if(s6>20){
continue;
}else{
Shiyan shiyan=new Shiyan( s1, s2, s3, s4, s5, s6, s7, s8, s9, s10);
list.add(shiyan);
System.out.println(i+1+"--"+input[i]+"--"+shiyan);
break;
}
}
}
Gouzao.excel(list);
}
public static void main(String[] args){
Integer a[]=new Integer[total];
Scanner sc = new Scanner(System.in);
for (int i=0;i<total;i++){
int t = sc.nextInt();
a[i]=t;
System.out.println(i+1);
}
Gouzao.jisun(a);
}
}
package com.test;
public class Shiyan {
private Integer s1;
private Integer s2;
private Integer s3;
private Integer s4;
private Integer s5;
private Integer s6;
private Integer s7;
private Integer s8;
private Integer s9;
private Integer s10;
public Shiyan(Integer s1, Integer s2, Integer s3, Integer s4, Integer s5, Integer s6, Integer s7, Integer s8, Integer s9, Integer s10) {
this.s1 = s1;
this.s2 = s2;
this.s3 = s3;
this.s4 = s4;
this.s5 = s5;
this.s6 = s6;
this.s7 = s7;
this.s8 = s8;
this.s9 = s9;
this.s10 = s10;
}
public Integer getS1() {
return s1;
}
public void setS1(Integer s1) {
this.s1 = s1;
}
public Integer getS2() {
return s2;
}
public void setS2(Integer s2) {
this.s2 = s2;
}
public Integer getS3() {
return s3;
}
public void setS3(Integer s3) {
this.s3 = s3;
}
public Integer getS4() {
return s4;
}
public void setS4(Integer s4) {
this.s4 = s4;
}
public Integer getS5() {
return s5;
}
public void setS5(Integer s5) {
this.s5 = s5;
}
public Integer getS6() {
return s6;
}
public void setS6(Integer s6) {
this.s6 = s6;
}
public Integer getS7() {
return s7;
}
public void setS7(Integer s7) {
this.s7 = s7;
}
public Integer getS8() {
return s8;
}
public void setS8(Integer s8) {
this.s8 = s8;
}
public Integer getS9() {
return s9;
}
public void setS9(Integer s9) {
this.s9 = s9;
}
public Integer getS10() {
return s10;
}
public void setS10(Integer s10) {
this.s10 = s10;
}
@Override
public String toString() {
return "Shiyan{" + "s1=" + s1 + ", s2=" + s2 + ", s3=" + s3 + ", s4=" + s4 + ", s5=" + s5 + ", s6=" + s6 + ", s7=" + s7 + ", s8=" + s8 + ", s9=" + s9 + ", s10=" + s10 + '}';
}
}