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);
}
}