prlinfodaoimpl.java

java开发的系统,主要用SS框架,以供大家研究和参考学习.

package com.fpms.wwyz.model.dao.baseInfoManage.baseInfo.impl;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.springframework.jdbc.core.RowCallbackHandler;
import org.springframework.jdbc.core.support.JdbcDaoSupport;

import com.fpms.wwyz.model.dao.baseInfoManage.baseInfo.IPrlinfoDAO;
import com.fpms.wwyz.model.utils.Page;
import com.fpms.wwyz.model.utils.SplitPageSql;
import com.fpms.wwyz.vo.baseInfoManage.baseInfo.PrlinfoVO;

public class PrlinfoDAOImpl extends JdbcDaoSupport implements IPrlinfoDAO {

	public void deletPrl(Integer uuid) {
		StringBuffer delete = new StringBuffer(
				"delete from priinfo where uuid=");
		delete.append(uuid);
		getJdbcTemplate().execute(delete.toString());

	}

	public List<PrlinfoVO> findAllPrl(Page page, Integer uuid) {
		String select = "select  uuid,dutynum,dutyname,dutyremark from priinfo";
		String selectall = SplitPageSql.splitPageSql(select, page, "uuid");
		final List<PrlinfoVO> prllist = new ArrayList<PrlinfoVO>();
		getJdbcTemplate().query(selectall.toString(), new RowCallbackHandler() {
			public void processRow(ResultSet rs) throws SQLException {
				PrlinfoVO prlinfoVO = new PrlinfoVO();
				prlinfoVO.setUuid(rs.getInt("uuid"));
				prlinfoVO.setDutynum(rs.getString("dutynum"));
				prlinfoVO.setDutyname(rs.getString("dutyname"));
				prlinfoVO.setDutyremark(rs.getString("dutyremark"));
				prllist.add(prlinfoVO);
			}
		});
		return prllist;
	}

	public PrlinfoVO getPrlById(Integer uuid) {
		StringBuffer selectid = new StringBuffer(
				"select uuid,dutynum,dutyname,dutyremark from priinfo where uuid=");
		selectid.append(uuid);
		final PrlinfoVO prlinfoVO = new PrlinfoVO();
		getJdbcTemplate().query(selectid.toString(), new RowCallbackHandler() {
			public void processRow(ResultSet rs) throws SQLException {
				prlinfoVO.setUuid(rs.getInt("uuid"));
				prlinfoVO.setDutynum(rs.getString("dutynum"));
				prlinfoVO.setDutyname(rs.getString("dutyname"));
				prlinfoVO.setDutyremark(rs.getString("dutyremark"));

			}

		});
		return prlinfoVO;
	}

	public void savePrl(PrlinfoVO prlinfoVO) {
		StringBuffer insert = new StringBuffer(
				"insert into priinfo(dutynum,dutyname,dutyremark) values('");
		insert.append(prlinfoVO.getDutynum()).append("','").append(
				prlinfoVO.getDutyname()).append("','").append(
				prlinfoVO.getDutyremark()).append("')");
		getJdbcTemplate().execute(insert.toString());

	}

	public void updatePrl(PrlinfoVO prlinfo) {
		StringBuffer update = new StringBuffer("update priinfo set dutynum='");
		update.append(prlinfo.getDutynum()).append("',").append("dutyname='")
				.append(prlinfo.getDutyname()).append("',").append(
						"dutyremark='").append(prlinfo.getDutyremark()).append(
						"'").append("where uuid=").append(prlinfo.getUuid());

		getJdbcTemplate().execute(update.toString());
	}

	public List<PrlinfoVO> findPrlByDutyname(PrlinfoVO prlinfo,Page page) {
		StringBuffer selectname = new StringBuffer(
				"select   uuid,dutynum,dutyname,dutyremark from priinfo where dutyname='");
		selectname.append(prlinfo.getDutyname()).append("'");
		String selectallname = SplitPageSql.splitPageSql(selectname.toString(), page, "uuid");
		final List<PrlinfoVO> prllistByname = new ArrayList<PrlinfoVO>();
		getJdbcTemplate().query(selectallname.toString(),
				new RowCallbackHandler() {
					public void processRow(ResultSet rs) throws SQLException {
						PrlinfoVO prlinfoVO = new PrlinfoVO();
						prlinfoVO.setUuid(rs.getInt("uuid"));
						prlinfoVO.setDutynum(rs.getString("dutynum"));
						prlinfoVO.setDutyname(rs.getString("dutyname"));
						prlinfoVO.setDutyremark(rs.getString("dutyremark"));
						prllistByname.add(prlinfoVO);

					}

				});
		return prllistByname;
	}

	public Integer getPrlRows() {

		return getJdbcTemplate().queryForInt("select count(*) from priinfo");

	}

	public Integer getPrlRowsBydutyname(PrlinfoVO prlinfo) {
		return getJdbcTemplate().queryForInt(
				"select count(*) from priinfo where dutyname='"
						+ prlinfo.getDutyname()+"'");
	}

	public List<PrlinfoVO> findAllDutyname() {
		// TODO Auto-generated method stub
		String selectbyname="select distinct dutyname from priinfo";
		final List<PrlinfoVO> prllistBynamelist = new ArrayList<PrlinfoVO>();
		getJdbcTemplate().query(selectbyname, new RowCallbackHandler(){
			public void processRow(ResultSet rs) throws SQLException {
				PrlinfoVO prlinfoVO = new PrlinfoVO();
				prlinfoVO.setDutyname(rs.getString("dutyname"));
				prllistBynamelist.add(prlinfoVO);
			}
			
		});
		
		
		return prllistBynamelist;
	}



}