java8生成jsp页面内容组装到jsp中_如何将Java中数据显示到jsp页面之中

packagecom.chk.doubleball.setvlet;importjava.io.IOException;importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.util.ArrayList;importjava.util.TreeSet;importjavax.servlet.ServletException;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importcom.chk.doubleball.model.Bonus;importcom.chk.doubleball.model.DdwhOne;importcom.chk.doubleball.util.DBUtil;public class SearchDdwhoneServlet extendsHttpServlet {private static final long serialVersionUID = 1L;public void doGet(HttpServletRequest request, HttpServletResponse response) throwsServletException, IOException {//1、查询数据

ArrayList ddwhoneList = new ArrayList();

String sql= "select * from t_bonus where _id > (select count(*) from t_bonus) - 100;";

Connection conn=DBUtil.getConn();

PreparedStatement pstmt= null;

PreparedStatement pstmt1= null;

ResultSet rs= null;

ResultSet rs1= null;try{

pstmt=conn.prepareStatement(sql);

rs=pstmt.executeQuery();while(rs.next()) {

DdwhOne d= newDdwhOne();

d.set_id(rs.getInt("_id"));

d.setIssue(rs.getInt("issue"));

d.setOrder_red_one(rs.getString("order_red_one"));

d.setOrder_red_two(rs.getString("order_red_two"));

d.setOrder_red_three(rs.getString("order_red_three"));

d.setOrder_red_four(rs.getString("order_red_four"));

d.setOrder_red_five(rs.getString("order_red_five"));

d.setOrder_red_six(rs.getString("order_red_six"));

d.setBlue(rs.getString("blue"));//调用前一期的数据

ArrayList danArrayList = new ArrayList();int idNum = d.get_id() - 1;

pstmt1= conn.prepareStatement("select * from t_bonus where _id = ? ");

pstmt1.setInt(1, idNum);

rs1=pstmt1.executeQuery();

Bonus b= newBonus();while(rs1.next()) {

b.setIssue(rs1.getInt("issue"));

b.setOrder_red_one(rs1.getString("order_red_one"));

b.setOrder_red_two(rs1.getString("order_red_two"));

b.setOrder_red_three(rs1.getString("order_red_three"));

b.setOrder_red_four(rs1.getString("order_red_four"));

b.setOrder_red_five(rs1.getString("order_red_five"));

b.setOrder_red_six(rs1.getString("order_red_six"));

b.setBlue(rs1.getString("blue"));//第一组胆码:红一位 + 蓝

int dan_one = Integer.parseInt(b.getOrder_red_one()) +Integer.parseInt(b.getBlue());if (dan_one > 33) {

dan_one= dan_one - 33;

}int dan_one_a = dan_one - 1;int dan_one_b = dan_one + 1;//第二组胆码:红三位拆分 + 篮球拆分

int a_ch1 = Integer.parseInt(String.valueOf(b.getOrder_red_three().charAt(0)));int a_ch2 = Integer.parseInt(String.valueOf(b.getOrder_red_three().charAt(1)));int b_ch1 = Integer.parseInt(String.valueOf(b.getBlue().charAt(0)));int b_ch2 = Integer.parseInt(String.valueOf(b.getBlue().charAt(1)));int dan_two = a_ch1 + a_ch2 + b_ch1 +b_ch2;int dan_two_a = dan_two + 1;int dan_two_b = dan_two - 1;//第三组胆码:红二位 + 篮球

int dan_three = Integer.parseInt(b.getOrder_red_two()) +Integer.parseInt(b.getBlue());if (dan_three > 33) {

dan_three= dan_three - 33;

}int dan_three_a = dan_three - 1;int dan_three_b = dan_three + 1;

danArrayList.add(dan_one);

danArrayList.add(dan_one_a);

danArrayList.add(dan_one_b);

danArrayList.add(dan_two);

danArrayList.add(dan_two_a);

danArrayList.add(dan_two_b);

danArrayList.add(dan_three);

danArrayList.add(dan_three_a);

danArrayList.add(dan_three_b);//剔除重复并排序

TreeSet ts = new TreeSet(danArrayList);

danArrayList.clear();

danArrayList.addAll(ts);/** 计算出来的所有值都保存在danArrayList中,现在我想要把danArrayList中的数据都显示在jsp页面中,请问我该怎么办?

**/}

ddwhoneList.add(d);

}

}catch(SQLException e) {//TODO Auto-generated catch block

e.printStackTrace();

}finally{

DBUtil.close(rs);

DBUtil.close(pstmt);

DBUtil.close(conn);

}

request.setAttribute("ddwhoneList", ddwhoneList);//2、跳转

request.getRequestDispatcher("/table/table_dadiweihong.jsp").forward(request, response);

}public void doPost(HttpServletRequest request, HttpServletResponse response) throwsServletException, IOException {

doGet(request, response);

}

}

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值