近期在老师的引导下我们学习了利用Javaweb技术制作简单的管理系统，其中涉及到的技术很多，由于大多都是自学
对这些技术的理解还太浅显但能实现一些相关功能的雏形。
(一).登录功能
在登陆功能中通过与数据库的连接实现了验证用户账号与密码是否正确的功能，并添加了简易的权限设置使
不同用户登录成功后所呈现的主界面是不同的；同时还有验证码功能能检测验证码是否输入正确。
数据库：
jsp：
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>登录</title> </head>
<body>
<%
Object message = request.getAttribute("message");
if (message != null && !"".equals(message)) {
%>
<script type="text/javascript">
alert("<%=request.getAttribute("message")%>");
</script>
<%
}
%>
<form action="Log" name="log" method="post">
<div align="center">
<h1>请登录</h1>
用户名:<input id ="username" name="username" type="text" value="" onChange="chang1(this.value)">
<br>
密码:<input id ="password" name="password" type="password" value="" onChange="chang2(this.value)">
<br>
验证码：<input type="text" id="inputCode" value="" onChange="validateCode()">
<div id="checkCode" class="code" onclick="createCode(4)" style="display:inline" ></div>
<br>
<input type="submit" value="确定" > </div>
</form>
<script type="text/javascript">
window.onload=function(){
createCode(4);
} //生成验证码的方法
function createCode(length) {
var code = "";
var codeLength = parseInt(length); //验证码的长度
var checkCode = document.getElementById("checkCode");
////所有候选组成验证码的字符，当然也可以用中文的
var codeChars = new Array(0, 1, 2, 3, 4, 5, 6, 7, 8, 9,
'a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z',
'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z');
//循环组成验证码的字符串
for (var i = 0; i < codeLength; i++)
{
//获取随机验证码下标
var charNum = Math.floor(Math.random() * 62);
//组合成指定字符验证码
code += codeChars[charNum];
}
if (checkCode)
{
//为验证码区域添加样式名
checkCode.className = "code";
//将生成验证码赋值到显示区
checkCode.innerHTML = code;
}
} //检查验证码是否正确
function validateCode()
{
//获取显示区生成的验证码
var checkCode = document.getElementById("checkCode").innerHTML;
//获取输入的验证码
var inputCode = document.getElementById("inputCode").value;
//console.log(checkCode);
//console.log(inputCode);
if (inputCode.length <= 0)
{
alert("请输入验证码！");
}
else if (inputCode.toUpperCase() != checkCode.toUpperCase())
{
alert("验证码输入有误！");
createCode(4);
} }
var reg=/^[a-zA-Z]\w*$/;
var flag1=false,flag2=false,flag3=false;
function chang1(obj)
{
var pattern = /^\w+$/i;
var arr = obj.match(pattern);
if(arr)
{}
else
alert("用户名格式不正确，4-10位数字/字母/下划线");
if(obj.length<4||obj.length>10)
{
alert("用户名格式不正确，4-10位数字/字母/下划线"); }
}
function chang2(obj)
{ var pattern = /^\w+$/i;
var arr = obj.match(pattern);
if(arr)
{}
else
alert("密码格式不正确，4-10位数字/字母/下划线");
if(obj.length<4||obj.length>10)
{
alert("密码格式不正确，4-10位数字/字母/下划线"); } } </script>
</body>
</html>
servlet:
package servlet; import java.io.IOException;
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; import dao.UserDao; /**
* Servlet implementation class Login
*/
@WebServlet("/Log")
public class Log extends HttpServlet { /**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
request.setCharacterEncoding("utf-8");
String name=request.getParameter("username");
String password=request.getParameter("password");
UserDao x=new UserDao();
int flag=x.checkUsers(name, password);
if(flag==1){
System.out.println(name+"-"+password);
HttpSession session=request.getSession();
session.setAttribute("name", name);
session.setAttribute("password", password);
response.sendRedirect("main_menu.jsp");
}
else if(flag==-1){
System.out.println("false");
response.sendRedirect("log.jsp");
}
else if(flag==2)
{
System.out.println("false");
response.sendRedirect("create.jsp");
}
} /**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request, response);
} }
Dao层：
package dao;
import bean.Account;
import bean.User;
import util.DButil;
import java.sql.*; import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List; import bean.Account;
import util.DButil; public class UserDao {
DButil DB =new DButil();
private static UserDao userDao =new UserDao(); public static UserDao getUserDao()
{
return userDao; }
/*public boolean checkUser(String username ,String password) {
DButil DB = new DButil();
String sql="select username,password from account where username=? and password=?";
//String sql = "select username,password,jurisdiction from account where username='"+username+"' and password='"+password+"'";
Connection conn = null;
PreparedStatement ps = null;
boolean flag = false;
try {
conn = DB.getConn();
ps = conn.prepareStatement(sql);
ps.setString(1, username);
ps.setString(2, password);
//ps.setInt(3, jurisdiction);
ResultSet rs = ps.executeQuery();
if(rs.next())
{ flag=true;
} } catch (Exception e) { flag=false;
e.printStackTrace();
} finally {
DB.close(conn);
DB.close(ps);
}
return flag;
}*/
public int checkUsers(String username ,String password) {
DButil DB = new DButil();
String sql="select username,password ,jurisdiction from account where username=? and password=?";
//String sql = "select username,password,jurisdiction from account where username='"+username+"' and password='"+password+"'";
Connection conn = null;
PreparedStatement ps = null;
int flag = -1;
try {
conn = DB.getConn();
ps = conn.prepareStatement(sql);
ps.setString(1, username);
ps.setString(2, password);
//ps.setInt(3, jurisdiction);
ResultSet rs = ps.executeQuery();
if(rs.next())
{ flag=rs.getInt("jurisdiction");
} } catch (Exception e) { flag=-1;
e.printStackTrace();
} finally {
DB.close(conn);
DB.close(ps);
}
return flag;
} public boolean addUser(User user) {
DButil DB = new DButil();
String sql = "insert into middle_text(name,sex,nation,time,age,outlook,service) values(?,?,?,?,?,?,?)";
Connection conn = null;
PreparedStatement ps = null;
boolean flag = false;
int a = 0; try {
conn = DB.getConn();
ps = conn.prepareStatement(sql);
ps.setString(1, user.getName());
ps.setString(2, user.getSex());
ps.setString(3, user.getNation());
ps.setString(4, user.getTime());
ps.setString(5, user.getAge());
ps.setString(6, user.getOutlook());
ps.setString(7, user.getService());
a = ps.executeUpdate(); if (a != 0) {
flag = true;
}
} catch (Exception e) {
System.out.println( "添加失败");
flag=false;
e.printStackTrace();
} finally {
DB.close(conn);
DB.close(ps);
}
return flag;
} public boolean deleteUser(String name) {
DButil DB = new DButil();
Connection conn = null;
Statement state = null;
String sql = "";
boolean flag = false;
try {
conn = DB.getConn();
sql = "delete from middle_text where name ='" + name + "'";
state = conn.createStatement();
int a = 0;
a = state.executeUpdate(sql);
if (a != 0) {
flag = true;
}
} catch (Exception e) {
// TODO: handle exception
} finally {
DB.close(conn);
DB.close(state);
} return flag;
}
//֤
/*public boolean loginUser(String userName, String password) { DButil DB = new DButil();
boolean flag = false;
Connection con = null;
MD5_Salt ms = new MD5_Salt();
try {
con = DB.getConn();
Statement state = con.createStatement();
ResultSet rs = state.executeQuery("select * from user where username='" + userName + "'");
if (rs.next()) {
String dbPassword = rs.getString("dbpassword");
String salt1 = rs.getString("salt1");
String salt2 = rs.getString("salt2");
flag = ms.TF_Password_DBpassword(password, dbPassword, salt1, salt2);
} } catch (SQLException e) {
// TODO �Զ����ɵ� catch ��
e.printStackTrace();
}
return flag; }*/ // ��������
public boolean resetUserPassword(String name,String sex,String outlook,String service) { DButil DB = new DButil();
boolean flag = false;
Connection conn = null;
Statement state = null;
int a = 0;
try {
String sql="update middle_text set sex='" + sex
+ "',outlook='"+outlook+"',service='"+service+"'where name= '" + name + "'";
conn = DB.getConn();
state = conn.createStatement();
a = state.executeUpdate(sql);
if (a > 0) {
flag = true;
} } catch (SQLException e) {
// TODO �Զ����ɵ� catch ��
e.printStackTrace();
}
return flag; }
/*public boolean searchuser(String username)
{
User user=new User();
DButil DB = new DButil();
boolean flag = false;
Connection conn = null;
Statement state = null;
int a = 0;
try { //"select * from User";
//select ename ,sal from emp where ename='SMITH';
String sql="select * from text where username= '"+username+"'";
//String sql="select password from text where username='" + username + "'";
conn = DB.getConn();
state = conn.createStatement();
ResultSet rs = state.executeQuery(sql); if (rs != null) {
while(rs.next()) {
user.setId(rs.getString("id"));
user.setUsername(rs.getString("username"));
user.setPassword(rs.getString("password"));
}
System.out.println(user.getPassword());
flag = true; } } catch (SQLException e) {
// TODO �Զ����ɵ� catch ��
e.printStackTrace();
}
return flag; }*/ // ������
/*public boolean resetUserPassword(String userName, String newPassword) { DButil DB = new DButil();
Salt salt = new Salt();
MD5_Salt ms = new MD5_Salt();
boolean flag = false;
Connection conn = null;
Statement state = null;
int a = 0;
try {
String salt1 = salt.getSalt();
String salt2 = salt.getSalt();
String dbPassword = ms.get_MD5Salt(newPassword, salt1, salt2);
String sql = "update user set dbpassword='" + dbPassword + "', salt1='" + salt1 + "', salt2= '" + salt2
+ "'where username= '" + userName + "'"; conn = DB.getConn();
state = conn.createStatement();
a = state.executeUpdate(sql);
if (a > 0) {
flag = true;
} } catch (SQLException e) {
// TODO �Զ����ɵ� catch ��
e.printStackTrace();
}
return flag;
*/ // �鿴���л�Ա
/* public List<User> UserList() {
DButil DB = new DButil();
String sql = "select * from text ";
List<User> list = new ArrayList<>();
Connection conn = null;
Statement state = null;
ResultSet rs = null; try {
conn = DB.getConn();
state = conn.createStatement();
rs = state.executeQuery(sql);
User user = null;
while (rs.next()) { int id2 = rs.getInt("id");
String userName2 = rs.getString("username");
// String password2 =rs.getString("password");
String name2 = rs.getString("name");
user = new User();
user.setId(id2);
user.setUsername(userName2);
list.add(user);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DB.close(conn);
DB.close(state);
DB.close(rs);
} return list;
}*/
}
(二).对志愿者操作功能
此部分为对志愿者的增删改操作
数据库：
主界面jsp：
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<script type="text/javascript">
</script>
<meta charset="utf-8">
<title>主菜单</title>
</head>
<body>
<a href="log.jsp">返回登录界面</a> <div align="center">
<h1>请选择功能</h1>
<br>
<a href="create.jsp">增加志愿者信息</a>
<br>
<a href="remove.jsp">删除志愿者信息</a>
<br>
<a href="update.jsp">修改志愿者信息</a>
<br>
<a href="mixsarch.jsp">查询志愿者信息</a>
<br>
<a href="show.jsp">显示志愿者信息</a> </div>
</body>
</html>
增加志愿者jsp：
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<script type="text/javascript">
var c=0,limit=4;
function doCheck(obj) {
obj.checked?c++:c--;
if(c>limit){
obj.checked=false;
alert("所选个数最大为4个 !!!");
c--;
}
}
</SCRIPT>
<title>增加用户</title>
</head>
<body>
<%
Object message = request.getAttribute("message");
if (message != null && !"".equals(message)) {
%>
<script type="text/javascript">
alert("<%=request.getAttribute("message")%>");
</script>
<%
}
%>
<a href="main_menu.jsp">返回主界面</a>
<form action="Adduser" name="create" method="post">
<div align="center">
<h1>请输入此成员信息</h1>
姓名:<input id="name" name="name" type="text" value=""
onChange="change1(this.value)"> <br> 性别: <input
id="sex" name="sex" type="radio" value="男"> 男 <input
id="sex" name="sex" type="radio" value="女"> 女 <br> 民族:<input
id="nation" name="nation" type="text" value=""
onChange="change3(this.value)"> <br> 注册时间:<input
id="time" name="time" type="text" value=""
onChange="change4(this.value)"> <br> 年龄:<input id="age"
name="age" type="text" value="" onChange="change4(this.value)">
<br> 政治面貌:<select name="outlook">
<option value="群众">群众</option>
<option value="共青团员">共青团员</option>
<option value="中*员">中*员</option>
</select> <br> 服务类别(最多选择四项): <br> <input type="checkbox"
name="service" value="扶危济困" onClick="doCheck(this)">扶危济困 <input
type="checkbox" name="service" value="敬老助残" onClick="doCheck(this)">敬老助残
<input type="checkbox" name="service" value="社区服务"
onClick="doCheck(this)">社区服务 <input type="checkbox"
name="service" value="秩序维护" onClick="doCheck(this)">秩序维护 <input
type="checkbox" name="service" value="文体服务" onClick="doCheck(this)">文体服务
<br> <input type="checkbox" name="service" value="环境保护"
onClick="doCheck(this)">环境保护 <input type="checkbox"
name="service" value="治安防范" onClick="doCheck(this)">治安防范 <input
type="checkbox" name="service" value="医疗救治" onClick="doCheck(this)">医疗救治
<input type="checkbox" name="service" value="法律援助"
onClick="doCheck(this)">法律援助 <input type="checkbox"
name="service" value="大型活动" onClick="doCheck(this)">大型活动 <br>
<input type="checkbox" name="service" value="心理疏导"
onClick="doCheck(this)">心理疏导 <input type="checkbox"
name="service" value="精神抚慰" onClick="doCheck(this)">精神抚慰 <input
type="checkbox" name="service" value="支教支医" onClick="doCheck(this)">
支教支医 <input type="checkbox" name="service" value="科学普及"
onClick="doCheck(this)">科学普及 <input type="checkbox"
name="service" value="应急救援" onClick="doCheck(this)">应急救援 <br>
<input type="checkbox" name="service" value="便民服务"
onClick="doCheck(this)">便民服务 <input type="checkbox"
name="service" value="民事调解" onClick="doCheck(this)">民事调解 <input
type="checkbox" name="service" value="文明引导" onClick="doCheck(this)">文明引导
<input type="checkbox" name="service" value="安全生产"
onClick="doCheck(this)">安全生产 <input type="checkbox"
name="service" value="禁毒宣传" onClick="doCheck(this)">禁毒宣传 <br>
<input type="submit" value="确定">
</div>
</form>
<script type="text/javascript">
/* var reg=/^[a-zA-Z]\w*$/;
var flag1=false,flag2=false,flag3=false;
function change1(obj)
{
var pattern = /^\w+$/i;
var arr = obj.match(pattern);
if(arr)
{}
else
alert("用户名格式不正确，4-10位数字/字母/下划线");
if(obj.length<4||obj.length>10)
{
alert("用户名格式不正确，4-10位数字/字母/下划线"); }
}
function change2(obj)
{ var pattern = /^\w+$/i;
var arr = obj.match(pattern);
if(arr)
{}
else
alert("密码格式不正确，4-10位数字/字母/下划线");
if(obj.length<4||obj.length>10)
{
alert("密码格式不正确，4-10位数字/字母/下划线"); } }*/
</script>
</body>
</html>
servlet：
package servlet; 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;
import bean.*;
import dao.UserDao; /**
* Servlet implementation class Adduser
*/
@WebServlet("/Adduser")
public class Adduser extends HttpServlet {
private static final long serialVersionUID = 1L; /**
* @see HttpServlet#HttpServlet()
*/
public Adduser() {
super();
// TODO Auto-generated constructor stub
} /**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { int s=0;
request.setCharacterEncoding("utf-8");
String name=request.getParameter("name");
String sex=request.getParameter("sex");
String nation=request.getParameter("nation");
String time=request.getParameter("time");
String age=request.getParameter("age");
String outlook=request.getParameter("outlook");
String []service = request.getParameterValues("service");
User user=new User();
user.setName(name);
user.setSex(sex);
user.setNation(nation);
user.setTime(time);
user.setAge(age);
user.setOutlook(outlook);
user.setService(service);
//UserDao userDao=UserDao.getUserDao();
UserDao userDao=new UserDao();
if(userDao.addUser(user))
{ //request.setAttribute("message", "添加成功");
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
//out.print("<script language='javascript'>alert('添加成功');window.location.href='main_menu.jsp';</script>");
out.print("<script language='javascript'>alert('添加成功');window.location.href='main_menu.jsp';</script>");
} else
{ //request.setAttribute("message", "添加成功");
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
//out.print("<script language='javascript'>alert('添加成功');window.location.href='main_menu.jsp';</script>");
out.print("<script language='javascript'>alert('添加失败');window.location.href='main_menu.jsp';</script>"); } } /**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doGet(request, response);
} }
删除志愿者jsp(一个确定界面，一个输入界面)：
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" import="bean.User"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<script type="text/javascript">
</script>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>显示结果</title>
</head>
<body>
<a href="main_menu.jsp">返回主界面</a>
<br>
<%
User user = (User)request.getAttribute("user");
%>
<form action="Deleteuser" name="create" method="post" >
<div align="center">
<h1>请确定此成员信息</h1>
<input id ="name" name="name" type="hidden" value="<%=user.getName() %>" onChange="change1(this.value)">
<br>
性别:<%=user.getSex() %>
<br>
民族:<%=user.getNation() %>
<br>
注册时间:<%=user.getTime() %>
<br>
年龄:<%=user.getAge() %>
<br>
政治面貌:<%=user.getOutlook() %>
<br>
服务类别:<%=user.getService() %>
<br>
<input name="Submit" type="submit" class="inputedit" value="删除"
onclick="{if(confirm('确定删除吗?')){
this.document.formname.submit();
return true;}return false;
}">
</div>
</form>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>删除用户</title>
</head>
<body>
<%
Object message = request.getAttribute("message");
if(message!=null && !"".equals(message)){ %>
<script type="text/javascript">
alert("<%=request.getAttribute("message")%>");
</script>
<%} %>
<a href="main_menu.jsp">返回主界面</a>
<form action="deleting" name="remove" method="post" onsubmit="return check()">
<div align="center">
<h1>请输入被删除用户的姓名</h1>
姓名:<input id ="name" name="name" type="text" value="" onChange="change1(this.value)">
<br>
<input type="submit" value="确定"> </div>
</form>
<script type="text/javascript">
function change1(obj)
{
if(obj.length==0)
{
alert("ID不能为空"); } } </script>
</body>
</html>
servlet：
package servlet; 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; import bean.Account;
import bean.User;
import dao.UserDao; /**
* Servlet implementation class Deleteuser
*/
@WebServlet("/Deleteuser")
public class Deleteuser extends HttpServlet {
private static final long serialVersionUID = 1L; /**
* @see HttpServlet#HttpServlet()
*/
public Deleteuser() {
super();
// TODO Auto-generated constructor stub
} /**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
int s=0;
request.setCharacterEncoding("utf-8");
String name=request.getParameter("name");
User user = new User();
user.setName(name);
UserDao userDao=new UserDao();
if(userDao. deleteUser(name))
{ response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
out.print("<script language='javascript'>alert('删除成功');window.location.href='main_menu.jsp';</script>");
} else
{
if(s==1)
{request.setAttribute("message", "删除失败");
request.getRequestDispatcher("remove.jsp").forward(request,response);
}
else if(s==0)
{request.getRequestDispatcher("remove.jsp").forward(request,response);
s=1;}
}
} /**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doGet(request, response);
} }
/**
* @see HttpServlet#HttpServlet()
*/
public deleting() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
String name=request.getParameter("name");
DButil DB = new DButil();
Connection conn = DB.getConn();
String sql="select * from middle_text where name= '"+name+"'";
try {
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery(sql);
User user = new User();
while(rs.next()) {
user.setName(rs.getString("name"));
user.setSex(rs.getString("sex"));
user.setNation(rs.getString("nation"));
user.setTime(rs.getString("time"));
user.setAge(rs.getString("age"));
user.setOutlook(rs.getString("outlook"));
user.setService(rs.getString("service"));
}
//将数据库中查询到的信息封装在user对象中，use对象保存在request中，之后将通过request对象将数据传递到页面
//需要的话也可以只传递一个参数request.setAttribute("id", user.getId());
request.setAttribute("user", user);
//这里是转发，从Servlet跳转到showinfo.jsp页面，并且带上request和response对象中原有的参数
response.setContentType("text/html;charset=utf-8");
request.getRequestDispatcher("/delete.jsp").forward(request, response);
} catch (SQLException e) {
e.printStackTrace();
}
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doGet(request, response);
}
}
更改志愿者信息jsp(同删包含两个界面)：
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>修改用户信息</title>
</head>
<body>
<%
Object message = request.getAttribute("message");
if(message!=null && !"".equals(message)){ %>
<script type="text/javascript">
alert("<%=request.getAttribute("message")%>");
</script>
<%} %>
<a href="main_menu.jsp">返回主界面</a>
<form action="upadting" name="update" method="post" onsubmit="return check()">
<div align="center">
<h1>请输入姓名</h1>
姓名:<input id ="name" name="name" type="text" value="" onChange="change1(this.value)">
<br>
<input type="submit" value="确定">
</div>
</form>
<script type="text/javascript"> </script>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" import="bean.User"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<script type="text/javascript">
alert("查询成功!")
</script>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>显示结果</title>
</head>
<body>
<a href="main_menu.jsp">返回主界面</a>
<br>
<%
User user = (User)request.getAttribute("user");
%>
<a href="main_menu.jsp">返回主界面</a>
<form action="Updateuser" name="create" method="post" >
<div align="center">
<h1>请修改此成员信息</h1>
<input id ="name" name="name" type="hidden" value="<%=user.getName() %>" onChange="change1(this.value)">
<br>
性别:<input id ="sex" name="sex" type="text" value="<%=user.getSex() %>" onChange="change1(this.value)">
<br>
民族:<%=user.getNation() %>
<br>
注册时间:<%=user.getTime() %>
<br>
年龄:<%=user.getAge() %>
<br>
政治面貌:<input id ="outlook" name="outlook" type="text" value="<%=user.getOutlook() %>" onChange="change1(this.value)">
<br>
服务类别:<input id ="service" name="service" type="text" value="<%=user.getService() %>" onChange="change1(this.value)">
<br>
<input type="submit" value="确定">
</div>
</form>
</body>
</html>
servlet：
package servlet; import java.io.IOException;
import java.sql.Connection;
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; import bean.Account;
import bean.User;
import util.DButil; /**
* Servlet implementation class upadting
*/
@WebServlet("/upadting")
public class upadting extends HttpServlet {
private static final long serialVersionUID = 1L; /**
* @see HttpServlet#HttpServlet()
*/
public upadting() {
super();
// TODO Auto-generated constructor stub
} /**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
String name=request.getParameter("name");
DButil DB = new DButil();
Connection conn = DB.getConn();
String sql="select * from middle_text where name= '"+name+"'"; try { Statement st = conn.createStatement(); ResultSet rs = st.executeQuery(sql); User user = new User(); while(rs.next()) { user.setName(rs.getString("name"));
user.setSex(rs.getString("sex"));
user.setNation(rs.getString("nation"));
user.setTime(rs.getString("time"));
user.setAge(rs.getString("age"));
user.setOutlook(rs.getString("outlook"));
user.setService(rs.getString("service")); } //将数据库中查询到的信息封装在user对象中，use对象保存在request中，之后将通过request对象将数据传递到页面 //需要的话也可以只传递一个参数request.setAttribute("id", user.getId()); request.setAttribute("user", user); //这里是转发，从Servlet跳转到showinfo.jsp页面，并且带上request和response对象中原有的参数
response.setContentType("text/html;charset=utf-8");
request.getRequestDispatcher("/updating.jsp").forward(request, response); } catch (SQLException e) { e.printStackTrace(); }
} /**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doGet(request, response);
} }
package servlet; 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; import bean.Account;
import bean.User;
import dao.UserDao; /**
* Servlet implementation class Updateuser
*/
@WebServlet("/Updateuser")
public class Updateuser extends HttpServlet {
private static final long serialVersionUID = 1L; /**
* @see HttpServlet#HttpServlet()
*/
public Updateuser() {
super();
// TODO Auto-generated constructor stub
} /**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
int s=0;
request.setCharacterEncoding("utf-8");
String name=request.getParameter("name");
String sex=request.getParameter("sex");
String outlook=request.getParameter("outlook");
String service=request.getParameter("service");
User user=new User();
user.setSex(sex);
user.setOutlook(outlook);
user.setService(service);
//UserDao userDao=UserDao.getUserDao();
UserDao userDao=new UserDao();
if(userDao. resetUserPassword(name,sex,outlook,service))
{ response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
out.print("<script language='javascript'>alert('修改成功');window.location.href='main_menu.jsp';</script>");
} else
{
if(s==1)
{request.setAttribute("message", "修改失败");
request.getRequestDispatcher("update.jsp").forward(request,response);
}
else if(s==0)
{request.getRequestDispatcher("update.jsp").forward(request,response);
s=1;}
} } /**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doGet(request, response);
} }