jobdao.java

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

package com.xaccp.dao;

import java.sql.*;
import java.util.*;
import com.xaccp.dbm.DBM;
import com.xaccp.vo.JobVo;

public class JobDao {

	/**
	 * 查询
	 * @param sql
	 * @return
	 */
	public List getAllJob(String sql){
		PreparedStatement ps=null;
		ResultSet rs=null;
		try {
			ps=DBM.getConn().prepareStatement(sql);
			rs=ps.executeQuery();
			List list=new Vector();
			while(rs.next()){
				JobVo job=new JobVo();
				job.setJobId(rs.getInt("job_id"));
				job.setJobDesc(rs.getString("job_desc"));
				job.setMinLvl(rs.getInt("min_lvl"));
				job.setMaxLvl(rs.getInt("max_lvl"));
				list.add(job);
			}
			return list;
		} catch (SQLException e) {
			e.printStackTrace();
			return null;
		}finally{
			try {
				rs.close();
				ps.close();
				DBM.getConn().close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
	
	/***
	 * 添加
	 * @param job
	 */
	public void addJob(JobVo job){
		String sql="insert into jobs values (?,?,?)";
		try {
			PreparedStatement ps=DBM.getConn().prepareStatement(sql);
			ps.setString(1, job.getJobDesc());
			ps.setInt(2, job.getMinLvl());
			ps.setInt(3, job.getMaxLvl());
			ps.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
	/**
	 * 修改
	 * @param job
	 */
	public void updateJob(JobVo job){
		String sql="update jobs set job_desc=?,min_lvl=?,max_lvl=? where job_id=?";
		try {
			PreparedStatement ps=DBM.getConn().prepareStatement(sql);
			ps.setString(1, job.getJobDesc());
			ps.setInt(2, job.getMinLvl());
			ps.setInt(3, job.getMaxLvl());
			ps.setInt(4, job.getJobId());
			ps.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
	public void delJob(int id){
		String sql="delete from jobs where job_id=?";
		try {
			PreparedStatement ps=DBM.getConn().prepareStatement(sql);
			ps.setInt(1, id);
			ps.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}