servlet实验报告
- 格式：docx
- 大小：61.61 KB
- 文档页数：7
Servlet上机实验报告 班级：软 件 1 班 学号：********** 姓名：张 * 时间：2015. 3.30 Servlet上机实验报告
1 一、实验目的 1.掌握Servlet来访问数据库。 2.了解servlet工作的流程，servlet的作用。 3.掌握servlet的方法init()，destory(),doGet(),doPost();
二、实验环境 Windows8.1 + Eclipse + MySQL数据库 三、实验步骤 1.创建一个动态网页的项目，名字为：Employeer,创建包com.employee,在包下新建Servlet,名为ShowEmployeeList.java,里面代码实现和MySQL数据库的连接，并将数据库的内容以表格的形式显示到页面。并将用于连接数据库的驱动jar包添加到JavaPath中。 2.配置web.Xml,匹配访问页面的URL。 3.创建数据库Employee,在里面新建表emp,并在表中添加字段ename(雇员姓名)，job（职位），sal（工资），hiredate（入职时间），并插入若干条数据。添加的额数据如下:
四、源代码 1.Employeer.java Servlet上机实验报告 2 package com.employee; import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import javax.servlet.ServletConfig; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse;
public class ShowEmployeeList extends HttpServlet { private static final long serialVersionUID = 1L; private Connection cn = null; @Override public void init(ServletConfig config) throws ServletException { super.init(); String driver = config.getInitParameter("driver"); String url = config.getInitParameter("url"); String user = config.getInitParameter("user"); String password = config.getInitParameter("password"); try { Class.forName(driver); cn = DriverManager.getConnection(url, user, password); } catch (Exception e) { System.out.println("Init error:" + e.getMessage()); } }
public void destroy() { super.destroy(); try { if (cn != null && (!cn.isClosed())) { cn.close(); cn = null; } } catch (Exception e) { System.out.println("Destroy Error:" + e.getMessage()); } } Servlet上机实验报告 3 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html"); response.setCharacterEncoding("GBK"); PrintWriter out = response.getWriter(); out.print(""); out.println(" A Servlet"); out.print(" "); try { String sql = "select ename,job,sal,hiredate from emp"; PreparedStatement ps = cn.prepareStatement(sql); ResultSet rs = ps.executeQuery(); out.print("员工列表"); out.print(""); out.print(""); out.print("姓名职位工资加入公司日期"); out.print("");
while (rs.next()) { out.print(""); out.println("" + rs.getString("ENAME") + ""); out.println("" + rs.getString("JOB") + ""); out.println("" + rs.getDouble("SAL") + ""); out.println("" + rs.getString("HIREDATE") + ""); out.print(""); } rs.close(); ps.close(); out.print(""); } catch (Exception e) { out.println("
2.web.xml PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN" "http://java.sun.com/dtd/web-app_2_3.dtd"> ShowEmployeeList com.employee.ShowEmployeeList driver com.mysql.jdbc.Driver url jdbc:mysql://localhost:3306/employee user root password 930515 ShowEmployeeList /ShowEmployeeList
3.执行效果
