如果哪位有心人能帮我写好了,麻烦发到用附件 主题:你要的JSP东东
解决方案 »
- jsp 的 request对象是如何定义的?
- SQL语句你行不?(至于你行不行我不知道,但我是不行)
- 关于freemarker中取值的问题!
- 局域网访问导致Tomcat自动关闭
- struts2 request问题!
- 400和404错误差别在哪里?
- 谁能介绍下用JCreator开发WEB程序的具体配置
- 小弟有个简单的问题想问一下,这个栏目是Java JSP/Servlet/JavaBean ,那什么是JavaBean?
- resin中的helloworld问题
- 麻煩大家請教大家一個 查詢數據並顯示出來的問題
- 只有部分java理论基础,没有实际项目经验,用java做Web开发(jsp+servlet+javabean)多长时间能成为熟手?
- 专门给分!
---------------------汗ing,,,看来楼主赖上我了,,,
写完给你发邮件,,,,,
运行效果见我的blog
http://91in.blogchina.com/2742588.html
<%@ page contentType="text/html; charset=GB18030" %>
<%@ page import="java.sql.*"%>
<html><head><title>testConn</title></head>
<body bgcolor="#ffffff"><h1>test</h1>
<form name="form1" method="get" action="">
<p>
<label>组别:</label>
<label>
<input type="radio" name="group" value="0" checked>
null</label>
<label>
<input type="radio" name="group" value="1" >
一组</label>
<label>
<input type="radio" name="group" value="2">
二组</label>
<label>
<input type="radio" name="group" value="3">
三组</label>
<label>
<input type="radio" name="group" value="4">
四组</label>
<label></label>
</p>
<p>
<label>年龄:</label>
<select name="age">
<option value="0">请选择</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
</select>
</p>
<p>
<label>性别:</label>
<label><input type="radio" name="sex" value="0" checked>
男性</label>
<label>
<input type="radio" name="sex" value="1">
女性</label>
</p>
<p>
<input type="submit" name="formAction" value="Addata">
<input type="submit" name="formAction" value="Search">
<input type="submit" name="formAction" value="Listall">
</p>
</form>
<hr color="#FF0000">
<jsp:useBean id="connId" scope="page" class="test.Conn" />
<jsp:setProperty name="connId" property="*" />
<%
String reAge = null;
String reMygroup = null;
String reSex = null;
String formAction = null;
String sql= null;
String sql1 = null;
int n = 0;
int i = 0;
reAge = request.getParameter("age");
reSex = request.getParameter("sex");
reMygroup = request.getParameter("group");
formAction = request.getParameter("formAction");
if(formAction==null || formAction.equals("Search"))
{
if(reMygroup==null&&reAge==null){
sql = "select * from csdntest where sex="+0;
sql1 = "select * from csdntest where sex="+1;
}
else{
if(!reMygroup.equals("0")&&!reAge.equals("0"))
{
sql = "select * from csdntest where mygroup="+reMygroup+" and age="+reAge+" and sex="+0;
sql1 = "select * from csdntest where mygroup="+reMygroup+" and age="+reAge+" and sex="+1;
}
else if(reMygroup.equals("0")&&!reAge.equals("0")){
sql = "select * from csdntest where age="+reAge+" and sex="+0;
sql1 = "select * from csdntest where age="+reAge+" and sex="+1;
}
else if(!reMygroup.equals("0")&&reAge.equals("0")){
sql = "select * from csdntest where mygroup="+reMygroup+" and sex="+0;
sql1 = "select * from csdntest where mygroup="+reMygroup+" and sex="+1;
}
else if(reMygroup.equals("0")&&reAge.equals("0")){
sql = "select * from csdntest where sex="+0;
sql1 = "select * from csdntest where sex="+1;
}
}
ResultSet RSdata = connId.executeQuery(sql);
while(RSdata.next()){
n = n+1;
}
RSdata.close();
out.print("<br>共有男生"+n+"人!");
ResultSet RSdata1 = connId.executeQuery(sql1);
while(RSdata1.next()){
i = i+1;
}
RSdata1.close();
out.print("<br>共有女生"+i+"人!");
}
else if(formAction.equals("Addata")){
try{
sql = "INSERT INTO csdntest(age,sex,mygroup)";
sql = sql+" VALUES('"+reAge+"','"+reSex+"','"+reMygroup+"')";
connId.executeQuery(sql);
}
catch(Exception ey){
ey.printStackTrace();
}
response.sendRedirect("test.jsp");
}
else if(formAction.equals("Listall")){
out.print("<table><tr><td><br>id</td><td><br>年龄</td><td><br>性别</td><td><br>组别</td></tr>");
String sexinfo = null;
sql="select * from csdntest order by id desc";
ResultSet RSdata2 = connId.executeQuery(sql);
while(RSdata2.next()){
n = n+1;
out.print("<tr><td>"+RSdata2.getString(1));
out.print("</td><td>"+RSdata2.getString(2)+"</td>");
if(RSdata2.getString(3).equals("0")){sexinfo="男";}
else{sexinfo = "女";}
out.print("<td>"+sexinfo+"</td>");
out.print("<td>"+RSdata2.getString(4)+"</td></tr>");
}
RSdata2.close();
out.print("<br>共有"+n+"条记录!");
}
%>
</table>
<hr color="#FF0000">
</body>
</html>