import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
public class SelectServlet extends HttpServlet
{
public void doPost(HttpServletRequest request,HttpServletResponse response)
throws ServletException,IOException
{
response.setContentType("text/html;charset=gbk");
PrintWriter out=response.getWriter();
String name=new String(request.getParameter("txtname").getBytes("iso-8859-1"),"gb2312");
String sql="select * from stuinfo where stuname='"+name+"'";
DBOption dd=new DBOption();
try
{
ResultSet rs=dd.selectName(sql);
if(rs!=null)
{
out.print("<br>");
out.print("<br>");
out.print("<br>");
out.print("<br>");
out.print("<html><head><title>查询详细信息</title></head><body background=\"image/12086-179.jpg\">");
out.print("<table width=\"243\" border=\"0\" align=\"center\">");
out.print("<tr>");
out.print("<th scope=\"col\">学号</th>");
out.print("<th scope=\"col\">性别</th>");
out.print("<th scope=\"col\">学历</th>");
out.print("<th scope=\"col\">爱好</th>");
out.print("<th scope=\"col\">地址</th>");
out.print("</tr>");
while(rs.next())
{
out.print("<tr>");
out.print("<td>"+rs.getString("stuno")+"</td>");
out.print("<td>"+rs.getString("stusex")+"</td>");
out.print("<td>"+rs.getString("stuxueli")+"</td>");
out.print("<td>"+rs.getString("stulikes")+"</td>");
out.print("<td>"+rs.getString("stuAddress")+"</td>");
out.print("</tr>");
}
out.print("</table></body></html>");
}
else
{
out.println("没有您要的结果！");
}
}catch(Exception ee)
{
System.out.println (ee.toString());
}
}
}
学员管理系统1.0HTML版本
需积分: 9 58 浏览量
2008-11-19
13:43:13
上传
评论
收藏 3.99MB RAR 举报
StudentManager.rar （40个子文件） 
StudentManager 
success.html 636B error.html 709B main.html 862B image 
061.jpg 280KB 065.jpg 66KB a547418.jpg 36KB 240_0msuejis.jpg 142KB
a293116.bmp 2.87MB a295435.jpg 71KB a200692519010.jpg 76KB a262938.jpg 52KB
Thumbs.db 57KB
1171514584697.gif 473KB a393157.gif 1.18MB a196397.jpg 92KB 2006926123451%20(8).gif 45KB 12086-179.jpg 114KB add.html 2KB WEB-INF web.xml 1KB classes AddServlet.java 2KB AddServlet.class 2KB SelectServlet.class 2KB LoginServlet.class 1KB UpdateServlet.java 2KB UpdateServlet.class 2KB DBOption.class 2KB DeleteServlet.class 1KB LoginServlet.java 706B DBOption.java 1KB SelectServlet.java 2KB DeleteServlet.java 702B lib 
mssqlserver.jar 63KB msbase.jar 278KB msutil.jar 66KB index.html 1KB information.html 856B select.html 943B update.html 2KB 数据库文件.sql 506B delete.html 2KB
评论0
最新资源