#会员信息操作页
#选择添加后跳转到增加会员页
#数据库创建
CREATE TABLE membermsg (
id int(11) NOT NULL DEFAULT ‘0’,
name varchar(20) DEFAULT NULL,
sex int(11) DEFAULT NULL,
password varchar(10) DEFAULT NULL,
phone varchar(20) DEFAULT NULL,
address varchar(20) DEFAULT NULL,
Email varchar(20) DEFAULT NULL,
integral int(11) DEFAULT NULL,
grate varchar(20) DEFAULT NULL,
lastresidetime date NOT NULL,
lastordertime date NOT NULL,
remark varchar(20) DEFAULT NULL,
PRIMARY KEY (id)
)
#实体类
package com.neu.entity;
import java.util.Date;
public class Membermsg {
private Integer id;
private String name;
private Integer sex;
private String password;
private String phone;
private String address;
private String Email;
private Integer integral;
private String grate;
private Date lastresidetime;
private Date lastordertime;
private String remark;
public Membermsg() {
super();
// TODO 自动生成的构造函数存根
}
public Membermsg(Integer id, String name, Integer sex, String password, String phone, String address, String email,
Integer integral, String grate, Date lastresidetime, Date lastordertime, String remark) {
super();
this.id = id;
this.name = name;
this.sex = sex;
this.password = password;
this.phone = phone;
this.address = address;
Email = email;
this.integral = integral;
this.grate = grate;
this.lastresidetime = lastresidetime;
this.lastordertime = lastordertime;
this.remark = remark;
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Integer getSex() {
return sex;
}
public void setSex(Integer sex) {
this.sex = sex;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public String getEmail() {
return Email;
}
public void setEmail(String email) {
Email = email;
}
public Integer getIntegral() {
return integral;
}
public void setIntegral(Integer integral) {
this.integral = integral;
}
public String getGrate() {
return grate;
}
public void setGrate(String grate) {
this.grate = grate;
}
public Date getLastresidetime() {
return lastresidetime;
}
public void setLastresidetime(Date lastresidetime) {
this.lastresidetime = lastresidetime;
}
public Date getLastordertime() {
return lastordertime;
}
public void setLastordertime(Date lastordertime) {
this.lastordertime = lastordertime;
}
public String getRemark() {
return remark;
}
public void setRemark(String remark) {
this.remark = remark;
}
@Override
public int hashCode() {
final int prime = 31;
int result = 1;
result = prime * result + ((Email == null) ? 0 : Email.hashCode());
result = prime * result + ((address == null) ? 0 : address.hashCode());
result = prime * result + ((grate == null) ? 0 : grate.hashCode());
result = prime * result + ((id == null) ? 0 : id.hashCode());
result = prime * result + ((integral == null) ? 0 : integral.hashCode());
result = prime * result + ((lastordertime == null) ? 0 : lastordertime.hashCode());
result = prime * result + ((lastresidetime == null) ? 0 : lastresidetime.hashCode());
result = prime * result + ((name == null) ? 0 : name.hashCode());
result = prime * result + ((password == null) ? 0 : password.hashCode());
result = prime * result + ((phone == null) ? 0 : phone.hashCode());
result = prime * result + ((remark == null) ? 0 : remark.hashCode());
result = prime * result + ((sex == null) ? 0 : sex.hashCode());
return result;
}
@Override
public boolean equals(Object obj) {
if (this == obj)
return true;
if (obj == null)
return false;
if (getClass() != obj.getClass())
return false;
Membermsg other = (Membermsg) obj;
if (Email == null) {
if (other.Email != null)
return false;
} else if (!Email.equals(other.Email))
return false;
if (address == null) {
if (other.address != null)
return false;
} else if (!address.equals(other.address))
return false;
if (grate == null) {
if (other.grate != null)
return false;
} else if (!grate.equals(other.grate))
return false;
if (id == null) {
if (other.id != null)
return false;
} else if (!id.equals(other.id))
return false;
if (integral == null) {
if (other.integral != null)
return false;
} else if (!integral.equals(other.integral))
return false;
if (lastordertime == null) {
if (other.lastordertime != null)
return false;
} else if (!lastordertime.equals(other.lastordertime))
return false;
if (lastresidetime == null) {
if (other.lastresidetime != null)
return false;
} else if (!lastresidetime.equals(other.lastresidetime))
return false;
if (name == null) {
if (other.name != null)
return false;
} else if (!name.equals(other.name))
return false;
if (password == null) {
if (other.password != null)
return false;
} else if (!password.equals(other.password))
return false;
if (phone == null) {
if (other.phone != null)
return false;
} else if (!phone.equals(other.phone))
return false;
if (remark == null) {
if (other.remark != null)
return false;
} else if (!remark.equals(other.remark))
return false;
if (sex == null) {
if (other.sex != null)
return false;
} else if (!sex.equals(other.sex))
return false;
return true;
}
@Override
public String toString() {
return "Membermsg [id=" + id + ", name=" + name + ", sex=" + sex + ", password=" + password + ", phone=" + phone
+ ", address=" + address + ", Email=" + Email + ", integral=" + integral + ", grate=" + grate
+ ", lastresidetime=" + lastresidetime + ", lastordertime=" + lastordertime + ", remark=" + remark
+ "]";
}
}
#数据访问层
1.
package com.neu.dao;
import java.util.List;
import com.neu.entity.Membermsg;
public interface MembermsgDao {
List<Membermsg> getAll() throws Exception;
List<Membermsg> getFind(Membermsg membermsg) throws Exception;
int getInsert(Membermsg membermsg) throws Exception;
int getUpdate(Membermsg membermsg) throws Exception;
int getDelete(int id) throws Exception;
}
package com.neu.dao;
import java.sql.Connection;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import com.neu.entity.Membermsg;
public class MembermsgDaoImpl implements MembermsgDao {
//全部显示
@Override
public List<Membermsg> getAll() throws Exception {
Connection connection = JDBCUtil.getConnection();
String sql = "select * from membermsg";
ResultSet rs = JDBCUtil.executeQuery(connection, sql, null);
List<Membermsg> list = new ArrayList<>();
Membermsg membermsg = null;
Integer id;
String name;
Integer sex;
String password;
String phone;
String address;
String email;
Integer integral;
String grate;
Date lastresidetime;
Date lastordertime;
String remark;
while(rs.next()) {
id = rs.getInt("id");
name = rs.getString("name");
sex = rs.getInt("sex");
password = rs.getString("password");
phone = rs.getString("phone");
address = rs.getString("address");
email = rs.getString("email");
integral = rs.getInt("integral");
grate = rs.getString("grate");
lastresidetime = rs.getDate("lastresidetime");
lastordertime = rs.getDate("lastordertime");
remark = rs.getString("remark");
membermsg = new Membermsg(id, name, sex, password, phone, address, email, integral, grate, lastresidetime, lastordertime, remark);
list.add(membermsg);
}
JDBCUtil.closeConnection(connection);
return list;
}
//查找
@Override
public List<Membermsg> getFind(Membermsg membermsg) throws Exception {
StringBuilder stb = new StringBuilder();
stb.append("select * from membermsg where 1=1 ");
if(membermsg.getId()!=-1) {
stb.append("and id ='"+membermsg.getId()+"' ");
}
if(!membermsg.getName().trim().equals("")){
stb.append("and name ='"+membermsg.getName().trim()+"' ");
}
Connection connection = JDBCUtil.getConnection();
String sql = stb.toString();
ResultSet rs = JDBCUtil.executeQuery(connection, sql, null);
List<Membermsg> list = new ArrayList<>();
Integer id;
String name;
Integer sex;
String password;
String phone;
String address;
String email;
Integer integral;
String grate;
Date lastresidetime;
Date lastordertime;
String remark;
while(rs.next()) {
id = rs.getInt("id");
name = rs.getString("name");
sex = rs.getInt("sex");
password = rs.getString("password");
phone = rs.getString("phone");
address = rs.getString("address");
email = rs.getString("email");
integral = rs.getInt("integral");
grate = rs.getString("grate");
/*因为需要用json的（json-lib-2.2.3-jdk13.jar）的jar包去传递集合所以
需要将日期类型做如下操作
*/
lastresidetime = new Date(rs.getDate("lastresidetime").getTime());
lastordertime = new Date(rs.getDate("lastordertime").getTime());
remark = rs.getString("remark");
membermsg = new Membermsg(id, name, sex, password, phone, address, email, integral, grate, lastresidetime, lastordertime, remark);
list.add(membermsg);
}
JDBCUtil.closeConnection(connection);
return list;
}
//添加
@Override
public int getInsert(Membermsg membermsg) throws Exception {
String sql = "INSERT INTO membermsg VALUES (?,?,?,?,?,?,?,?,?,?,?,?)";
int n = JDBCUtil.executeUpdate(sql, new Object[] {
membermsg.getId(),membermsg.getName(),membermsg.getSex(),membermsg.getPassword(),membermsg.getPhone(),
membermsg.getAddress(),membermsg.getEmail(),membermsg.getIntegral(),membermsg.getGrate(),membermsg.getLastresidetime(),
membermsg.getLastordertime(),membermsg.getRemark()});
return n;
}
//更改
@Override
public int getUpdate(Membermsg membermsg) throws Exception {
String sql = "update membermsg set name = ?,sex = ?,password = ?,phone = ?,address = ?,email = ?,"
+ "integral = ?,grate = ?,lastresidetime = ?,lastordertime = ?,remark = ? where id = ?";
int n = JDBCUtil.executeUpdate(sql, new Object[] {
membermsg.getName(),membermsg.getSex(),membermsg.getPassword(),membermsg.getPhone(),
membermsg.getAddress(),membermsg.getEmail(),membermsg.getIntegral(),membermsg.getGrate(),membermsg.getLastresidetime(),
membermsg.getLastordertime(),membermsg.getRemark(),membermsg.getId()});
return n;
}
//删除
@Override
public int getDelete(int id) throws Exception {
String sql = "delete from membermsg where id = ?";
int n = JDBCUtil.executeUpdate(sql, new Object[] {id});
return n;
}
}
#业务逻辑层
1.
package com.neu.service;
import java.util.List;
import com.neu.entity.Membermsg;
public interface MembermsgService {
List<Membermsg> getAll() throws Exception;
List<Membermsg> getFind(Membermsg membermsg) throws Exception;
int getInsert(Membermsg membermsg) throws Exception;
int getUpdate(Membermsg membermsg) throws Exception;
int getDelete(int id) throws Exception;
}
package com.neu.service;
import java.util.List;
import com.neu.dao.MembermsgDao;
import com.neu.dao.MembermsgDaoImpl;
import com.neu.entity.Membermsg;
public class MembermsgServiceImpl implements MembermsgService {
private MembermsgDao membermsgDao = new MembermsgDaoImpl();
@Override
public List<Membermsg> getAll() throws Exception {
// TODO 自动生成的方法存根
return membermsgDao.getAll();
}
@Override
public List<Membermsg> getFind(Membermsg membermsg) throws Exception {
// TODO 自动生成的方法存根
return membermsgDao.getFind(membermsg);
}
@Override
public int getInsert(Membermsg membermsg) throws Exception {
// TODO 自动生成的方法存根
return membermsgDao.getInsert(membermsg);
}
@Override
public int getUpdate(Membermsg membermsg) throws Exception {
// TODO 自动生成的方法存根
return membermsgDao.getUpdate(membermsg);
}
@Override
public int getDelete(int id) throws Exception {
// TODO 自动生成的方法存根
return membermsgDao.getDelete(id);
}
}
#表示层
- MembermsgServlet.java
package com.neu.servlet;
import java.io.IOException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;
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 com.neu.entity.Membermsg;
import com.neu.service.MembermsgService;
import com.neu.service.MembermsgServiceImpl;
import net.sf.json.JSONArray;
/**
* Servlet implementation class MembermsgServlet
*/
@WebServlet("/MembermsgServlet")
public class MembermsgServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
private MembermsgService membermsgService = new MembermsgServiceImpl();
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
String method = request.getParameter("method");
if ("getAll".equals(method)) {
doAll(request, response);
} else if ("add".equals(method)) {
doAdd(request, response);
} else if ("search".equals(method)) {
doSearch(request, response);
} else if ("delete".equals(method)) {
doDel(request, response);
} else if ("update".equals(method)) {
doUpd(request, response);
}
}
// 更改
private void doUpd(HttpServletRequest request, HttpServletResponse response) throws IOException {
Integer id = Integer.parseInt(request.getParameter("id"));
String name = request.getParameter("name");
Integer sex = Integer.parseInt(request.getParameter("sex"));
;
String password = request.getParameter("password");
String phone = request.getParameter("phone");
String address = request.getParameter("address");
String email = request.getParameter("email");
Integer integral = Integer.parseInt(request.getParameter("integral"));
String grate = request.getParameter("grate");
SimpleDateFormat d = new SimpleDateFormat("yyyy-MM-dd");
Date lastresidetime = null;
try {
lastresidetime = d.parse(request.getParameter("lastresidetime"));
} catch (ParseException e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
}
Date lastordertime = null;
try {
lastordertime = d.parse(request.getParameter("lastordertime"));
} catch (ParseException e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
}
String remark = request.getParameter("remark");
Membermsg membermsg = new Membermsg(id, name, sex, password, phone, address, email, integral, grate,
lastresidetime, lastordertime, remark);
int result;
try {
result = membermsgService.getUpdate(membermsg);
} catch (Exception e) {
result = 0;
e.printStackTrace();
}
response.getWriter().print(result);
}
// 删除
private void doDel(HttpServletRequest request, HttpServletResponse response) throws IOException {
Integer id = Integer.parseInt(request.getParameter("id"));
int result;
try {
result = membermsgService.getDelete(id);
} catch (Exception e) {
result = 0;
e.printStackTrace();
}
response.getWriter().print(result);
}
// 条件查询
private void doSearch(HttpServletRequest request, HttpServletResponse response) {
String i = request.getParameter("id");
Integer id = -1;
if (i != "") {
id = Integer.parseInt(i);
}
String name = request.getParameter("name");
Membermsg membermsg = new Membermsg();
membermsg.setId(id);
membermsg.setName(name);
try {
List<Membermsg> list = membermsgService.getFind(membermsg);
String jsonArray = JSONArray.fromObject(list).toString();
response.getWriter().print(jsonArray);
} catch (Exception e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
}
}
// 添加
private void doAdd(HttpServletRequest request, HttpServletResponse response) throws IOException {
Integer id = Integer.parseInt(request.getParameter("id"));
String name = request.getParameter("name");
Integer sex = Integer.parseInt(request.getParameter("sex"));
;
String password = request.getParameter("password");
String phone = request.getParameter("phone");
String address = request.getParameter("address");
String email = request.getParameter("email");
Integer integral = Integer.parseInt(request.getParameter("integral"));
String grate = request.getParameter("grate");
SimpleDateFormat d = new SimpleDateFormat("yyyy-MM-dd");
Date lastresidetime = null;
try {
lastresidetime = d.parse(request.getParameter("lastresidetime"));
} catch (ParseException e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
}
Date lastordertime = null;
try {
lastordertime = d.parse(request.getParameter("lastordertime"));
} catch (ParseException e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
}
String remark = request.getParameter("remark");
Membermsg membermsg = new Membermsg(id, name, sex, password, phone, address, email, integral, grate,
lastresidetime, lastordertime, remark);
int result;
try {
result = membermsgService.getInsert(membermsg);
} catch (Exception e) {
result = 0;
e.printStackTrace();
}
response.getWriter().print(result);
}
// 显示
private void doAll(HttpServletRequest request, HttpServletResponse response) {
try {
List<Membermsg> list = membermsgService.getAll();
request.setAttribute("list", list);
request.getRequestDispatcher("/WEB-INF/jsp/membermsg/membermsg.jsp").forward(request, response);
} catch (Exception e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// TODO Auto-generated method stub
doGet(request, response);
}
}
2.membermsg.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<script type="text/javascript" src="js/jquery-3.2.1.js"></script>
<script type="text/javascript">
//添加一个得到时间的方法用于条件查询得出的时间进行转换
function getTime(d){
var year = d.year + 1900;
var month = d.month+1;
var date = d.date;
return year+"-"+month+"-"+date;
}
$(function(){
//添加保存
$(":button[value=提交]").click(function(){
var url = "${ pageContext.request.contextPath }/MembermsgServlet?method=add";
var param = $("form:eq(2)").serialize();
$.get(url,param,function(data){
if(data=1){
alert("添加成功");
location.reload(); //刷新页面
$("table:eq(0)").show(); //显示会员查询
$("#tab").show(); //显示所有会员信息
$("#tab1").hide(); //隐藏会员登记页
}else{
alert("添加失败");
}
});
});
//选择添加页
$(":button[value=添加]").click(function(){
$("table:eq(0)").hide(); //隐藏会员查询
$("#tab").hide(); //隐藏所有会员信息
$("#tab1").show(); //显示会员登记页
});
//根据积分获得级别
$("form:eq(2) [name=integral]").blur(function(){ //表单元素的祖先级也只能form 例：$("form:eq(2) [name=integral]")
var a = parseInt($(this).val());
//根据积分的条件，自动判断会员级别
if(a<5000){
$("form:eq(2) [value=普通]").prop("checked","true");
}else if(a>=5000){
$("form:eq(2) [value=vip]").prop("checked","true");
}
});
//保存编辑
$(document).on("click","a:contains(保存)",function(){
var url = "${ pageContext.request.contextPath }/MembermsgServlet?method=update";
var param = $("form:eq(1)").serialize();
var t = this;
$.get(url,param,function(data){
if(data==1){
$(t).text("编辑").parent().parent().children().each(function(index){
if(index<12){
var val = $(this).children().eq(0).val();
$(this).empty();
$(this).text(val);
}
});
}else{
alert("保存失败");
}
});
});
//编辑，更改会员信息
$(document).on("click","a:contains(编辑)",function(){
$(this).text("保存").parent().parent().children().each(function(index){
if(index<12){
var text = $(this).text();
$(this).empty();
if(index==0){
$("<input type = 'text' name = 'id'>").attr("readonly","true").val(text).appendTo($(this));
}else if(index==1){
$("<input type = 'text' name = 'name'>").val(text).appendTo($(this));
}else if(index==2){
$("<input type = 'text' name = 'sex'>").val(text).appendTo($(this));
}else if(index==3){
$("<input type = 'text' name = 'password'>").val(text).appendTo($(this));
}else if(index==4){
$("<input type = 'text' name = 'phone'>").val(text).appendTo($(this));
}else if(index==5){
$("<input type = 'text' name = 'address'>").val(text).appendTo($(this));
}else if(index==6){
$("<input type = 'text' name = 'email'>").val(text).appendTo($(this));
}else if(index==7){
$("<input type = 'text' name = 'integral'>").val(text).appendTo($(this));
}else if(index==8){
$("<input type = 'text' name = 'grate'>").val(text).appendTo($(this));
}else if(index==9){
$("<input type = 'text' name = 'lastresidetime'>").val(text).appendTo($(this));
}else if(index==10){
$("<input type = 'text' name = 'lastordertime'>").val(text).appendTo($(this));
}else if(index==11){
$("<input type = 'text' name = 'remark'>").val(text).appendTo($(this));
}
}
});
});
//查询
$(":button[value=查询]").click(function(){
var url = "${ pageContext.request.contextPath }/MembermsgServlet?method=search";
var param = $("form:eq(0)").serialize();
$.get(url,param,function(data){
if(data!=null){
var jsonArray = eval("("+data+")");
$("#tab").children().children().not(":eq(0)").remove();
$(jsonArray).each(function(){
var tr = $("<tr>").appendTo("#tab");
$("<td>").text(this.id).appendTo(tr);
$("<td>").text(this.name).appendTo(tr);
$("<td>").text(this.sex).appendTo(tr);
$("<td>").text(this.password).appendTo(tr);
$("<td>").text(this.phone).appendTo(tr);
$("<td>").text(this.address).appendTo(tr);
$("<td>").text(this.email).appendTo(tr);
$("<td>").text(this.integral).appendTo(tr);
$("<td>").text(this.grate).appendTo(tr);
/*使用得到时间的方法，因为用json的jar包进行时间类型的信息传值所以
需要创建javascript方法getTime(d);（方法代码：在最上面），进行对时间 类型的解析
*/
$("<td>").text(getTime(this.lastresidetime)).appendTo(tr);
$("<td>").text(getTime(this.lastordertime)).appendTo(tr);
$("<td>").text(this.remark).appendTo(tr);
var del = $("<a>").attr("href","#").data("goodid",this.id).text("删除");
$("<td>").append(del).appendTo(tr);
var upd = $("<a>").attr("href","#").text("编辑");
$("<td>").append(upd).appendTo(tr);
});
}else{
alert("查无结果");
}
});
});
//删除
$(document).on("click","a:contains(删除)",function(){
if(confirm("是否删除")){
var url = "${ pageContext.request.contextPath }/MembermsgServlet?method=delete";
var param = "id="+$(this).data("id"); //使用 data- 的方法传递 id 的值
//"id="这里不能有空格
var t = this;
$.get(url,param,function(data){
if(data==1){
$(t).parent().parent().remove();
}else{
alert("删除失败！");
}
});
}
});
//返回上一页
$(":button[value=返回]").click(function(){
history.back(); //返回上一页 人员权限操作页
});
});
</script>
</head>
<body>
//会员查询表单
<form>
<table align="center">
<caption><h2>会员管理</h2></caption>
<tr>
<td>编号：<input type="text" name="id"></td>
<td>姓名：<input type="text" name="name"></td>
</tr>
<tr align="center">
<td colspan="2">
<input type="button" value="查询">
<input type="button" value="添加">
<input type="button" value="返回">
</td>
</tr>
</table>
</form>
<hr>
//显示所有会员信息，并能够进行删改操作
<form>
<table border="1" align="center" width="1000" id="tab">
<tr>
<th>编号</th>
<th>姓名</th>
<th>性别</th>
<th>密码</th>
<th>电话</th>
<th>地址</th>
<th>Email</th>
<th>积分</th>
<th>级别</th>
<th>最后一次入住时间</th>
<th>最后一次预定时间</th>
<th>备注</th>
<th>删除</th>
<th>编辑</th>
</tr>
<c:forEach items="${ list }" var="memb"> //使用for循环使其显示所有会员信息
<tr>
<td>${ memb.id }</td>
<td>${ memb.name }</td>
<td>${ memb.sex==1?"男":"女" }</td>
<td>${ memb.password }</td>
<td>${ memb.phone }</td>
<td>${ memb.address }</td>
<td>${ memb.email }</td>
<td>${ memb.integral }</td>
<td>${ memb.integral<5000?"普通":"vip" }</td>
//format方法格式化日期
<td><fmt:formatDate value="${ memb.lastresidetime }" pattern="yyyy-MM-dd"/></td>
<td><fmt:formatDate value="${ memb.lastordertime }" pattern="yyyy-MM-dd"/></td>
<td>${ memb.remark }</td>
<td><a href="#" data-id="${ memb.id }">删除</a></td> //data- 方法传递 id 的值
<td><a href="#">编辑</a></td>
</tr>
</c:forEach>
</table>
</form>
//会员登记注册表单， 进行会员的添加
<form>
<table align="center" id="tab1" hidden="hidden">
<caption><h2>会员登记</h2></caption>
<tr>
<td align="right">编号:</td><td><input type="text" name="id"></td>
</tr>
<tr>
<td align="right">姓名:</td><td><input type="text" name="name"></td>
</tr>
<tr>
<td align="right">性别:</td>
<td>
<input type="radio" name="sex" value="1">男
<input type="radio" name="sex" value="2">女
</td>
</tr>
<tr>
<td align="right">密码:</td><td><input type="password" name="password"></td>
</tr>
<tr>
<td align="right">电话:</td><td><input type="text" name="phone"></td>
</tr>
<tr>
<td align="right">地址:</td><td><input type="text" name="address"></td>
</tr>
<tr>
<td align="right">Email:</td><td><input type="email" name="email"></td>
</tr>
<tr>
<td align="right">积分:</td><td><input type="text" name="integral"></td>
</tr>
<tr>
<td align="right">级别:</td>
<td>
<input type="radio" name="grate" value="vip">vip
<input type="radio" name="grate" value="普通">普通
</td>
</tr>
<tr>
<td>最后一次入住时间:</td><td><input type="date" name="lastresidetime"></td>
</tr>
<tr>
<td>最后一次预定时间:</td><td><input type="date" name="lastordertime"></td>
</tr>
<tr>
<td align="right">备注:</td><td><textarea name="remark" rows="5" cols="21"></textarea></td>
</tr>
<tr align="center">
<td colspan="2">
<input type="button" value="提交">
<input type="reset" value="重置">
<td>
</tr>
</table>
</form>
</body>
</html>
2660
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
