rousdb.java

改代码是采用JSP实现的在线办公自动化管理系统

package swing;

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

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

	public RousDB(){
		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="insert into tb_roes("+
						"perNam,row11,row12,row13,row14,row15,row16,row17,row18,"+
						"row19,row110,row111,row112,row113,row114,row115,row116,"+
						"row117,row118,row119,row120,row121,row122,row123,row124,"+
						"row125,row126) values('"+this.name+"','"+
						rsbn.getId1()+"','"+rsbn.getId2()+"','"+rsbn.getId3()+"','"+
						rsbn.getId4()+"','"+rsbn.getId5()+"','"+rsbn.getId6()+"','"+
						rsbn.getId7()+"','"+rsbn.getId8()+"','"+rsbn.getId9()+"','"+
						rsbn.getId10()+"','"+rsbn.getId11()+"','"+rsbn.getId12()+"','"+
						rsbn.getId13()+"','"+rsbn.getId14()+"','"+rsbn.getId15()+"','"+
						rsbn.getId16()+"','"+rsbn.getId17()+"','"+rsbn.getId18()+"','"+
						rsbn.getId19()+"','"+rsbn.getId20()+"','"+rsbn.getId21()+"','"+
						rsbn.getId22()+"','"+rsbn.getId23()+"','"+rsbn.getId24()+"','"+
						rsbn.getId25()+"','"+rsbn.getId26()+"')";
		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();
		}
	}
}