package javabean;

import java.sql.ResultSet;
import java.sql.SQLException;

public class ADD_shijuan {
	public int add_shijuan(String shiti_leixing,String shiti_name,String shuliang,String meitifs,String kaoshisj){
		int zongfen,mei,ds;
		mei=Integer.valueOf(meitifs).intValue();
		ds=Integer.valueOf(shuliang).intValue();
		zongfen=mei*ds;
		int iiii=1;
		String sql="insert into Online_shijuan_ML (shijuan_name,shijuan_bumen,timu_shuliang,shijuan_quanxian,meitifenshu,zongfen,kaoshi_sj) values('"+shiti_name+"','"+shiti_leixing+"','"+shuliang+"','2','"+meitifs+"',"+zongfen+","+kaoshisj+")";
	
		conn cn = new conn();
		int i=cn.update(sql);
		String sql1="CREATE TABLE "+shiti_name+"(id int identity(1,1),leixing varchar(22),timu varchar(2000),xxa varchar(22),xxb varchar(22),xxc varchar(22),xxd varchar(22),daan varchar(22),name_input varchar(22) PRIMARY KEY  (id))";
		cn.query(sql1);
		String sql2="select * from Online_ST where leixing='"+shiti_leixing+"'";
		conn cn1 = new conn();
		ResultSet rs=cn1.query(sql2);
		
		conn cn2 = new conn();
		int a[] = new int[ds];
		for(int ii=0;ii<ds;ii++){
		int temp=(int)(Math.random()*35);
		
		try {
			
			while(true){
				if(eq(a,temp)) {
					a[ii] = temp;
					
					break;
				}
				else{
					temp=(int)(Math.random()*35);
				}
			}
			if(temp==0){
				temp=1;
			}
			
			String te="aa"+iiii++;
			System.out.println(te+"@@@@@@@@@@");
			rs.absolute(temp);
			String sql3="insert into "+shiti_name+" (leixing,timu,xxa,xxb,xxc,xxd,daan,name_input) values('"+rs.getString(2)+"','"+rs.getString(3)+"','"+rs.getString(4)+"','"+rs.getString(5)+"','"+rs.getString(6)+"','"+rs.getString(7)+"','"+rs.getString(8)+"','"+te+"')";
			cn2.update(sql3);
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		}
		return i;
	}
	public boolean eq(int a[], int num){
	
		for(int i=0;i<a.length;i++){
			
			if(a[i]==num) return false; 
		}
		return true;
	}
	public static void main(String[] args){
		int[] a = {1,2,3,4,5,6,8,9,0,11,12,13,14,15,16};
		System.out.println(new ADD_shijuan().eq(a,44));
	}
}