proinfodaoimpl.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.IProinfoDAO;
import com.fpms.wwyz.model.utils.Page;
import com.fpms.wwyz.model.utils.SplitPageSql;
import com.fpms.wwyz.vo.baseInfoManage.baseInfo.ProinfoVO;

public class ProinfoDAOImpl extends JdbcDaoSupport implements IProinfoDAO {
	public void deletPro(Integer uuid) {
		StringBuffer delete = new StringBuffer(
				"delete from proinfo where uuid=");
		delete.append(uuid);
		getJdbcTemplate().execute(delete.toString());

	}

	public List<ProinfoVO> findAllPro(Page page) {
		String select = "select  uuid,pronum,proname,proagent,protele,proagenttele,prolink,proagentlink,proaddress,proagentaddress,proremark from proinfo ";
		String selectall = SplitPageSql.splitPageSql(select, page, "uuid");
		final List<ProinfoVO> prolist = new ArrayList<ProinfoVO>();
		getJdbcTemplate().query(selectall.toString(), new RowCallbackHandler() {
			public void processRow(ResultSet rs) throws SQLException {
				ProinfoVO proinfoVO = new ProinfoVO();
				proinfoVO.setUuid(rs.getInt("uuid"));
				proinfoVO.setPronum(rs.getString("pronum"));
				proinfoVO.setProname(rs.getString("proname"));
				proinfoVO.setProagent(rs.getString("proagent"));
				proinfoVO.setProtele(rs.getString("protele"));
				proinfoVO.setProagenttele(rs.getString("proagenttele"));
				proinfoVO.setProlink(rs.getString("prolink"));
				proinfoVO.setProagentlink(rs.getString("proagentlink"));
				proinfoVO.setProaddress(rs.getString("proaddress"));
				proinfoVO.setProagentaddress(rs.getString("proagentaddress"));
				proinfoVO.setProremark(rs.getString("proremark"));
				prolist.add(proinfoVO);
			}
		});
		return prolist;
	}

	public ProinfoVO getProById(Integer uuid) {
		StringBuffer selectid = new StringBuffer(
				"select uuid,pronum,proname,proagent,protele,proagenttele,prolink,proagentlink,proaddress,proagentaddress,proremark from proinfo where uuid=");
		selectid.append(uuid);
		final ProinfoVO proinfoVO = new ProinfoVO();
		getJdbcTemplate().query(selectid.toString(), new RowCallbackHandler() {
			public void processRow(ResultSet rs) throws SQLException {
				proinfoVO.setUuid(rs.getInt("uuid"));
				proinfoVO.setPronum(rs.getString("pronum"));
				proinfoVO.setProname(rs.getString("proname"));
				proinfoVO.setProagent(rs.getString("proagent"));
				proinfoVO.setProtele(rs.getString("protele"));
				proinfoVO.setProagenttele(rs.getString("proagenttele"));
				proinfoVO.setProlink(rs.getString("prolink"));
				proinfoVO.setProagentlink(rs.getString("proagentlink"));
				proinfoVO.setProaddress(rs.getString("proaddress"));
				proinfoVO.setProagentaddress(rs.getString("proagentaddress"));
				proinfoVO.setProremark(rs.getString("proremark"));

			}

		});
		return proinfoVO;
	}

	public void savePro(ProinfoVO proinfoVO) {
		StringBuffer insert = new StringBuffer(
				"insert into proinfo(pronum,proname,proagent,protele,proagenttele,prolink,proagentlink,proaddress,proagentaddress,proremark) values('");
		insert.append(proinfoVO.getPronum()).append("','").append(
				proinfoVO.getProname()).append("','").append(
				proinfoVO.getProagent()).append("','").append(
				proinfoVO.getProtele()).append("','").append(
				proinfoVO.getProagenttele()).append("','").append(
				proinfoVO.getProlink()).append("','").append(
				proinfoVO.getProagentlink()).append("','").append(
				proinfoVO.getProaddress()).append("','").append(
				proinfoVO.getProagentaddress()).append("','").append(
				proinfoVO.getProremark()).append("')");
		getJdbcTemplate().execute(insert.toString());

	}

	public void updatePro(ProinfoVO proinfoVO) {
		StringBuffer update = new StringBuffer("update proinfo set pronum='");
		update.append(proinfoVO.getPronum()).append("',").append("proname='")
				.append(proinfoVO.getProname()).append("',").append(
						"proagent='").append(proinfoVO.getProagent()).append(
						"',").append("protele='")
				.append(proinfoVO.getProtele()).append("',").append(
						"proagenttele='").append(proinfoVO.getProagenttele())
				.append("',").append("prolink='")
				.append(proinfoVO.getProlink()).append("',").append(
						"proagentlink='").append(proinfoVO.getProagentlink())
				.append("',").append("proaddress='").append(
						proinfoVO.getProaddress()).append("',").append(
						"proagentaddress='").append(
						proinfoVO.getProagentaddress()).append("',").append(
						"proremark='").append(proinfoVO.getProremark()).append(
						"'").append("where uuid=").append(proinfoVO.getUuid());

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

	public List<ProinfoVO> findProByDutyname(ProinfoVO proinfoVO, Page page) {
		StringBuffer selectname = new StringBuffer(
				"select   uuid,pronum,proname,proagent,protele,proagenttele,prolink,proagentlink,proaddress,proagentaddress,proremark from proinfo where proname='");
		selectname.append(proinfoVO.getProname()).append("'");
		String selectallname = SplitPageSql.splitPageSql(selectname.toString(),
				page, "uuid");
		final List<ProinfoVO> prolistByname = new ArrayList<ProinfoVO>();
		getJdbcTemplate().query(selectallname.toString(),
				new RowCallbackHandler() {
					public void processRow(ResultSet rs) throws SQLException {
						ProinfoVO proinfoVO = new ProinfoVO();
						proinfoVO.setUuid(rs.getInt("uuid"));
						proinfoVO.setPronum(rs.getString("pronum"));
						proinfoVO.setProname(rs.getString("proname"));
						proinfoVO.setProagent(rs.getString("proagent"));
						proinfoVO.setProtele(rs.getString("protele"));
						proinfoVO.setProagenttele(rs.getString("proagenttele"));
						proinfoVO.setProlink(rs.getString("prolink"));
						proinfoVO.setProagentlink(rs.getString("proagentlink"));
						proinfoVO.setProaddress(rs.getString("proaddress"));
						proinfoVO.setProagentaddress(rs.getString("proagentaddress"));
						proinfoVO.setProremark(rs.getString("proremark"));
						prolistByname.add(proinfoVO);

					}

				});
		return prolistByname;
	}

	public Integer getProRows() {

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

	}

	public Integer getProRowsByproname(ProinfoVO proinfoVO) {

		return getJdbcTemplate().queryForInt(
				"select count(*) from proinfo where proname='"
						+ proinfoVO.getProname() + "'");
	}

	public List<ProinfoVO> findAllProname() {
		// TODO Auto-generated method stub
		String selectbyname = "select distinct proname from proinfo";
		final List<ProinfoVO> prolistBynamelist = new ArrayList<ProinfoVO>();
		getJdbcTemplate().query(selectbyname, new RowCallbackHandler() {
			public void processRow(ResultSet rs) throws SQLException {
				ProinfoVO proinfoVO = new ProinfoVO();
				proinfoVO.setProname(rs.getString("proname"));
				prolistBynamelist.add(proinfoVO);
			}

		});

		return prolistBynamelist;
	}

}