import java.text.DecimalFormat;
//生成插入语句的java程序应用于商品日期表
public class demo2 {
public static void main(String[] args) {
//五月
for (int i=1;i<=31;i++){
double a=Math.random()*1000;
DecimalFormat df = new DecimalFormat( "0.00" );
String str=df.format( a );
System.out.println("INSERT INTO `productdate` VALUES ('202105002"+i+"', '2', '2021-05-"+i+"', "+str+", 1);");
}
//六月
for (int i=1;i<=30;i++){
double a=Math.random()*1000;
DecimalFormat df = new DecimalFormat( "0.00" );
String str=df.format( a );
System.out.println("INSERT INTO `productdate` VALUES ('202106002"+i+"', '2', '2021-06-"+i+"', "+str+", 1);");
}
//七月
for (int i=1;i<=31;i++){
double a=Math.random()*1000;
DecimalFormat df = new DecimalFormat( "0.00" );
String str=df.format( a );
System.out.println("INSERT INTO `productdate` VALUES ('202107002"+i+"', '2', '2021-07-"+i+"', "+str+", 1);");
}
//八月
for (int i=1;i<=31;i++){
double a=Math.random()*1000;
DecimalFormat df = new DecimalFormat( "0.00" );
String str=df.format( a );
System.out.println("INSERT INTO `productdate` VALUES ('202108002"+i+"', '2', '2021-08-"+i+"', "+str+", 1);");
}
//九月
for (int i=1;i<=30;i++){
double a=Math.random()*1000;
DecimalFormat df = new DecimalFormat( "0.00" );
String str=df.format( a );
System.out.println("INSERT INTO `productdate` VALUES ('202109002"+i+"', '2', '2021-09-"+i+"', "+str+", 1);");
}
//十月
for (int i=1;i<=31;i++){
double a=Math.random()*1000;
DecimalFormat df = new DecimalFormat( "0.00" );
String str=df.format( a );
System.out.println("INSERT INTO `productdate` VALUES ('202110002"+i+"', '2', '2021-10-"+i+"', "+str+", 1);");
}
}
}