jobbean.java

应用java中的jsf技术进行的一个单表的增删改代码

package com.xaccp.dao;

import java.util.*;
import javax.faces.event.ActionEvent;
import javax.faces.model.DataModel;
import javax.faces.model.ListDataModel;
import javax.swing.ListModel;

import com.xaccp.vo.JobVo;

public class JobBean {

	private int jobId;
	private String jobDesc;
	private int minLvl;
	private int maxLvl;
	private List jobList;
	private String sql="select * from jobs";
	private DataModel model;
	//分页
	private int first=0;
	private int rows=3;
	
	public String mypage(ActionEvent e){
		String id=e.getComponent().getId();
		if(id.equals("first")){
			first=0; 
		}
		if(id.equals("pre")){
			if(first-rows>=0){
				first=first-rows;
			}else{
				first=0;
			}
		}
		if(id.equals("next")){
			if(model==null)return null;
			if(first+rows<model.getRowCount()){
				first=first+rows;
			}else{
				first=(model.getRowCount()-1)*rows/rows;
			}
		}
		if(id.equals("last")){
			if(model==null)return null;
			first=(model.getRowCount()-1)*rows/rows;
		}
		return null;
	}
	
	public String getJobDesc() {
		return jobDesc;
	}
	public void setJobDesc(String jobDesc) {
		this.jobDesc = jobDesc;
	}
	public int getJobId() {
		return jobId;
	}
	public void setJobId(int jobId) {
		this.jobId = jobId;
	}
	public int getMaxLvl() {
		return maxLvl;
	}
	public void setMaxLvl(int maxLvl) {
		this.maxLvl = maxLvl;
	}
	public int getMinLvl() {
		return minLvl;
	}
	public void setMinLvl(int minLvl) {
		this.minLvl = minLvl;
	}
	public JobBean() {
		
	}	
	public JobBean(JobVo job){
		this.setJobId(job.getJobId());
		this.setJobDesc(job.getJobDesc());
		this.setMaxLvl(job.getMaxLvl());
		this.setMinLvl(job.getMinLvl());
	}
	//查询
	public DataModel getModel(){
		JobDao dao=new JobDao();
		List list=dao.getAllJob(sql);
		List li=new Vector();
		for (int i = 0; i < list.size(); i++) {
			JobBean jj=new JobBean((JobVo)list.get(i));
			li.add(jj);
		}
		model=new ListDataModel(li);
		return model;
	}
	
	/**
	 * 添加
	 * @return
	 */
	public String insertJob(){
		JobVo job=new JobVo();
		JobDao dao=new JobDao();
		job.setJobDesc(this.getJobDesc());
		job.setMaxLvl(this.getMaxLvl());
		job.setMinLvl(this.getMinLvl());
		dao.addJob(job);
		return null;
	}
	
	/**
	 * 删除
	 * @return
	 */
	public String delJob(){
		JobBean jobb=(JobBean) model.getRowData();
		JobDao dao=new JobDao();
		dao.delJob(jobb.getJobId());
		return null;
	}
	
	/**
	 * 预修改
	 * @return
	 */
	public String preUpdatJob(){
		JobBean jobb=(JobBean) model.getRowData();
		this.setJobId(jobb.getJobId());
		this.setJobDesc(jobb.getJobDesc());
		this.setMaxLvl(jobb.getMaxLvl());
		this.setMinLvl(jobb.getMinLvl());
		return null;
	}
	/**
	 * 修改
	 * @return
	 */
	public String updateJob(){
		JobVo job=new JobVo();
		JobDao dao=new JobDao();
		job.setJobId(this.getJobId());
		job.setJobDesc(this.getJobDesc());
		job.setMaxLvl(this.getMaxLvl());
		job.setMinLvl(this.getMinLvl());
		dao.updateJob(job);
		return null;
	}

	public int getFirst() {
		return first;
	}

	public int getRows() {
		return rows;
	}

	public String getSql() {
		return sql;
	}
	
	public void setSql(String sql) {
		this.sql = sql;
	}

	/**
	 * 查询
	 * @return
	 */
	public String query(){
		sql=sql+" where 1=1 and ";
		if(!jobDesc.equals("")){
			sql=sql+"job_desc like '%"+jobDesc+"%' and ";
		}
		if(minLvl>0){
			sql=sql+"min_lvl = "+minLvl+" and ";
		}
		if(maxLvl>0){
			sql=sql+"max_lvl = "+maxLvl+" and ";
		}
		if(sql.endsWith(" and ")){
			sql=sql.substring(0,sql.length()-5);
		}
		if(sql.endsWith(" where ")){
			sql=sql.substring(0,sql.length()-7);
		}
		return null;
	}
}