自己建立了一个数据库来实现这个功能,一个记录学生信息的数据库包含的信息为(Sno,Sname,Ssex,Sage,Sdept)
实现查询功能并输出。
代码分为4部分
1.Student.java
package com.lyq.bean;
public class Student {
// 学号
private String Sno;
// 学生名称
private String Sname;
// 性别
private String Ssex;
// 年龄
private int Sage;
// 专业
private String Sdept;
public String getSno() {
return Sno;
}
public void setSno(String sno) {
this.Sno = sno;
}
public String getSname() {
return Sname;
}
public void setSname(String sname) {
this.Sname = sname;
}
public String getSsex() {
return Ssex;
}
public void setSsex(String ssex) {
this.Ssex = ssex;
}
public int getSage() {
return Sage;
}
public void setSage(int sage) {
this.Sage = sage;
}
public String getSdept() {
return Sdept;
}
public void setSdept(String sdept) {
this.Sdept = sdept;
}
}
2.FindServlet.java
package com.lyq.bean;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class FindServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
try {
// 加载数据库驱动,注册到驱动管理器
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
// 数据库连接字符串
String url = "jdbc:sqlserver://localhost:1433; DatabaseName=lzy";
// 数据库用户名
String username = "sa";
// 数据库密码
String password = "jiayou417";
// 创建Connection连接
Connection conn = DriverManager.getConnection(url,username,password);
// 获取Statement
Statement stmt = conn.createStatement();
// 添加图书信息的SQL语句
String sql = "select * from Student";
// 执行查询
ResultSet rs = stmt.executeQuery(sql);
// 实例化List对象
List<Student> list = new ArrayList<Student>();
// 判断光标向后移动,并判断是否有效
while(rs.next()){
// 实例化Student对象
Student student = new Student();
// 对Sno属性赋值
student.setSno(rs.getString("Sno"));
// 对Sname属性赋值
student.setSname(rs.getString("Sname"));
// 对Ssex属性赋值
student.setSsex(rs.getString("Ssex"));
// 对Sage属性赋值
student.setSage(rs.getInt("Sage"));
// 对Sdept属性赋值
student.setSdept(rs.getString("Sdept"));
// 将学生对象添加到集合中
list.add(student);
}
// 将学生集合放置到request之中
request.setAttribute("list", list);
rs.close(); // 关闭ResultSet
stmt.close(); // 关闭Statement
conn.close(); // 关闭Connection
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
// 请求转发到student_list.jsp
request.getRequestDispatcher("student_list.jsp").forward(request, response);
}
}
3.student_list.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@page import="java.util.List"%>
<%@page import="com.lyq.bean.Student"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>所有学生信息</title>
<style type="text/css">
td{font-size: 12px;}
h2{margin: 0px}
</style>
</head>
<body>
<table align="center" width="450" border="1" height="180" bordercolor="white" bgcolor="black" cellpadding="1" cellspacing="1">
<tr bgcolor="white">
<td align="center" colspan="5">
<h2>所有学生信息</h2>
</td>
</tr>
<tr align="center" bgcolor="#e1ffc1" >
<td><b>学号</b></td>
<td><b>姓名</b></td>
<td><b>性别</b></td>
<td><b>年龄</b></td>
<td><b>专业</b></td>
</tr>
<%
// 获取学生信息集合
List<Student> list = (List<Student>)request.getAttribute("list");
// 判断集合是否有效
if(list == null || list.size() < 1){
out.print("没有数据!");
}else{
// 遍历学生集合中的数据
for(Student student : list){
%>
<tr align="center" bgcolor="white">
<td><%=student.getSno()%></td>
<td><%=student.getSname()%></td>
<td><%=student.getSsex()%></td>
<td><%=student.getSage()%></td>
<td><%=student.getSdept()%></td>
</tr>
<%
}
}
%>
</table>
</body>
</html>
4.index.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>查看所有学生信息</title>
</head>
<body>
<a href="FindServlet">查看所有学生信息</a>
</body>
</html>
运行截图如下: