rerous.java

企业办公自动化管理系统

package swing;

import com.zh.conpool.Condata;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.PreparedStatement;
import swing.RousBean;
import java.io.Serializable;

public class ReRous implements Serializable{
	
	public RousBean rsbn;
	Condata con=new Condata();
	String name="";
	int a=0;

	public ReRous(){
		try{
			con.getConnection();
		}catch(Exception e){
			System.out.println(e.getStackTrace()+"2222222222");
		}
	}
	
	public void setRBn(RousBean rs){
		this.rsbn=rs;
	}
	
	public int Rst(String names){
		this.name=names;
		String into="update tb_roes set row11='"+rsbn.getId1()+"',row12='"+rsbn.getId2()+"',row13='"+rsbn.getId3()+"',row14='"+rsbn.getId4()
						+"',row15='"+rsbn.getId5()+"',row16='"+rsbn.getId6()+"',row17='"+rsbn.getId7()+"',row18='"+rsbn.getId8()+"',row19='"+rsbn.getId9()
						+"',row110='"+rsbn.getId10()+"',row111='"+rsbn.getId11()+"',row112='"+rsbn.getId12()+"',row113='"+rsbn.getId13()
						+"',row114='"+rsbn.getId14()+"',row115='"+rsbn.getId15()+"',row116='"+rsbn.getId16()+"',row117='"+rsbn.getId17()
						+"',row118='"+rsbn.getId18()+"',row119='"+rsbn.getId19()+"',row120='"+rsbn.getId20()+"',row121='"+rsbn.getId21()
						+"',row122='"+rsbn.getId22()+"',row123='"+rsbn.getId23()+"',row124='"+rsbn.getId24()+"',row125='"+rsbn.getId25()
						+"',row126='"+rsbn.getId26()+"' where perNam='"+this.name+"'";
		try{
			a=con.executeUpdate(into);
		}catch(Exception ee){
			System.out.println(ee.getStackTrace()+"11111111111");
		}
		return a;
	}
	
	public void close(){
		try{
			con.close();
		}catch(Exception e){
			
		}finally{
			con.close();
		}
	}
}