资源预览内容
第1页 / 共48页
第2页 / 共48页
第3页 / 共48页
第4页 / 共48页
第5页 / 共48页
第6页 / 共48页
第7页 / 共48页
第8页 / 共48页
第9页 / 共48页
第10页 / 共48页
亲,该文档总共48页,到这儿已超出免费预览范围,如果喜欢就下载吧!
资源描述
. . . . .学生管理信息系统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类的HelloWorld测试类。代码如下: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;/* * 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(HttpServletRequest 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.println(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,用于存放数据库。将数据库Student脚本文件复制粘贴到/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.servlet.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 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 request, 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) 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 Class.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.println(编号姓名年龄);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 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
收藏 下载该资源
网站客服QQ:2055934822
金锄头文库版权所有
经营许可证:蜀ICP备13022795号 | 川公网安备 51140202000112号