package com.servlet;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
import com.entity.Student;
public class StudentListServlet extends HttpServlet {
public void doGet(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException{
try{
List<Student> students = queryStudents(); //利用这个方法从数据库里得到学生信息的列表
showStudents(response,students); //把有学生信息的列表传到这个方法里来显示到页面
}catch(Exception e){
e.printStackTrace();
}
}
public void showStudents(HttpServletResponse response,
List<Student> students) throws ServletException, IOException {
response.setContentType("text/html;charset=gbk");
PrintWriter out = response.getWriter();
out.println("<html>");
out.println("<head>");
out.println("<title>学生列表</title>");
out.println("</head>");
out.println("<body>");
out.println("<h3 align=\"center\">学生列表</h3>");
out.println("<hr>");
out.println("<table align=\"center\" width=\"500\" border=\"1\">");
out.println("<tr>");
out.println("<td>ID</td>");
out.println("<td>用户名</td>");
out.println("<td>姓名</td>");
out.println("</tr>");
Iterator<Student> iter = students.iterator(); //传的时候传进来的是已经有了zzm_student表里内容的集合
System.out.println(iter);
while(iter.hasNext()){
Student student = iter.next();//把集合里的内容放到student类里,然有用这个循环一条一条的显示到页面,集合里装的是已经set好的Student数据
out.println("<tr>");
out.println("<td align=\"center\">"+student.getId()+"</td>"); //刚才queryStudents()这个方法已经把Student类的属性赋值了,所以这里直接get就行
out.println("<td align=\"center\">"+student.getUsername()+"</td>");
out.println("<td align=\"center\">"+student.getName()+"</td>");
out.println("</tr>");
}
out.println("</table>");
out.println("</body>");
out.println("</html>");
out.close();
}
public List<Student> queryStudents() throws Exception{
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
List<Student> students = new ArrayList<Student>();
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.126:1521:9i", "openlab", "open123");
stmt = con.createStatement();
String sql = "select id,uname,pwd,name from zzm_student";
rs = stmt.executeQuery(sql);
while(rs.next()){ //这里已经把数据set到Student类里对应起来了
Student student = new Student();
student.setId(rs.getInt(1));
student.setUsername(rs.getString(2));
student.setPassword(rs.getString(3));
student.setName(rs.getString(4));
students.add(student);
}
}catch(Exception e){
e.printStackTrace();
}finally{
close(rs,stmt,con);
}
return students;
}
public void close(ResultSet rs,Statement stmt,Connection con){
try{
rs.close();
}catch(Exception ee){
ee.printStackTrace();
}
try{
stmt.close();
}catch(Exception e){
e.printStackTrace();
}
try{
con.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
java&JDBC&hibernate&WEB等程序的一些小列子
需积分: 3 179 浏览量
2008-11-11
08:32:46
上传
评论
收藏 4.45MB ZIP 举报
java&JDBC&hibernate&WEB等程序的一些小列子 （413个子文件） 
StudentListServlet.class 5KB StudentListServlet.class 3KB JdbcUtil.class 3KB StudentListServlet.class 3KB TestRes.class 3KB showServlet.class 3KB User.class 2KB StudentBiz.class 2KB Lab8.class 2KB LoginAction.class 2KB TestPs.class 2KB LifeCycleServlet.class 2KB SessionCounterServlet.class 2KB User.class 2KB Test3_1.class 2KB Test2.class 2KB Account.class 2KB IPLogServlet.class 2KB Account.class 2KB ConnectionFactory.class 2KB Test2.class 2KB TestStmt.class 2KB Account.class 2KB StudentBiz.class 2KB Test3.class 2KB Test1.class 2KB RegisterServlet.class 2KB ConnectionFactory.class 2KB ShowCookieServlet.class 2KB UpperCaseFilter.class 2KB CounterServlet.class 2KB TestRSMetaData.class 2KB Test1.class 2KB SetCookieServlet.class 2KB Address.class 2KB TestJdbc.class 2KB JdbcUtil.class 1KB JdbcUtil.class 1KB Test1.class 1KB TestAccount.class 1KB ServerTime.class 1KB Student.class 1KB Student.class 1KB Student.class 1KB MyServlet.class 1KB serverTime.class 1KB User.class 1KB ContextLoginModel.class 999B HbnUtil.class 947B HbnUtil.class 929B HbnUtil.class 929B CharResponseWrapper.class 836B MemoryLoginModel.class 804B TestA.class 538B Counter.class 518B AbstractLoginModel.class 483B BeanFactory.class 413B TestA.class 364B TestA.class 363B TestB.class 276B TestB.class 268B TestB.class 268B LoginModel.class 225B css.css 12B
denglu.html 2KB javascript6.html 1008B href.html 942B javascript3.html 504B javascript4.html 418B javascript5.html 350B javascript.html 337B javascript1.html 319B lie_biao.html 298B css.html 268B javascript2.html 249B css1.html 227B my.html 177B
standard.jar 343KB standard.jar 343KB standard.jar 343KB standard.jar 343KB standard.jar 343KB standard.jar 343KB standard.jar 343KB standard.jar 343KB standard.jar 343KB standard.jar 343KB standard.jar 343KB standard.jar 343KB standard.jar 343KB jstl.jar 17KB jstl.jar 17KB jstl.jar 17KB jstl.jar 17KB jstl.jar 17KB jstl.jar 17KB jstl.jar 17KB jstl.jar 17KB jstl.jar 17KB jstl.jar 17KB共 413 条
- 1
- 2
- 3
- 4
- 5
资源评论
