fpms.rar_NGY2_fpms系统_herselff4s_nativeqz9_quick1j2

package com.fpms.wwyz.model.dao.baseInfoManage.beforeManage.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.beforeManage.IProinfoDAO; import com.fpms.wwyz.model.utils.Page; import com.fpms.wwyz.model.utils.SplitPageSql; import com.fpms.wwyz.vo.baseInfoManage.beforeManage.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; } }