饭卡管理系统、java、ssh2项目源码、数据库

package com.wei.biz.impl; import java.sql.Connection; import java.sql.ResultSet; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.List; import com.wei.biz.InfosBiz; import com.wei.dao.CommonDao; import com.wei.entity.Infos; import com.wei.entity.PageResult; import com.wei.entity.Types; public class InfosBizImpl implements InfosBiz{ private CommonDao dao; public void setDao(CommonDao dao) { this.dao = dao; } public void addTypes(Types item) { dao.add(item); } public void addInfo(Infos item) { dao.add(item); } public List searInfos(Infos item) { List items=new ArrayList(); Connection conn=null; java.sql.Statement stat = null; ResultSet rs = null; List l=new ArrayList(); String sql="select cardno,sum(money) from infos where 1=1"; if(item.getCardno()!=null && !"".equals(item.getCardno())) sql+=" and cardno like '%"+item.getCardno()+"%'"; if(item.getUname()!=null && !"".equals(item.getUname())) sql+=" and uname like '%"+item.getUname()+"%'"; if(item.getTypename()!=null && !"".equals(item.getTypename())) sql+=" and typename like '%"+item.getTypename()+"%'"; if(item.getMoney()!=null && !"".equals(item.getMoney())) sql+=" and money = "+item.getMoney(); if(item.getMydate()!=null && !"".equals(item.getMydate())){ SimpleDateFormat d = new SimpleDateFormat("yyyy-MM-dd"); String creatdate = d.format(item.getMydate()); sql+=" and mydate <= '"+creatdate+"'"; } sql+=" group by cardno"; System.out.println(sql); try { conn =DBConnection.getConn(); stat = conn.createStatement(); rs = stat.executeQuery(sql); while (rs.next()){ String [] value=new String[2]; value[0]=rs.getString(1); value[1]=String.valueOf(rs.getDouble(2)); l.add(value); } } catch (Exception ex) { ex.printStackTrace(); } finally { try { if (rs != null) rs.close(); if (stat != null) stat.close(); if(conn!=null){ conn.close(); } } catch (Exception ex) { ex.printStackTrace(); } } for (int i = 0; i < l.size(); i++) { String [] v=(String[])l.get(i); System.out.println(v[0]); } try { conn =DBConnection.getConn(); stat = conn.createStatement(); for (int i = 0; i < l.size(); i++) { String [] v=(String[])l.get(i); System.out.println(v[0]); stat = conn.createStatement(); rs = stat.executeQuery("select * from infos where cardno='"+v[0].trim()+"' order by id desc"); if (rs.next()){ Infos item2=new Infos(); item2.setCardno(v[0]); item2.setUname(rs.getString("uname")); item2.setTypename(rs.getString("typename")); item2.setMoney(Double.valueOf(v[1])); item2.setMydate(rs.getDate("mydate")); items.add(item2); } stat.close(); } } catch (Exception ex) { ex.printStackTrace(); } finally { try { if (rs != null) rs.close(); if (stat != null) stat.close(); if(conn!=null){ conn.close(); } } catch (Exception ex) { ex.printStackTrace(); } } return items; } public List getInfos() { return dao.search("from Infos group by cardno"); } public PageResult getPageResult(PageResult page, Object item) { return dao.getPageResult(page, item); } }