package law;
import java.sql.*;
public class parameter{
	long num;
	String time,id,ready;
	String data1,data2,data3,data4,data5,data6,data7,data8,data9,data10
		,data11,data12,data13,data14,data15,data16,data17,data18,data19,data20
		,data21,data22,data23;
	public parameter(){
		num=0;
		time="";
		id="";
		ready="false";
		data1="";
		data2="";
		data3="";
		data4="";
		data5="";
		data6="";
		data7="";
		data8="";
		data9="";
		data10="";
		data11="";
		data12="";
		data13="";
		data14="";
		data15="";
		data16="";
		data17="";
		data18="";
		data19="";
		data20="";
		data21="";
		data22="";
		data23="";
	}
	public long getNum(){return num;}
	public void setNum(long value){num=value;}
	
	public String getTime(){return time;}
	public void setTime(String value){time=value;}
	
	public String getId(){return id;}
	public void setId(String value){id=value;}
	
	public String getData1(){return data1;}
	public void setData1(String value){data1=value;}
	
	public String getData2(){return data2;}
	public void setData2(String value){data2=value;}
	
	public String getData3(){return data3;}
	public void setData3(String value){data3=value;}
	
	public String getData4(){return data4;}
	public void setData4(String value){data4=value;}
	
	public String getData5(){return data5;}
	public void setData5(String value){data5=value;}
	
	public String getData6(){return data6;}
	public void setData6(String value){data6=value;}
	
	public String getData7(){return data7;}
	public void setData7(String value){data7=value;}
	
	public String getData8(){return data8;}
	public void setData8(String value){data8=value;}
	
	public String getData9(){return data9;}
	public void setData9(String value){data9=value;}
	
	public String getData10(){return data10;}
	public void setData10(String value){data10=value;}
	
	public String getData11(){return data11;}
	public void setData11(String value){data11=value;}
	
	public String getData12(){return data12;}
	public void setData12(String value){data12=value;}
	
	public String getData13(){return data13;}
	public void setData13(String value){data13=value;}
	
	public String getData14(){return data14;}
	public void setData14(String value){data14=value;}
	
	public String getData15(){return data15;}
	public void setData15(String value){data15=value;}
	
	public String getData16(){return data16;}
	public void setData16(String value){data16=value;}
	
	public String getData17(){return data17;}
	public void setData17(String value){data17=value;}
	
	public String getData18(){return data18;}
	public void setData18(String value){data18=value;}
	
	public String getData19(){return data19;}
	public void setData19(String value){data19=value;}
	
	public String getData20(){return data20;}
	public void setData20(String value){data20=value;}
	
	public String getData21(){return data21;}
	public void setData21(String value){data21=value;}
	
	public String getData22(){return data22;}
	public void setData22(String value){data22=value;}
	
	public String getData23(){return data23;}
	public void setData23(String value){data23=value;}
		
	public String getReady(){
		//check datas here
		
		ready="true";//or false
		return ready;
	}
	public void setReady(String value){
		if(value.equals("true")||value.equals("false"))
			ready=value;
	}
	
	public String insertParameter(){
		if(ready.equals("false"))
			ready=getReady();
		if(ready.equals("true")){
			Connection con;
			Statement sql;
			ResultSet rs;
			long rowcount=0;
			try{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		      		con=DriverManager.getConnection("jdbc:odbc:law","","");
		     		sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
		     		rs=sql.executeQuery("select * from data order by num");
		     		if(rs.next()){
		     			rs.last();
		     			rowcount=rs.getLong("num");
		     		}
		     		rowcount++;
		      		String condition="insert into data values("+rowcount+",'"+time+"','"+id+"','"+data1+"','"+data2+"','"+data3+"','"+data4+"','"+data5+"','"+data6+"','"+data7+"','"+data8+"','"+data9+"','"+data10+"','"+data11+"','"+data12+"','"+data13+"','"+data14+"','"+data15+"','"+data16+"','"+data17+"','"+data18+"','"+data19+"','"+data20+"','"+data21+"','"+data22+"','"+data23+"')";
		      		sql.executeUpdate(condition);
		      		con.close();
			      	return "true";
		    	}catch(SQLException e){
		    		return "false";
		    	}catch(ClassNotFoundException e){
		    		return "false";
			}
			
		}
		return "false";
	}
	
	public String redataParameter(){
		if(!ready.equals("true"))
			ready=getReady();
		if(ready.equals("true")&&num>0){
			Connection con;
			Statement sql;
			ResultSet rs;
			try{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		      		con=DriverManager.getConnection("jdbc:odbc:law","","");
		     		sql=con.createStatement();
		     		rs=sql.executeQuery("select * from data where num="+num);
		     		if(rs.next()){
		     			String condition="update data set data1='"+data1+"',data2='"+data2+"',data3='"+data3+"',data4='"+data4+"',data5='"+data5+"',data6='"+data6+"',data7='"+data7+"',data8='"+data8+"',data9='"+data9+"',data10='"+data10+"',data11='"+data11+"',data12='"+data12+"',data13='"+data13+"',data14='"+data14+"',data15='"+data15+"',data16='"+data16+"',data17='"+data17+"',data18='"+data18+"',data19='"+data19+"',data20='"+data20+"',data21='"+data21+"',data22='"+data22+"',data23='"+data23+"' where num="+num;
		      			sql.executeUpdate(condition);
		      			con.close();
			      		return "true";
		     		}
		     		con.close();
			      	return "false:no num item";
		    	}catch(SQLException e){
		    		return "false:"+e.toString();
		    	}catch(ClassNotFoundException e){
		    		return "false:"+e.toString();
			}
			
		}
		return "false:not ready";
	}

}