发布时间 : 2024/5/16 12:19:12 星期四 文章javaEE实验二 Servlet与JDBC数据库连接201210405214 杨茜婷更新完毕开始阅读3291db4d5901020207409cc7

7.更改程序代码，使程序可以输出更多的信息，比如员工的state、streetName、streetNumber、zipCode、country等信息。

更改后的程序代码为:

accept-language: ${header['accept-language']}

session id: ${pageContext.session.id}

employee: ${requestScope.employee.name}, ${employee.address.state}

capital: ${capitals[\

state: ${employee.address.city}

streetName:${employee.address.streetName}

streetNumber:${employee.address.streetNumber}

zipCode:${employee.address.zipCode}

country:${employee.address.country}

更改程序后的输出结果为:

-9-

-10-

程序源代码: Servlet工程: 1.Register.jsp:

<%@ page language=\

2. RegisterProcessAction.java: package javaee.ch04; import java.io.IOException; import java.io.PrintWriter; import java.text.NumberFormat; import java.util.ArrayList; import java.util.List; import java.util.Locale; import java.sql.*;

import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession;

@WebServlet(name = \ \initParams={ } ) //用户注册处理Servlet

//数据库： cityoa 数据表： userinfo1(USERID,PASSWORD,NAME)

-11-

public class RegisterProcessAction extends HttpServlet {

//定义数据库连接对象 private Connection cn=null;

private String driverName=null;//数据库驱动器 private String url=null;//数据库地址URL private String user=null; private String password=null; //初始化方法，取得数据库连接对象

public void init() throws ServletException { }

//处理GET请求方法

public void doGet(HttpServletRequest request, HttpServletResponse response) {

//取得用户注册表单提交的数据

String userid=request.getParameter(\String password=request.getParameter(\String repassword=request.getParameter(\String name=request.getParameter(\//判断登录帐号为空,则自动跳转到注册页面 if(userid==null||userid.trim().length()==0) { }

//如果登录密码为空，自动跳转到注册页面

if(password==null||password.trim().length()==0) { }

//如果确认登录密码为空，自动跳转到注册页面

-12-

response.sendRedirect(\response.sendRedirect(\

throws ServletException, IOException

driverName=%url=\ user=\password=\try { }

catch(Exception e) { }

System.out.println(\取得数据库连接错误:\Class.forName(driverName);

cn=DriverManager.getConnection(url,user,password);