struts2模糊查询

dao层

public interface DimDao {
//一个条件
public List<User> userdim(User user);

//两个条件且关联表格
public List<Goods> likegood(Goods goods);

//有下拉菜单
public List<Bill> billnolist(Bill bill);

}

 

public class DimDaoImpl implements DimDao {

private Connection connection = null;
private PreparedStatement p = null;
private ResultSet set = null;

//用户名模糊查询
@Override
public List<User> userdim(User user) {
// TODO Auto-generated method stub
try {
connection = DBUtil.getConnection();
String sql = "select * from T_USER where username like '%"+user.getUsername()+"%' ";
p = connection.prepareStatement(sql);
set = p.executeQuery();
List<User> list = new ArrayList<User>();

while(set.next()){
User user1 = new User();
user1.setId(set.getInt("id"));
user1.setUsername(set.getString("username"));
user1.setPassword(set.getString("password"));
user1.setSex(set.getInt("sex"));
user1.setAge(set.getInt("age"));
user1.setSalary(set.getDouble("salary"));
user1.setAddress(set.getString("address"));
user1.setPhone(set.getString("phone"));
list.add(user1);
}
return list;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}

public List<Goods> likegood(Goods goods) {
// TODO Auto-generated method stub
try {
connection = DBUtil.getConnection();
String sql = "select g.*,b.name brname,s.bid,s.sname,bi.name biname "
+ " from T_GOODS g left join T_brand b on b.id = g.brandid"
+ " inner join T_smallclass s on g.sid = s.sid"
+ " inner join T_bigclass bi on bi.id = s.bid where g.goodsname like '%"+goods.getGoodsname()+"%' ";
p = connection.prepareStatement(sql);
set = p.executeQuery();
List<Goods> list = new ArrayList<>();
while(set.next()){
Goods goods1 = new Goods();
goods1.setId(set.getInt("id"));
goods1.setGoodsname(set.getString("goodsname"));
// goods1.setBrandid(set.getInt("brandid"));
goods1.setColor(set.getString("color"));
goods1.setPrice(set.getDouble("price"));
goods1.setShangtime(set.getDate("shangtime"));
// goods1.setSid(set.getInt("sid"));
goods1.setStock(set.getInt("stock"));
goods1.setWeight(set.getDouble("weight"));
goods1.setBrand(new Brand());
goods1.getBrand().setId(set.getInt("brandid"));
goods1.getBrand().setName(set.getString("brname"));
goods1.setBigclass(new BigClass());
goods1.getBigclass().setBid(set.getInt("bid"));
goods1.getBigclass().setName(set.getString("biname"));
goods1.getBigclass().setSid(set.getInt("sid"));
goods1.getBigclass().setSname(set.getString("sname"));
list.add(goods1);
}
return list;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}

public List<Bill> billnolist(Bill bill) {
// TODO Auto-generated method stub
try {
connection = DBUtil.getConnection();
String sql = "select * from T_BILL where billno like '%"+bill.getBillno()+"%' and ispay like '%"+bill.getIspay()+"%' ";
p = connection.prepareStatement(sql);
r = p.executeQuery();
List<Bill> list = new ArrayList<Bill>();
while(r.next()){
Bill bill2 = new Bill();
bill2.setId(r.getInt("id"));
bill2.setBillno(r.getString("billno"));
bill2.setBilltamount(r.getDouble("billtamount"));
bill2.setIspay(r.getString("ispay"));
bill2.setPaytype(r.getString("paytype"));
bill2.setPdesc(r.getString("pdesc"));
bill2.setTradenum(r.getInt("tradenum"));
list.add(bill2);
}
return list;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}

}

service

public interface DimService {
//用户名模糊查询
public List<User> userdim(User user);

//两个条件
public List<Goods> likegood(Goods goods);

//有下拉菜单
public List<Bill> billnolist(Bill bill);

}

 

public class DimServiceImpl implements DimService {
private DimDao dimdao = new DimDaoImpl();
public DimDao getDimdao() {
return dimdao;
}

public void setDimdao(DimDao dimdao) {
this.dimdao = dimdao;
}
//用户名模糊查询
@Override
public List<User> userdim(User user) {
// TODO Auto-generated method stub
return dimdao.userdim(user);
}

//商品模糊查询
@Override
public List<Goods> likegood(Goods goods) {
// TODO Auto-generated method stub
return dimdao.likegood(goods);
}

@Override
public List<Bill> billnolist(Bill bill) {
// TODO Auto-generated method stub
return dimdao.billnolist(bill);
}

}

action

 

//用户名模糊查询
public String likeuser(){
ActionContext ac = ActionContext.getContext();
Map<String, Object> session= ac.getSession();
session.put("userlike", user.getUsername());
userlist = dimservice.userdim(user);
return SUCCESS;
}

//商品模糊查询
public String goodlike(){
ActionContext ac = ActionContext.getContext();
Map<String, Object> session = ac.getSession();
session.put("goodlike", goods.getGoodsname());

goodslist = goodsservice.likegood(goods);
return SUCCESS;
}

//账单模糊查找
public String billlike(){
ActionContext actionContext =ActionContext.getContext();
Map<String, Object> session = actionContext.getSession();
session.put("billno", bill.getBillno());
session.put("ispay", bill.getIspay());
System.out.println(bill);
list = billService.billnolist(bill);
return SUCCESS;
}

 

struts.xml

 

<!-- 用户模糊 -->
<action name="likeuser" class="com.oak.action.LikeAction" method="likeuser">
<result name="success">
/userAdmin.jsp
</result>
</action>

<!-- 商品模糊查询 -->
<action name="goodlike" class="com.oak.action.GoodsAction" method="goodlike">
<result name="success">
/goods.jsp
</result>
</action>

<action name="billlike" class="com.oak.action.BillAction" method="billlike">
<result name="success">
/admin_bill_list.jsp
</result>

</action>

 

 

前台

 

下拉菜单选中状态

<script type="text/javascript" src="js/jquery-3.2.1.min.js"></script>

<script type="text/javascript">
$(function(){
$("#haha").val("${ispay}");
});
</script>