ptrain.java

图书

package thizlinux.linuxhr;

import java.sql.*;
import java.text.*;
import java.util.*;

public class ptrain {

	private String uid="";
	private String id="";
	private String sdate="";
	private String edate="";
	private String institution="";
	private String location="";
	private String course="";
	private String certification="";
	private String description="";

	private boolean status=true;
	private Vector idl=new Vector();
	private Vector sdatel=new Vector();
	private Vector edatel=new Vector();
	private Vector institutionl=new Vector();
	private Vector coursel=new Vector();
	
	public Iterator getIdl(){
		return idl.iterator();
	}
	public Iterator getSdatel(){
		return sdatel.iterator();
	}
	public Iterator getEdatel(){
		return edatel.iterator();
	}
	public Iterator getInstitutionl(){
		return institutionl.iterator();
	}
	public Iterator getCoursel(){
		return coursel.iterator();
	}

	public void setUid(String value){
		this.uid=value;
		}
	public String getUid(){
		return this.uid;
	}	

	public void setId(String value){
		this.id=value;
		}
	public String getId(){
		return this.id;
	}	

	public void setSdate(String value){
		this.sdate=value;
		}
	public String getSdate(){
		return this.sdate;
	}	

	public void setEdate(String value){
		this.edate=value;
		}
	public String getEdate(){
		return this.edate;
	}	
	
	public void setInstitution(String value){
		this.institution=value;
		}
	public String getInstitution(){
		return this.institution;
	}	
	
	public void setLocation(String value){
		this.location=value;
		}
	public String getLocation(){
		return this.location;
	}	
	
	public void setCourse(String value){
		this.course=value;
		}
	public String getCourse(){
		return this.course;
	}	
	
	public void setCertification(String value){
		this.certification=value;
		}
	public String getCertification(){
		return this.certification;
	}	

	public void setDescription(String value){
		this.description=value;
		}
	public String getDescription(){
		return this.description;
	}	
	

	
	public void refresh(){
		DBconnect dbconn =new DBconnect();
		idl.clear();
		sdatel.clear();
		edatel.clear();
		institutionl.clear();
		coursel.clear();
		ResultSet rs=null;
		String sql="";
		try{
			sql="select id,sdate,edate,institution,course from tbl_ptrain where uid='"+this.uid+"'";
			rs=dbconn.executeQuery(sql);
			while(rs.next()){
				idl.add(pub.datachange(rs.getString("id")));
				sdatel.add(pub.datachange(rs.getString("sdate")));
				edatel.add(pub.datachange(rs.getString("edate")));
				institutionl.add(pub.datachange(rs.getString("institution")));
				coursel.add(pub.datachange(rs.getString("course")));
			}  
			
			sql="select sdate,edate,institution,location,course,certification,description "+
					   "from tbl_ptrain where id='"+this.id+"' and uid='" +this.uid+"'";
			rs=dbconn.executeQuery(sql);
			if(rs.next()){  
				this.sdate=pub.datachange(rs.getString("sdate"));
				this.edate=pub.datachange(rs.getString("edate"));                  
				this.institution=pub.datachange(rs.getString("institution"));                  
				this.location=pub.datachange(rs.getString("location"));                  
				this.course=pub.datachange(rs.getString("course"));                  
				this.certification=pub.datachange(rs.getString("certification"));                  
				this.description=pub.datachange(rs.getString("description"));                  
			}
			else{
				reset();
			}
		}catch(Exception e){
			System.out.println(e+",sql="+sql);
			status=false;
		}finally{
			try{
				if(rs!=null)rs.close();
				if(dbconn!=null)dbconn.close();
			}catch(Exception e){
				System.out.println(e);
			}
		}		
	}
	public boolean update(){
		status=true;
		if(sdate==null||sdate.equalsIgnoreCase(""))
                {
                        return false;
                }
		DBconnect dbconn =new DBconnect();
		String sql="";
		try{
			sql = "delete from tbl_ptrain where uid='" + this.uid + "' and id='"+this.id+"'";
			dbconn.executeUpdate(sql);            
			sql="insert into tbl_ptrain(id,uid,sdate,edate,institution,location,course,certification,description) "+
                       "values('',"+
			    "'"+this.uid+"',"+
			    "'"+this.sdate+"',"+
			    "'"+this.edate+"',"+
			    "'"+this.institution+"',"+
			    "'"+this.location+"',"+
			    "'"+this.course+"',"+
			    "'"+this.certification+"',"+
			    "'"+this.description+"')";
			dbconn.executeUpdate(sql);
			reset();
		}catch(Exception e){
			System.out.println(e+",sql="+sql);
			status=false;
		}finally{
			try{
				if(dbconn!=null)dbconn.close();
			}catch(Exception e){
				System.out.println(e);
			}
		}
		return  status;	
	}
	public boolean remove(){
		status=true;
		DBconnect dbconn =new DBconnect();
		String sql="";
		try{
			sql = "delete from tbl_ptrain where uid='" + this.uid + "' and id='"+this.id+"'";
			dbconn.executeUpdate(sql);
			this.id="";
		}catch(Exception e){
			System.out.println(e+",sql="+sql);
			status=false;
		}finally{
			try{
				if(dbconn!=null)dbconn.close();
			}catch(Exception e){
				System.out.println(e);
			}
		}
		return  status;	
	}
	public void reset(){
		this.sdate="";
		this.edate="";
		this.institution="";
		this.location="";
		this.course="";
		this.certification="";
		this.description="";
	}
}