package swing;

import com.zh.conpool.*;
import java.sql.Connection;
import swing.Datetime;


public class Init_out_distory{
	
	private String names="";
	private String num="";
	private String menoy="";
	private String dimo="";
	private String type="";
	private String units="";
	private String boss="";
	private int aa=0;
	private String sql="";
	private String upid="";
	
	Condata con=new Condata();
	Connection conn=null;
	
	
	public void setNames(String names){
		this.names=names;
	}
	public void setNum(String num){
		this.num=num;
	}
	public void setMenoy(String menoy){
		this.menoy=menoy;
	}
	public void setType(String type){
		this.type=type;
	}
	public void setUnits(String units){
		this.units=units;
	}
	public void setBoss(String boss){
		this.boss=boss;
	}
	public void setDimo(String dimo){
		this.dimo=dimo;
	}
	
	public int toRs(){
		sql="insert into tb_th_plan(Name,Numbers,Type,Money,Boss,Dime,Planing,Times,Untils) values('"+
				names+"','"+num+"','"+type+"','"+menoy+"','"+boss+"','"+dimo+"','3','"+Datetime.toDate()+"','"+units+"')";
		try{
			con.getConnection();
			aa=con.executeUpdate(sql);
		}catch(Exception eee){
			aa=0;
		}
		return aa;
	}

	public int toRsup(String upid){
		this.upid=upid;
		sql="update tb_th_plan set Name='"+names+"',Numbers='"+num+"',Type='"+type+"',Money='"+menoy+"',Boss='"+boss+"',Dime='"+dimo+"',Planing='3',Times='"+Datetime.toDate()+"',Untils='"+units+"' where ID='"+upid+"'";
		try{
			con.getConnection();
			aa=con.executeUpdate(sql);
		}catch(Exception eee){
			aa=0;
		}
		return aa;
	}

	public void close(){
		try{
			conn=null;
		}catch(Exception e){
			System.out.print("f1");
		}
		try{
			con.close();
			con=null;
		}catch(Exception ee){
			System.out.print("f");
		}
	}
}