initboss.java

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

package swing;

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

public class Initboss{
	
	private String names="";
	private String lmname="";
	private String address="";
	private String lkduty="";
	private String tel="";
	private String lktel="";
	private String fax="";
	private String lkhandset="";
	private String email="";
	private String sql="";
	private int aa=0;
	private String test="";
	private String upid="";
	
	Condata con=new Condata();
	Connection conn=null;
	
	public String toInsert(String test){
		this.test=test;
		if(test.equals("")){
			test="无";
		}
		return test;
	}
	
	public void setNames(String names){
		this.names=names;
	}
	public void setLmname(String lmname){
		this.lmname=lmname;
	}
	public void setAddress(String address){
		this.address=address;
	}
	public void setLkduty(String lkduty){
		this.lkduty=lkduty;
	}
	public void setTel(String tel){
		this.tel=tel;
	}
	public void setLktel(String lktel){
		this.lktel=lktel;
	}
	public void setFax(String fax){
		this.fax=fax;
	}
	public void setLkhandset(String lkhandset){
		this.lkhandset=lkhandset;
	}
	public void setEmail(String email){
		this.email=email;
	}
	
	public int toRs(){
		sql="insert into tb_th_boss(Name,Address,Tel,Fax,Email,Lkname,Lkduty,Lktel,Lkhandset) values('"+
				names+"','"+address+"','"+tel+"','"+fax+"','"+email+"','"+lmname+"','"+lkduty+"','"+lktel+"','"+lkhandset+"')";
		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_boss set Name='"+names+"',Address='"+address+"',Tel='"+tel+"',Fax='"+fax+"',Email='"+email+"',Lkname='"+lmname+"',Lkduty='"+lkduty+"',Lktel='"+lktel+"',Lkhandset='"+lkhandset+"' 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");
		}
	}
}