javaEE实验二 Servlet与JDBC数据库连接201210405214 杨茜婷

}

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

//如果密码和确认密码不符，自动跳转到注册页面 if(!password.equals(repassword)) { }

//将姓名进行汉字乱码处理

if(name!=null&&name.trim().length()>0) { }

//增加新用户处理

String sql=\try { }

catch(Exception e) { }

System.out.println(\错误:\response.sendRedirect(\PreparedStatement ps=cn.prepareStatement(sql); ps.setString(1, userid); ps.setString(2, password); ps.setString(3, name); ps.executeUpdate(); ps.close();

//处理结束后，跳转到注册成功提示页面 response.sendRedirect(\name=new String(name.getBytes(\response.sendRedirect(\response.sendRedirect(\

//处理POST请求方法

public void doPost(HttpServletRequest request, HttpServletResponse response) { }

//销毁方法

public void destroy() {

super.destroy(); try {

cn.close();

-13-

doGet(request,response);

throws ServletException, IOException

}

}

}

catch(Exception e) { }

System.out.println(\关闭数据库错误:\

3.web.xml:

xmlns=\

xmlns:xsi=\xsi:schemaLocation=\http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd\

index.jsp

ShowEmployeeList

com.city.j2ee.ch02.ShowEmployeeList

driver

com.mysql.jdbc.Driver

url

jdbc:mysql://localhost/student

user root

password root

ShowEmployeeList /showemployeelist

4.ShowEmployeeList.java: package com.city.j2ee.ch02; import java.io.IOException;

-14-

//数据库：student 数据表： stuinfo import java.io.PrintWriter; import java.sql.*;

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 Connection cn=null;

public void init(ServletConfig config) throws ServletException { super.init(config);

String driver=config.getInitParameter(\ String url=config.getInitParameter(\ String user=config.getInitParameter(\ String password=config.getInitParameter(\try

{Class.forName(driver);

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

}

catch (Exception e)

{ System.out.println(\

} }

public void destroy() {super.destroy(); try

{if (cn!=null&&(!cn.isClosed())) {cn.close(); cn=null;}

}

catch (Exception e)

{System.out.println(\

} }

public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {response.setContentType(\response.setCharacterEncoding(\PrintWriter out=response.getWriter(); out.println(\

out.println(\out.println(\out.println(\try

{String sql=\

-15-

PreparedStatement ps=cn.prepareStatement(sql); ResultSet rs=ps.executeQuery(); out.println(\学生信息表\out.println(\out.println(\

out.println(\学号姓名性别省份成市民族\out.println(\while (rs.next()) {out.println(\

out.println(\out.println(\out.println(\out.println(\out.println(\out.println(\out.println(\

} rs.close(); ps.close();

out.println(\}

catch (Exception e)

{out.println(\处理客户端请求发生的错误！\}

out.println(\out.println(\out.println(\out.flush(); out.close();

}

public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doGet(request,response);} }

app04 工程: 1.address.java package app04a.model; public class Address {

private String streetName; private String streetNumber; private String city; private String state; private String zipCode; private String country;

public String getStreetName() {

-16-