📄 printresult.jsp
字号:
<%@ page contentType="application/msword;charset=GBK" %><%@ page import="java.sql.*" %><%@page import = "java.text.*"%><%@page import = "java.util.Date"%><%@page import = "myTools.search.*"%><html xmlns:o="urn:schemas-microsoft-com:office:office"xmlns:w="urn:schemas-microsoft-com:office:word"xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=GB2312"><meta name=ProgId content=Word.Document><meta name=Generator content="Microsoft Word 9"><meta name=Originator content="Microsoft Word 9"><link rel=File-List href="./用户名单报表.files/filelist.xml"><title>search result</title><!--[if gte mso 9]><xml> <o:DocumentProperties> <o:Author>dzy</o:Author> <o:LastAuthor>dzy</o:LastAuthor> <o:Revision>2</o:Revision> <o:TotalTime>4</o:TotalTime> <o:Created>2006-09-04T15:28:00Z</o:Created> <o:LastSaved>2006-09-04T15:28:00Z</o:LastSaved> <o:Pages>1</o:Pages> <o:Company>cccb</o:Company> <o:Lines>1</o:Lines> <o:Paragraphs>1</o:Paragraphs> <o:Version>9.2812</o:Version> </o:DocumentProperties></xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:PunctuationKerning/> <w:DrawingGridVerticalSpacing>7.8 磅</w:DrawingGridVerticalSpacing> <w:DisplayHorizontalDrawingGridEvery>0</w:DisplayHorizontalDrawingGridEvery> <w:DisplayVerticalDrawingGridEvery>2</w:DisplayVerticalDrawingGridEvery> <w:Compatibility> <w:SpaceForUL/> <w:BalanceSingleByteDoubleByteWidth/> <w:DoNotLeaveBackslashAlone/> <w:ULTrailSpace/> <w:DoNotExpandShiftReturn/> <w:AdjustLineHeightInTable/> <w:UseFELayout/> </w:Compatibility> </w:WordDocument></xml><![endif]--><style><!-- /* Font Definitions */@font-face {font-family:宋体; panose-1:2 1 6 0 3 1 1 1 1 1; mso-font-alt:SimSun; mso-font-charset:134; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:3 135135232 16 0 262145 0;}@font-face {font-family:"\@宋体"; panose-1:2 1 6 0 3 1 1 1 1 1; mso-font-charset:134; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:3 135135232 16 0 262145 0;} /* Style Definitions */p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; text-align:justify; text-justify:inter-ideograph; mso-pagination:none; font-size:10.5pt; mso-bidi-font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:宋体; mso-font-kerning:1.0pt;} /* Page Definitions */@page {mso-page-border-surround-header:no; mso-page-border-surround-footer:no;}@page Section1 {size:595.3pt 841.9pt; margin:72.0pt 90.0pt 72.0pt 90.0pt; mso-header-margin:42.55pt; mso-footer-margin:49.6pt; mso-paper-source:0; layout-grid:15.6pt;}div.Section1 {page:Section1;}--></style></head><body lang=ZH-CN style='tab-interval:21.0pt;text-justify-trim:punctuation'><div class=Section1 style='layout-grid:15.6pt'><p class=MsoNormal align=center style='text-align:center'><b><spanstyle='font-size:16.0pt;mso-bidi-font-size:12.0pt;font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:"Times New Roman"'>搜索结果</span></b><b><spanlang=EN-US style='font-size:16.0pt;mso-bidi-font-size:12.0pt'><o:p></o:p></span></b></p><table border=1 cellspacing=0 cellpadding=0 style='border-collapse:collapse; border:none;mso-border-alt:solid windowtext .5pt;mso-padding-alt:0cm 5.4pt 0cm 5.4pt'> <tr> <td width=71 valign=top style='width:53.25pt;border:solid windowtext .5pt; background:lime;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt;mso-bidi-font-size:12.0pt; font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family: "Times New Roman"'>用户</span><span lang=EN-US style='font-size:9.0pt; mso-bidi-font-size:12.0pt'>ID</span><span style='font-size:9.0pt;mso-bidi-font-size: 12.0pt;font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family: "Times New Roman"'>号</span><span lang=EN-US style='font-size:9.0pt; mso-bidi-font-size:12.0pt'><o:p></o:p></span></p> </td> <td width=92 valign=top style='width:69.15pt;border:solid windowtext .5pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;background:lime; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt;mso-bidi-font-size:12.0pt; font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family: "Times New Roman"'>用户名</span><span lang=EN-US style='font-size:9.0pt; mso-bidi-font-size:12.0pt'><o:p></o:p></span></p> </td> <td width=96 valign=top style='width:72.0pt;border:solid windowtext .5pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;background:lime; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt;mso-bidi-font-size:12.0pt; font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family: "Times New Roman"'>用户真实姓名</span><span lang=EN-US style='font-size:9.0pt; mso-bidi-font-size:12.0pt'><o:p></o:p></span></p> </td> <td width=48 valign=top style='width:36.0pt;border:solid windowtext .5pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;background:lime; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt;mso-bidi-font-size:12.0pt; font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family: "Times New Roman"'>年龄</span><span lang=EN-US style='font-size:9.0pt; mso-bidi-font-size:12.0pt'><o:p></o:p></span></p> </td> <td width=48 valign=top style='width:35.85pt;border:solid windowtext .5pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;background:lime; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt;mso-bidi-font-size:12.0pt; font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family: "Times New Roman"'>性别</span><span lang=EN-US style='font-size:9.0pt; mso-bidi-font-size:12.0pt'><o:p></o:p></span></p> </td> <td width=71 valign=top style='width:53.25pt;border:solid windowtext .5pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;background:lime; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt;mso-bidi-font-size:12.0pt; font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family: "Times New Roman"'>省份</span><span lang=EN-US style='font-size:9.0pt; mso-bidi-font-size:12.0pt'><o:p></o:p></span></p> </td> <td width=71 valign=top style='width:53.3pt;border:solid windowtext .5pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;background:lime; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt;mso-bidi-font-size:12.0pt; font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family: "Times New Roman"'>城市</span><span lang=EN-US style='font-size:9.0pt; mso-bidi-font-size:12.0pt'><o:p></o:p></span></p> </td> <td width=71 valign=top style='width:53.3pt;border:solid windowtext .5pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;background:lime; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt;mso-bidi-font-size:12.0pt; font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family: "Times New Roman"'>婚姻状况</span><span lang=EN-US style='font-size:9.0pt; mso-bidi-font-size:12.0pt'><o:p></o:p></span></p> </td> </tr> <% String sex = (String)session.getAttribute("sex"); String age_from = (String)session.getAttribute("age_from"); String age_to = (String)session.getAttribute("age_to"); String constellation = (String)session.getAttribute("constellation"); String marry = (String)session.getAttribute("marry"); String blood = (String)session.getAttribute("blood"); String education = (String)session.getAttribute("education"); String province = (String)session.getAttribute("province"); String city = (String)session.getAttribute("city"); //get system time to canclute the age SimpleDateFormat df = new SimpleDateFormat("yyyy");//set the form of the date, in this case only set year String date = df.format(new Date()); int year = Integer.parseInt(date); SearchDB db = new SearchDB(); ResultSet rs = null; try { rs = db.search(year, sex, age_from, age_to, constellation, marry, blood, education, province, city); } catch(SQLException e) { e.printStackTrace(); } while(rs.next()){%> <tr> <td width=71 valign=top style='width:53.25pt;border:solid windowtext .5pt; border-top:none;mso-border-top-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><![if !supportEmptyParas]> <![endif]><span lang=EN-US style='font-size:9.0pt;mso-bidi-font-size:12.0pt'><o:p> <%=rs.getString("users.user_id")%> </o:p></span></p> </td> <td width=92 valign=top style='width:69.15pt;border-top:none;border-left: none;border-bottom:solid windowtext .5pt;border-right:solid windowtext .5pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><![if !supportEmptyParas]> <![endif]><span lang=EN-US style='font-size:9.0pt;mso-bidi-font-size:12.0pt'><o:p> <%=rs.getString("user_name")%> </o:p></span></p> </td> <td width=96 valign=top style='width:72.0pt;border-top:none;border-left:none; border-bottom:solid windowtext .5pt;border-right:solid windowtext .5pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><![if !supportEmptyParas]> <![endif]><span lang=EN-US style='font-size:9.0pt;mso-bidi-font-size:12.0pt'><o:p> <%=rs.getString("realname")%> </o:p></span></p> </td> <td width=48 valign=top style='width:36.0pt;border-top:none;border-left:none; border-bottom:solid windowtext .5pt;border-right:solid windowtext .5pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><![if !supportEmptyParas]> <![endif]><span lang=EN-US style='font-size:9.0pt;mso-bidi-font-size:12.0pt'><o:p> <%=(year - rs.getInt("user_age"))%> </o:p></span></p> </td> <td width=48 valign=top style='width:35.85pt;border-top:none;border-left: none;border-bottom:solid windowtext .5pt;border-right:solid windowtext .5pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><![if !supportEmptyParas]> <![endif]><span lang=EN-US style='font-size:9.0pt;mso-bidi-font-size:12.0pt'><o:p> <%=(rs.getInt("sex") == 1 ? "男" : "女")%> </o:p></span></p> </td> <td width=71 valign=top style='width:53.25pt;border-top:none;border-left: none;border-bottom:solid windowtext .5pt;border-right:solid windowtext .5pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><![if !supportEmptyParas]> <![endif]><span lang=EN-US style='font-size:9.0pt;mso-bidi-font-size:12.0pt'><o:p> <%=rs.getString("province")%> </o:p></span></p> </td> <td width=71 valign=top style='width:53.3pt;border-top:none;border-left:none; border-bottom:solid windowtext .5pt;border-right:solid windowtext .5pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><![if !supportEmptyParas]> <![endif]><span lang=EN-US style='font-size:9.0pt;mso-bidi-font-size:12.0pt'><o:p> <%=rs.getString("city")%> </o:p></span></p> </td> <td width=71 valign=top style='width:53.3pt;border-top:none;border-left:none; border-bottom:solid windowtext .5pt;border-right:solid windowtext .5pt; mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><![if !supportEmptyParas]> <![endif]><span lang=EN-US style='font-size:9.0pt;mso-bidi-font-size:12.0pt'><o:p> <%=rs.getString("marriage")%> </o:p></span></p> </td> </tr> <% } out.print("</Table>"); %></table><p class=MsoNormal><span lang=EN-US><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></p></div></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -