equsortinfodaoimpl.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.IEqusortinfoDAO;
import com.fpms.wwyz.model.utils.Page;
import com.fpms.wwyz.model.utils.SplitPageSql;
import com.fpms.wwyz.vo.baseInfoManage.baseInfo.EqusortinfoVO;


public class EqusortinfoDAOImpl extends JdbcDaoSupport implements
		IEqusortinfoDAO {

	public void deletEqusort(Integer uuid) {
		// TODO Auto-generated method stub
		StringBuffer delete = new StringBuffer(
				"delete from equsortinfo where uuid=");
		delete.append(uuid);
		getJdbcTemplate().execute(delete.toString());

	}

	public List<EqusortinfoVO> findAllEquname() {

		String selectbyname = "select distinct equname from equsortinfo";
		final List<EqusortinfoVO> EqusortlistBynamelist = new ArrayList<EqusortinfoVO>();
		getJdbcTemplate().query(selectbyname, new RowCallbackHandler() {
			public void processRow(ResultSet rs) throws SQLException {
				EqusortinfoVO equsortinfoVO = new EqusortinfoVO();
				equsortinfoVO.setEquname(rs.getString("equname"));
				EqusortlistBynamelist.add(equsortinfoVO);
			}

		});
		return EqusortlistBynamelist;
	}

	public List<EqusortinfoVO> findAllEqusort(Page page) {
		// TODO Auto-generated method stub
		String select = "select  uuid,equnum,equname,equremark from equsortinfo ";
		String selectall = SplitPageSql.splitPageSql(select, page, "uuid");
		final List<EqusortinfoVO> equsortlist = new ArrayList<EqusortinfoVO>();
		getJdbcTemplate().query(selectall.toString(), new RowCallbackHandler() {
			public void processRow(ResultSet rs) throws SQLException {
				EqusortinfoVO equsortinfoVO = new EqusortinfoVO();
				equsortinfoVO.setUuid(rs.getInt("uuid"));
				equsortinfoVO.setEqunum(rs.getString("equnum"));
				equsortinfoVO.setEquname(rs.getString("equname"));
				equsortinfoVO.setEquremark(rs.getString("equremark"));
				equsortlist.add(equsortinfoVO);
			}
		});

		return equsortlist;
	}

	public List<EqusortinfoVO> findEqusortByEquname(EqusortinfoVO equsortinfo,
			Page page) {
		// TODO Auto-generated method stub

		StringBuffer selectname = new StringBuffer(
				"select   uuid,equnum,equname,equremark from equsortinfo where equname='");
		selectname.append(equsortinfo.getEquname()).append("'");
		String selectallname = SplitPageSql.splitPageSql(selectname.toString(),
				page, "uuid");
		final List<EqusortinfoVO> equsortlistByname = new ArrayList<EqusortinfoVO>();
		getJdbcTemplate().query(selectallname.toString(),
				new RowCallbackHandler() {
					public void processRow(ResultSet rs) throws SQLException {
						EqusortinfoVO equsortinfoVO = new EqusortinfoVO();
						equsortinfoVO.setUuid(rs.getInt("uuid"));
						equsortinfoVO.setEqunum(rs.getString("equnum"));
						equsortinfoVO.setEquname(rs.getString("equname"));
						equsortinfoVO.setEquremark(rs.getString("equremark"));
						equsortlistByname.add(equsortinfoVO);

					}

				});
		return equsortlistByname;
	}

	public EqusortinfoVO getEqusortById(Integer uuid) {
		// TODO Auto-generated method stub
		StringBuffer selectid = new StringBuffer(
				"select uuid,equnum,equname,equremark from equsortinfo where uuid=");
		selectid.append(uuid);
		final EqusortinfoVO equsortinfoVO = new EqusortinfoVO();
		getJdbcTemplate().query(selectid.toString(), new RowCallbackHandler() {
			public void processRow(ResultSet rs) throws SQLException {
				equsortinfoVO.setUuid(rs.getInt("uuid"));
				equsortinfoVO.setEqunum(rs.getString("equnum"));
				equsortinfoVO.setEquname(rs.getString("equname"));
				equsortinfoVO.setEquremark(rs.getString("equremark"));

			}

		});
		return equsortinfoVO;
	}

	public Integer getEqusortRows() {
		// TODO Auto-generated method stub
		return getJdbcTemplate()
				.queryForInt("select count(*) from equsortinfo");
	}

	public Integer getEqusortRowsByequname(EqusortinfoVO equsortinfo) {
		// TODO Auto-generated method stub
		return getJdbcTemplate().queryForInt(
				"select count(*) from equsortinfo where equname='"
						+ equsortinfo.getEquname() + "'");
	}

	public void saveEqusort(EqusortinfoVO equsortinfo) {
		// TODO Auto-generated method stub
		StringBuffer insert = new StringBuffer(
				"insert into equsortinfo(equnum,equname,equremark) values('");
		insert.append(equsortinfo.getEqunum()).append("','").append(
				equsortinfo.getEquname()).append("','").append(
				equsortinfo.getEquremark()).append("')");
		getJdbcTemplate().execute(insert.toString());
	}

	public void updateEqusort(EqusortinfoVO equsortinfo) {
		// TODO Auto-generated method stub
		StringBuffer update = new StringBuffer(
				"update equsortinfo set equnum='");
		update.append(equsortinfo.getEqunum()).append("',").append("equname='")
				.append(equsortinfo.getEquname()).append("',").append(
						"equremark='").append(equsortinfo.getEquremark())
				.append("'").append("where uuid=")
				.append(equsortinfo.getUuid());

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

	}

}