deptinfodaoimpl.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.IDeptinfoDAO;
import com.fpms.wwyz.model.utils.Page;
import com.fpms.wwyz.model.utils.SplitPageSql;
import com.fpms.wwyz.vo.baseInfoManage.baseInfo.DeptinfoVO;
import com.fpms.wwyz.vo.baseInfoManage.baseInfo.PrlinfoVO;



public class DeptinfoDAOImpl extends JdbcDaoSupport implements IDeptinfoDAO {

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

	}

	public List<DeptinfoVO> findAllDept(Page page) {
		String select = "select uuid,depname,depcode,depremark from deptinfo";
		String selectall = SplitPageSql.splitPageSql(select, page, "uuid");
		final List<DeptinfoVO> deptlist = new ArrayList<DeptinfoVO>();
		getJdbcTemplate().query(selectall.toString(), new RowCallbackHandler() {
			public void processRow(ResultSet rs) throws SQLException {
				DeptinfoVO deptinfoVO = new DeptinfoVO();
				deptinfoVO.setUuid(rs.getInt("uuid"));
				deptinfoVO.setDepname(rs.getString("depname"));
				deptinfoVO.setDepcode(rs.getString("depcode"));
				deptinfoVO.setDepremark(rs.getString("depremark"));
				deptlist.add(deptinfoVO);
			}
		});
		return deptlist;
	}

	public DeptinfoVO getDeptById(Integer uuid) {
		StringBuffer selectid = new StringBuffer(
				"select uuid,depname,depcode,depremark from deptinfo where uuid=");
		selectid.append(uuid);
		final DeptinfoVO deptinfoVO = new DeptinfoVO();
		getJdbcTemplate().query(selectid.toString(), new RowCallbackHandler() {
			public void processRow(ResultSet rs) throws SQLException {
				deptinfoVO.setUuid(rs.getInt("uuid"));
				deptinfoVO.setDepname(rs.getString("depname"));
				deptinfoVO.setDepcode(rs.getString("depcode"));
				deptinfoVO.setDepremark(rs.getString("depremark"));

			}

		});
		return deptinfoVO;
	}

	public void saveDept(DeptinfoVO deptinfo) {
		StringBuffer insert = new StringBuffer(
				"insert into deptinfo(depname,depcode,depremark) values('");
		insert.append(deptinfo.getDepname()).append("','").append(
				deptinfo.getDepcode()).append("','").append(
				deptinfo.getDepremark()).append("')");
		getJdbcTemplate().execute(insert.toString());

	}

	public void updateDept(DeptinfoVO deptinfo) {
		StringBuffer update = new StringBuffer("update deptinfo set depname='");
		update.append(deptinfo.getDepname()).append("',").append("depcode='")
		.append(deptinfo.getDepcode()).append("',").append(
				"depremark='").append(deptinfo.getDepremark()).append(
				"'").append("where uuid=").append(deptinfo.getUuid());

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

	public List<DeptinfoVO> findDeptByDeptname(DeptinfoVO deptinfo,Page page) {
		StringBuffer selectname = new StringBuffer(
				"select uuid,depname,depcode,depremark from deptinfo where depname='");
		selectname.append(deptinfo.getDepname()).append("'");
		String selectallname = SplitPageSql.splitPageSql(selectname.toString(), page, "uuid");
		final List<DeptinfoVO> deptlistByname = new ArrayList<DeptinfoVO>();
		getJdbcTemplate().query(selectallname.toString(),
				new RowCallbackHandler() {
					public void processRow(ResultSet rs) throws SQLException {
						DeptinfoVO deptinfoVO = new DeptinfoVO();
						deptinfoVO.setUuid(rs.getInt("uuid"));
						deptinfoVO.setDepname(rs.getString("depname"));
						deptinfoVO.setDepcode(rs.getString("depcode"));
						deptinfoVO.setDepremark(rs.getString("depremark"));
						deptlistByname.add(deptinfoVO);

					}

				});
		return deptlistByname;
	}

	public Integer getDeptRows() {

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

	}

	public Integer getDeptRowsByDeptname(DeptinfoVO deptinfo) {
		return getJdbcTemplate().queryForInt(
				"select count(*) from deptinfo where depname='"
						+ deptinfo.getDepname() + "'");
	}

	public List<DeptinfoVO> findAllDeptname() {
		// TODO Auto-generated method stub
		String selectbyname="select distinct depname from deptinfo";
		final List<DeptinfoVO> deptlistBynamelist = new ArrayList<DeptinfoVO>();
		getJdbcTemplate().query(selectbyname, new RowCallbackHandler(){
			public void processRow(ResultSet rs) throws SQLException {
				DeptinfoVO deptinfoVO = new DeptinfoVO();
				deptinfoVO.setDepname(rs.getString("depname"));
				deptlistBynamelist.add(deptinfoVO);
			}
			
		});
		
		
		return deptlistBynamelist;
	}

	


}