展开全部
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.TreeSet;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.chk.doubleball.model.Bonus;
import com.chk.doubleball.model.DdwhOne;
import com.chk.doubleball.util.DBUtil;
public class SearchDdwhoneServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, 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 = new DdwhOne();
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 = new Bonus();
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"));
// 第一组胆码:红一位32313133353236313431303231363533e78988e69d8331333339653664 + 蓝
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) throws ServletException, IOException {
doGet(request, response);
}
}
String path = request.getContextPath();
String basePath = request.getScheme() + "://"
+ request.getServerName() + ":" + request.getServerPort()
+ path + "/";
%>
HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
">
综合图表 -- 大底围红(一)期号 | 红球 | 蓝球 | 围红 | 验证 | |||||||||||||||||||||||||||||||||||||
一 | 二 | 三 | 四 | 五 | 六 | 01 | 02 | 03 | 04 | 05 | 06 | 07 | 08 | 09 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | |||
${a.issue } | ${a.order_red_one } | ${a.order_red_two } | ${a.order_red_three } | ${a.order_red_four } | ${a.order_red_five } | ${a.order_red_six } | ${a.blue } |
将计算出来的数据显示在页面的指定位置(如下图:01~33下边对应的位置)