申彦栋Servlet实现增删改查功能 - +jsp登录页面(4)

学生性别：

>男

>女

学生年龄：

value=\<%=request.getAttribute(\) %>\ >

返回主页面

查询页面Search.jsp

<%@ page language=\ import=\ pageEncoding=\%> <%@page import=\%> <%@page import=\%>

<%@page import=\%> <%

String path = request.getContextPath(); String basePath =

request.getScheme()+\+request.getServerName()+\+request.getServerPort()+path+\; %>

第 15 页 共 29 页

出错页面Error.jsp

第 16 页 共 29 页

<%@ page language=\ import=\ pageEncoding=\%> <%

String path = request.getContextPath(); String basePath =

request.getScheme()+\+request.getServerName()+\+request.getServerPort()+path+\; %>

对不起！您<%=request.getAttribute(\) %>失败

C层：控制层—Servlet

1.显示记录集的Servlet----SearchById.java

package MVC;

import java.io.IOException;

import javax.servlet.ServletException; import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import MVC.JavaBean; import MVC.SqlBean;

public class SearchById extends HttpServlet {

}

doPost(request,response);

private static final long serialVersionUID = 1L; public void doDelete(HttpServletRequest request, }

public void doGet(HttpServletRequest request, HttpServletResponse

throws ServletException, IOException {

HttpServletResponse response) throws ServletException,

IOException {

// Put your code here

response)

第 17 页 共 29 页

}

public void doPost(HttpServletRequest request, HttpServletResponse }

throws ServletException, IOException {

response)

response.setContentType(\); request.setCharacterEncoding(\); response.setCharacterEncoding(\); //获取用户ID

String sid = request.getParameter(\); int id =Integer.parseInt(sid);

String sql =\; SqlBean sBean = new SqlBean();

JavaBean jBean = sBean.getSearchById(sql, id); //用户ID

request.setAttribute(\,jBean.getId()); //用户姓名

request.setAttribute(\,jBean.getName());

//用户密码

request.setAttribute(\,jBean.getPassword()); //用户性别

String sex=\; String man=\; String woman=\;

if(jBean.getSex()!=null) { }

request.setAttribute(\,man); request.setAttribute(\,woman);

//用户年龄

request.setAttribute(\,jBean.getAge());

//转发

request.getRequestDispatcher(\).forward(request,

sex=jBean.getSex().trim(); if(sex.equals(\男\)) { } else { }

woman =\; man =\;

response);

第 18 页 共 29 页

2.增加记录的Servlet----Insert.java

package MVC;

import java.io.IOException;

import javax.servlet.ServletException; import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import MVC.SqlBean; import MVC.JavaBean;

public class Inserts extends HttpServlet {

response.setContentType(\); request.setCharacterEncoding(\); response.setCharacterEncoding(\); //获取前台页面数据

String name =request.getParameter(\);

String password =request.getParameter(\); String sex =request.getParameter(\); String sage = request.getParameter(\); int age =Integer.parseInt(sage);

//封装到JavaBean对象中去

JavaBean jBean = new JavaBean(); jBean.setName(name); }

public void doPost(HttpServletRequest request, HttpServletResponse

throws ServletException, IOException { response.setContentType(\); doPost(request,response); /** * */

private static final long serialVersionUID = 1L; public void doDelete(HttpServletRequest request, }

public void doGet(HttpServletRequest request, HttpServletResponse

throws ServletException, IOException {

HttpServletResponse response) throws ServletException,

IOException {

// Put your code here

response)

response)

第 19 页 共 29 页