IDEA写模糊查询

模糊查询结果图：

1.在Dao层和service中：

//根据商品名称查询，所有商品
List<Tbl_purchase> Mocha(String pName);

2.Dao层的实现方法

 public List<Tbl_purchase> Mocha(String pName) {
   
        Connection conn = helper.getConnection();
        List<Tbl_purchase> list = new ArrayList<Tbl_purchase>();

        try {
   
            PreparedStatement ps = conn.prepareStatement("select p.*,a.paDate,a.paState from tbl_purchase p, tbl_pur_approval a  where  a.pId=p.pId and p.pName like '%" + pName + "%'");
            ResultSet rs = ps.executeQuery();
            while (rs.next()) {
   
                Tbl_purchase p = new Tbl_purchase();
                p.setpId(rs.getInt("pId"));
                p.setpType(rs.getString("pType"));
                p.setpName(rs.getString("pName"));

                p.setpUnit(rs.getString("pUnit"));
                p.setpNum(rs.getInt("pNum"));
                p.setpPerson(rs.getString