《学生管理信息系统Servlet版(Eclipse)》由会员分享，可在线阅读，更多相关《学生管理信息系统Servlet版(Eclipse)（48页珍藏版）》请在金锄头文库上搜索。
1、. . . . .学生管理信息系统Servlet版（Eclipse）1、 新建Dynamic Web Project，命名StudentServlet 2、 配置项目1）右击项目-Properties-修改Java Builder Path-Browse-在Webcontent下的Web-INF下新建classes文件夹，并选择.2）复制粘贴两个包到/WEB-INF/lib下，如图：3）修改字符集，Properties-Resource-将GBK改为UTF-83、 编写测试类/src下新建包，包名为com.ls.test,在此包下新建Servlet，创建继承与HttpServlet类的Hell
2、oWorld测试类。代码如下：package com.ls.test;import java.io.IOException;import java.io.PrintWriter;import javax.servlet.ServletException;import javax.servlet.annotation.WebServlet;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;/
3、* * Servlet implementation class HelloWorld */WebServlet(/HelloWorld)public class HelloWorld extends HttpServlet private static final long serialVersionUID = 1L; /* * see HttpServlet#HttpServlet() */ public HelloWorld() super(); / TODO Auto-generated constructor stub /* * see HttpServlet#doGet(HttpS
4、ervletRequest request, HttpServletResponse response) */protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException / TODO Auto-generated method stubresponse.setContentType(text/html;charset=UTF8);PrintWriter out= response.getWriter();out.printl
5、n(HelloWorld);/* * see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException / TODO Auto-generated method stub运行测试类，结果如图：4、新建名为DataBase的folder，用于存放数据库。将数据库Stu
6、dent脚本文件复制粘贴到/DataBase下：5、各页面代码：1）、com.ls.test下显示所有记录的测试类DisplayServletpackage com.ls.test;import java.io.IOException;import java.io.PrintWriter;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import javax.serv
7、let.ServletException;import javax.servlet.annotation.WebServlet;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;/* * Servlet implementation class addStudentServlet */WebServlet(/disp)public class DisplayServlet extends
8、HttpServlet private static final long serialVersionUID = 1L; /* * see HttpServlet#HttpServlet() */ public DisplayServlet() super(); / TODO Auto-generated constructor stub /* * see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */protected void doGet(HttpServletRequest re
9、quest, HttpServletResponse response) throws ServletException, IOException / TODO Auto-generated method stubdoPost(request,response);/* * see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */protected void doPost(HttpServletRequest request, HttpServletResponse response)
10、throws ServletException, IOException / TODO Auto-generated method stubresponse.setContentType(text/html;charset=UTF-8);PrintWriter out=response.getWriter();String connStr = jdbc:mysql:/localhost:3306/Student?characterEncoding=utf8;Connection conn = null ;Statement stmt = null ; ResultSet rs;try Clas
11、s.forName(com.mysql.jdbc.Driver);conn = DriverManager.getConnection(connStr,root, 123456);stmt = conn.createStatement(); catch (Exception ex) ex.printStackTrace();System.out.println(exception in getConnection);String sql=select * from studentinfo;try rs = stmt.executeQuery(sql);out.println();out.pri
12、ntln(编号姓名年龄);while (rs.next()out.println(+rs.getString(id)+rs.getString(name)+rs.getInt(age)+);out.println();stmt.close();conn.close(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace(); 2)com.ls.student.bean下的实体类Student.javapackage com.ls.student.bean;public class Student
13、private String id,name;private int age;public Student() super();public Student(String id, String name, int age) super();this.id = id;this.name = name;this.age = age;public String getId() return id;public void setId(String id) this.id = id;public String getName() return name;public void setName(String name) this.name = name;public int getAge() return age;public void setAge(int age) this.age = age;Overridepublic String toString() return St
