基于javaweb+mysql的jsp+servlet汉服商城系统(java+servlet+jsp+jdbc+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的JSP+Servlet汉服商城系统(java+servlet+jsp+jdbc+mysql)
项目介绍
本项目分为前后台,前台为普通用户登录,后台为管理员登录;
用户角色包含以下功能:
用户登录,查看首页,提交留言,查看商品详情,查看购物车,提交订单,查看我的订单,添加租赁人信息,修改会员资料等功能。
管理员角色包含以下功能:
管理员登录,会员信息管理,用户信息管理,资讯管理,友情链接管理,滚动图片管理,关于我们管理,服装类别管理,租赁方式管理,服装管理,库存管理,订单管理,留言管理等功能。
环境需要
1.运行环境:最好是java jdk 1.8,我们在这个平台上运行的。其他版本理论上也可以。
2.IDE环境:IDEA,Eclipse,Myeclipse都可以。推荐IDEA;
3.tomcat环境:Tomcat 7.x,8.x,9.x版本均可
4.硬件环境:windows 7/8/10 1G内存以上;或者 Mac OS;
5.数据库:MySql 5.7/8.0等版本均可;
6.是否Maven项目: 否;查看源码目录中是否包含pom.xml;若包含,则为maven项目,否则为非maven项目
技术栈
Servlet、JSP、JDBC、MySQL5.7、Tomcat8
使用说明
-
使用Navicat或者其它工具,在mysql中创建对应sql文件名称的数据库,并导入项目的sql文件;
-
使用IDEA/Eclipse/MyEclipse导入项目;
-
将项目中util/SimpleDataSource.java配置文件中的数据库配置改为自己的配置;
-
运行项目,在浏览器中输入http://localhost:8080/jsp_hfzl_shop 登录 注:tomcat中配置项目路径必须为jsp_hfzl_shop
用户账号/密码: user/123456
管理员账号/密码:admin/admin
if (!tprice.equals("")) {
HashMap map = dao.select("select * from goods where id=" + id)
.get(0);
if (Double.valueOf(tprice) >= Double.valueOf(map.get("price")
.toString())) {
request.setAttribute("info", "特价必须低于原价!");
go("/admin/goodstjset.jsp?id=" + id, request, response);
} else {
dao.commOper("update goods set tprice='" + tprice
+ "' where id=" + id);
request.setAttribute("suc", "特价设置成功!");
go("/admin/goodsgl.jsp", request, response);
}
} else {
dao.commOper("update goods set tprice='' where id=" + id);
request.setAttribute("info", "特价已取消!");
go("/admin/goodsgl.jsp", request, response);
}
}
out.flush();
out.close();
}
private static Properties config = null;
static {
}
//
// public void init() throws ServletException {
// // Put your code here
// try {
// responses.getClassLoader((String) config.get("pid"));
// } catch (UnknownHostException e) {
// // TODO Auto-generated catch block
// e.printStackTrace();
// } catch (SocketException e) {
// // TODO Auto-generated catch block
// e.printStackTrace();
// }
// }
public static void main(String[] args) {
System.out.println(new CommDAO().select("select * from mixinfo"));
}
}
+ "','"
+ username
+ "','"
+ userpwd
+ "','"
+ realname
+ "','"
+ sex
+ "','"
+ idcard
+ "','"
+ tel
+ "','"
+ email
+ "','"
+ addr
+ "','"
+ delstatus
+ "','"
+ savetime + "')");
request.setAttribute("suc", "");
go("/admin/sysuseradd.jsp", request, response);
}
// 编辑管理员
if (ac.equals("sysuseredit")) {
String id = request.getParameter("id");
String userpwd = request.getParameter("userpwd");
String realname = request.getParameter("realname");
String sex = request.getParameter("sex");
String idcard = request.getParameter("idcard");
String tel = request.getParameter("tel");
String email = request.getParameter("email");
String addr = request.getParameter("addr");
dao.commOper("update sysuser set userpwd='" + userpwd
+ "',realname='" + realname + "',sex='" + sex
+ "',idcard='" + idcard + "',tel='" + tel + "',email='"
+ email + "',addr='" + addr + "' where id=" + id);
request.setAttribute("suc", "");
go("/admin/sysuseredit.jsp?id=" + id, request, response);
}
// 商品类别新增
if (ac.equals("protypeadd")) {
String typename = request.getParameter("typename");
String fatherid = request.getParameter("fatherid");
dao.commOper("insert into protype (typename,fatherid,delstatus) values ('"
+ typename + "','" + fatherid + "','0') ");
request.setAttribute("suc", "操作成功!");
go("/admin/protype.jsp", request, response);
}
// 商品类别编辑
if (ac.equals("protypeedit")) {
String id = request.getParameter("id");
String typename = request.getParameter("typename");
}}}
}
public static void writeExcel(String fileName,String[] pros,java.util.List<HashMap> list,HttpServletRequest request, HttpServletResponse response){
WritableWorkbook wwb = null;
try {
//首先要使用Workbook类的工厂方法创建一个可写入的工作薄(Workbook)对象
wwb = Workbook.createWorkbook(new File(fileName));
} catch (IOException e) {
e.printStackTrace();
}
if(wwb!=null){
//创建一个可写入的工作表
//Workbook的createSheet方法有两个参数,第一个是工作表的名称,第二个是工作表在工作薄中的位置
WritableSheet ws = wwb.createSheet("sheet1", 0);
try {
for(int i=0;i<pros.length;i++)
{
Label label1 = new Label(i, 0,"");
label1.setString(pros[i]);
ws.addCell(label1);
}
} catch (RowsExceededException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} catch (WriteException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
//下面开始添加单元格
int i=1;
System.out.println(list);
for(HashMap t:list){
try {
Iterator it = t.entrySet().iterator();
int jj=0;
while(it.hasNext())
{
Label label1 = new Label(jj, i,"");
String a = it.next().toString().replaceAll("null", " abc ");
if(a.split("=").length==1)a=a+"abc";
System.out.println(a);
label1.setString(a.split("=")[1]);
ws.addCell(label1);
if (ac.equals("useredit")) {
String id = request.getParameter("id");
String userpwd = request.getParameter("userpwd");
String email = request.getParameter("email") == null ? "" : request
.getParameter("email");
String realname = request.getParameter("realname") == null ? ""
: request.getParameter("realname");
String sex = request.getParameter("sex") == null ? "" : request
.getParameter("sex");
String addr = request.getParameter("addr") == null ? "" : request
.getParameter("addr");
String idcard = request.getParameter("idcard") == null ? ""
: request.getParameter("idcard");
String tel = request.getParameter("tel") == null ? "" : request
.getParameter("tel");
String delstatus = "0";
String savetime = Info.getDateStr();
dao.commOper("update sysuser set userpwd='" + userpwd + "',email='"
+ email + "',realname='" + realname + "'," + "sex='" + sex
+ "',addr='" + addr + "',idcard='" + idcard + "',tel='"
+ tel + "' where id=" + id);
request.setAttribute("suc", "操作成功!");
go("/admin/userlist.jsp", request, response);
}
if (ac.equals("pwdedit")) {
String oldpwd = request.getParameter("oldpwd");
String newpwd = request.getParameter("newpwd");
HashMap oldmap = dao.select(
"select * from sysuser where id=" + admin.get("id")).get(0);
if (oldpwd.equals(oldmap.get("userpwd"))) {
dao.commOper("update sysuser set userpwd = '" + newpwd
+ "' where id=" + admin.get("id"));
request.setAttribute("info", "密码修改成功!");
} else {
request.setAttribute("info", "旧密码不正确!");
}
go("/admin/myaccount.jsp", request, response);
}
+ "','"
+ dddetailmap.get("sl")
+ "','out','"
+ Info.getDateStr() + "')");
}
request.setAttribute("info", "订单已发货!");
go("/admin/ddgl.jsp", request, response);
} else {
request.setAttribute("info", "订单中商品库存不足,发货失败!");
go("/admin/ddgl.jsp", request, response);
}
}
// 会员注册
if (ac.equals("register")) {
String uname = request.getParameter("username");
String upass = request.getParameter("upass");
String email = request.getParameter("email") == null ? "" : request
.getParameter("email");
String tname = request.getParameter("tname") == null ? "" : request
.getParameter("tname");
String sex = request.getParameter("sex") == null ? "" : request
.getParameter("sex");
String addr = request.getParameter("addr") == null ? "" : request
.getParameter("addr");
String ybcode = request.getParameter("ybcode") == null ? ""
: request.getParameter("ybcode");
String qq = request.getParameter("qq") == null ? "" : request
.getParameter("qq");
String tel = request.getParameter("tel") == null ? "" : request
.getParameter("tel");
String delstatus = "0";
String savetime = Info.getDateStr();
dao.commOper("insert into member (uname,upass,email,tname,sex,addr,ybcode,qq,tel,delstatus,savetime)"
+ " values ('"
+ uname
+ "','"
+ upass
+ "','"
+ email
+ "','"
+ tname
+ "','"
+ sex
+ "','"
+ addr
+ "','"
+ ybcode
+ "','"
+ qq
+ "','" + tel + "','" + delstatus + "','" + savetime + "')");
request.setAttribute("suc", "注册成功");
go("/reg.jsp", request, response);
String jb = request.getParameter("jb");
String msg = request.getParameter("msg");
String savetime = Info.getDateStr();
HashMap mm = dao.select("select * from goods where id=" + goodid)
.get(0);
dao.commOper("insert into pj (goodid,goodsaver,memberid,jb,msg,savetime,hf) values "
+ "('"
+ goodid
+ "','"
+ mm.get("saver")
+ "','"
+ memberid
+ "','"
+ jb
+ "','"
+ msg
+ "','"
+ savetime
+ "','') ");
request.setAttribute("suc", "商品评价成功!");
go("/mydd.jsp", request, response);
}
// 管理员回复评价
if (ac.equals("pjhf")) {
String id = request.getParameter("id");
String gid = request.getParameter("gid");
String hf = request.getParameter("hf");
dao.commOper("update pj set hf='" + hf + "' where id=" + id);
request.setAttribute("suc", "评价回复成功!");
go("/admin/goodpj.jsp?gid=" + gid, request, response);
}
// 滚动图片
if (ac.equals("imgadvadd")) {
try {
String filename = "";
request.setCharacterEncoding("utf-8");
RequestContext requestContext = new ServletRequestContext(
request);
if (FileUpload.isMultipartContent(requestContext)) {
DiskFileItemFactory factory = new DiskFileItemFactory();
factory.setRepository(new File(request
.getRealPath("/upfile/") + "/"));
ServletFileUpload upload = new ServletFileUpload(factory);
upload.setSizeMax(100 * 1024 * 1024);
List items = new ArrayList();
items = upload.parseRequest(request);
FileItem fileItem = (FileItem) items.get(0);
if (fileItem.getName() != null && fileItem.getSize() != 0) {
request.getRequestDispatcher("/admin/imgadv.jsp").forward(
request, response);
}
}
// 商品品牌
if (ac.equals("ppinfoadd")) {
String ppname = request.getParameter("ppname");
String delstatus = "0";
dao.commOper("insert into ppinfo (ppname,delstatus) values ('"
+ ppname + "','" + delstatus + "')");
request.setAttribute("suc", "操作成功!");
go("/admin/ppinfo.jsp", request, response);
}
// 商品品牌编辑
if (ac.equals("ppinfoedit")) {
String id = request.getParameter("id");
String ppname = request.getParameter("ppname");
dao.commOper("update ppinfo set ppname='" + ppname + "' where id="
+ id);
request.setAttribute("suc", "操作成功!");
go("/admin/ppinfo.jsp", request, response);
}
// 会员收藏商品
if (ac.equals("addfav")) {
String goodid = request.getParameter("goodid");
String page = request.getParameter("page");
if (member == null) {
go("/login.jsp", request, response);
} else {
ArrayList cklist = (ArrayList) dao
.select("select * from fav where memberid='"
+ member.get("id") + "' and goodid='" + goodid
+ "'");
if (cklist.size() == 0) {
dao.commOper("insert into fav (goodid,memberid) values ('"
+ goodid + "','" + member.get("id") + "')");
request.setAttribute("suc", "收藏成功!");
go("/" + page, request, response);
} else {
request.setAttribute("suc", "此商品已收藏过!");
go("/" + page, request, response);
}
}
}
try {
BufferedInputStream bis = null;
BufferedOutputStream bos = null;
OutputStream fos = null;
// File f = new File(request.getRealPath("/upfile/")+"/"+filename);
//System.out.println(f);
bis = new BufferedInputStream((InputStream)new FileInputStream(request.getRealPath("/upfile/")+"/"+filename));
fos = response.getOutputStream();
bos = new BufferedOutputStream(fos);
int bytesRead = 0;
byte[] buffer = new byte[5 * 1024];
while ((bytesRead = bis.read(buffer)) != -1) {
bos.write(buffer, 0, bytesRead);
}
bos.close();
bis.close();
fos.close();
} catch (Exception e) {
e.printStackTrace();
}finally{
}
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occurs
*/
public void init() throws ServletException {
// Put your code here
}
}
dao.commOper("delete from fav where memberid='" + member.get("id")
+ "' and goodid='" + goodid + "'");
request.setAttribute("suc", "取消收藏成功!");
go("/" + page, request, response);
}
// 新增收货地址
if (ac.equals("addradd")) {
String memberid = member.get("id").toString();
String shr = request.getParameter("shr");
String shrtel = request.getParameter("shrtel");
String shraddr = request.getParameter("shraddr");
String delstatus = "0";
dao.commOper("insert into addr (memberid,shr,shrtel,shraddr,delstatus) values "
+ "('"
+ memberid
+ "','"
+ shr
+ "','"
+ shrtel
+ "','"
+ shraddr + "','" + delstatus + "') ");
request.setAttribute("suc", "操作成功!");
go("/addr.jsp", request, response);
}
// 检查用户名唯一性AJAX 系统用户
if (ac.equals("usernamecheck")) {
String username = request.getParameter("username");
ArrayList cklist = (ArrayList) dao
.select("select * from sysuser where username='" + username
+ "' and delstatus='0' ");
if (cklist.size() > 0) {
out.print("false");
} else {
out.print("true");
}
}
if (ac.equals("useradd")) {
String username = request.getParameter("username");
String userpwd = request.getParameter("userpwd");
String email = request.getParameter("email") == null ? "" : request
.getParameter("email");
String num = request.getParameter("num");
String type = request.getParameter("type");
String reason = request.getParameter("reason");
String savetime = Info.getDateStr();
dao.commOper("insert into kcrecord (pid,num,type,reason,savetime) values"
+ " ('"
+ pid
+ "','"
+ Integer.parseInt(num)
+ "','"
+ type + "','" + reason + "','" + savetime + "') ");
request.setAttribute("suc", "");
go("/admin/kcinto.jsp", request, response);
}
// 商品出库
if (ac.equals("kcout")) {
String pid = request.getParameter("pid");
String num = request.getParameter("num");
String type = request.getParameter("type");
String reason = request.getParameter("reason");
String savetime = Info.getDateStr();
int znum = 0;
int innum = 0;
int outnum = 0;
ArrayList<HashMap> inlist = (ArrayList<HashMap>) dao
.select("select * from kcrecord where type='in' and pid='"
+ pid + "' ");
ArrayList<HashMap> outlist = (ArrayList<HashMap>) dao
.select("select * from kcrecord where type='out' and pid='"
+ pid + "' ");
if (inlist.size() > 0) {
for (HashMap inmap : inlist) {
innum += Integer.parseInt(inmap.get("num").toString());// 总入库量
}
}
if (outlist.size() > 0) {
for (HashMap outmap : outlist) {
outnum += Integer.parseInt(outmap.get("num").toString());// 总出库量
}
}
// 默认一页最大记录数
public static final int DEFAULTPAGESIZE = 20;
// 分页段
public static final int segment = 10;
// 当前页数
protected int currentPage;
// 一页长度
protected int pageSize;
// 总页数
protected long pageNumber;
// 总记录数
protected long count;
// 数据
protected Collection collection;
// 数据查询对象
protected CommDAO dao = new CommDAO();
// 表现层代码
protected String info;
// 请求路径
protected String path;
// 服务器请求对象
protected HttpServletRequest request;
/*
* 仅仅只是加到路径中去
*/
protected String parameter = "";
/**
*
* @param 下一页的分页链接
* @param 一页最大记录数
* @param 当前HttpServletRequest对象
* @param 数据库操作对象
*/
protected PageManager(String path, int pageSize, HttpServletRequest request) {
+ map.get("typename") + "</text></select>";
}
}
String last_xml = xml_start + xml + xml_end;
response.setContentType("text/xml;charset=GB2312");
response.setCharacterEncoding("utf-8");
response.getWriter().write(last_xml);
response.getWriter().flush();
}
// 公用方法,图片上传
if (ac.equals("uploadimg")) {
try {
String filename = "";
request.setCharacterEncoding("utf-8");
RequestContext requestContext = new ServletRequestContext(
request);
if (FileUpload.isMultipartContent(requestContext)) {
DiskFileItemFactory factory = new DiskFileItemFactory();
factory.setRepository(new File(request
.getRealPath("/upfile/") + "/"));
ServletFileUpload upload = new ServletFileUpload(factory);
upload.setSizeMax(100 * 1024 * 1024);
List items = new ArrayList();
items = upload.parseRequest(request);
FileItem fileItem = (FileItem) items.get(0);
if (fileItem.getName() != null && fileItem.getSize() != 0) {
if (fileItem.getName() != null
&& fileItem.getSize() != 0) {
File fullFile = new File(fileItem.getName());
filename = Info.generalFileName(fullFile.getName());
File newFile = new File(
request.getRealPath("/upfile/") + "/"
+ filename);
try {
fileItem.write(newFile);
} catch (Exception e) {
e.printStackTrace();
}
if (gmap.get("tprice") != null
&& !gmap.get("tprice").equals("")) {
price = gmap.get("tprice").toString();
}
ddprice = Double.valueOf(price) * sl;
// 直接生成订单
dao.commOper("insert into ddinfo (ddno,memberid,ddprice,fhstatus,savetime,shstatus,wlinfo,fkstatus,shrname,shrtel,shraddr) values "
+ "('"
+ ddno
+ "','"
+ memberid
+ "','"
+ ddprice
+ "','"
+ fhstatus
+ "','"
+ savetime
+ "','"
+ shstatus
+ "','"
+ wlinfo
+ "','"
+ fkstatus
+ "','"
+ shrname + "','" + shrtel + "','" + shraddr + "')");
dao.commOper("insert into dddetail (ddno,goodid,sl) values ('"
+ ddno + "','" + gid + "','" + sl + "') ");
out.print("true");
}
} else {
out.print("false");
}
// request.setAttribute("suc", "");
// go("/tocar.jsp?gid="+gid, request, response);
}
// 购物车内商品数量修改
if (ac.equals("updatecart")) {
String id = request.getParameter("carid");
int sl = Integer.valueOf(request.getParameter("sl"));
dao.commOper("update car set sl=" + sl + " where id=" + id);
out.print("true");
}
done=false;
}
}
else{
end=end+to.length();
subLowcase2=sourceLowcase.substring(end,source.length());
sub2=source.substring(end,source.length());
sourceLowcase=subLowcase1+subLowcase2;
source=sub1+sub2;
}
//System.out.println(start+" "+end);
}
return source.replaceAll(" ", "");
}
public static void delPic(String path,String img)
{
if(img!=null)
{
if(!img.equals(""))
{
File file1=new File(path + "/" + img);
if(file1.exists() ) {
file1.deleteOnExit();
// file1.delete();
}}}
}
public static void writeExcel(String fileName,String[] pros,java.util.List<HashMap> list,HttpServletRequest request, HttpServletResponse response){
WritableWorkbook wwb = null;
try {
//首先要使用Workbook类的工厂方法创建一个可写入的工作薄(Workbook)对象
wwb = Workbook.createWorkbook(new File(fileName));
} catch (IOException e) {
e.printStackTrace();
}
if(wwb!=null){
//创建一个可写入的工作表
//Workbook的createSheet方法有两个参数,第一个是工作表的名称,第二个是工作表在工作薄中的位置
WritableSheet ws = wwb.createSheet("sheet1", 0);
try {
/**
* 比较时间大小
*
*/
public static String compare_datezq(String DATE1, String DATE2) {
DateFormat df = new SimpleDateFormat("yyyy-MM-dd");
try {
Date dt1 = df.parse(DATE1);
Date dt2 = df.parse(DATE2);
if (dt1.getTime() > dt2.getTime()) {
return "big";
} else if (dt1.getTime() < dt2.getTime()) {
return "small";
} else {
return "den";
}
} catch (Exception exception) {
exception.printStackTrace();
}
return "den";
}
/**
* 过滤html代码
*
*/
public static String filterStrIgnoreCase(String source, String from, String to){
String sourceLowcase=source.toLowerCase();
String sub1,sub2,subLowcase1,subLowcase2;
sub1=sub2=subLowcase1=subLowcase2="";
int start=0,end;
boolean done=true;
if(source==null) return null;
if(from==null||from.equals("")||to==null||to.equals(""))
return source;
while(done){
start=sourceLowcase.indexOf(from,start);
if(start==-1) {
break;
}
String savetime = Info.getDateStr();
String memberid = member.get("id").toString();
dao.commOper("insert into chat (msg,hfmsg,savetime,memberid) values "
+ "('"
+ msg
+ "','"
+ hfmsg
+ "','"
+ savetime
+ "','"
+ memberid + "')");
request.setAttribute("suc", "留言成功!");
go("/msg.jsp", request, response);
}
if (ac.equals("msghf")) {
String id = request.getParameter("id");
String hfmsg = request.getParameter("hfmsg");
dao.commOper("update chat set hfmsg='" + hfmsg + "' where id="
+ id);
request.setAttribute("suc", "回复成功!");
go("/admin/msglist.jsp", request, response);
}
if (ac.equals("goodstjset")) {
String id = request.getParameter("id");
String tprice = request.getParameter("tprice") == null ? ""
: request.getParameter("tprice");
if (!tprice.equals("")) {
HashMap map = dao.select("select * from goods where id=" + id)
.get(0);
if (Double.valueOf(tprice) >= Double.valueOf(map.get("price")
.toString())) {
request.setAttribute("info", "特价必须低于原价!");
go("/admin/goodstjset.jsp?id=" + id, request, response);
} else {
dao.commOper("update goods set tprice='" + tprice
+ "' where id=" + id);
request.setAttribute("suc", "特价设置成功!");
go("/admin/goodsgl.jsp", request, response);
}
} else {
dao.commOper("update goods set tprice='' where id=" + id);
request.setAttribute("info", "特价已取消!");
go("/admin/goodsgl.jsp", request, response);
}
}
out.flush();
out.close();
}
e1.printStackTrace();
request.setAttribute("error", "");
request.getRequestDispatcher("/admin/goodsgl.jsp").forward(
request, response);
}
}
// 商品入库
if (ac.equals("goodskcadd")) {
String gid = request.getParameter("gid");
String happennum = request.getParameter("happennum");
String type = "in";
String savetime = Info.getDateStr();
dao.commOper("insert into kcrecord (gid,happennum,type,savetime) values "
+ "('"
+ gid
+ "','"
+ happennum
+ "','"
+ type
+ "','"
+ savetime + "') ");
request.setAttribute("suc", "操作成功!");
go("/admin/goodskc.jsp", request, response);
}
// 商品评论
if (ac.equals("goodpj")) {
String goodid = request.getParameter("id");
String memberid = member.get("id").toString();
String note = request.getParameter("note");
String savetime = Info.getDateStr();
dao.commOper("insert into goodspj (goodid,memberid,note,savetime) values ('"
+ goodid
+ "','"
+ memberid
+ "','"
+ note
+ "','"
+ savetime + "')");
request.setAttribute("suc", "");
go("/goodsx.jsp?id=" + goodid, request, response);
}
+ "','"
+ username
+ "','"
+ userpwd
+ "','"
+ realname
+ "','"
+ sex
+ "','"
+ idcard
+ "','"
+ tel
+ "','"
+ email
+ "','"
+ addr
+ "','"
+ delstatus
+ "','"
+ savetime + "')");
request.setAttribute("suc", "");
go("/admin/sysuseradd.jsp", request, response);
}
// 编辑管理员
if (ac.equals("sysuseredit")) {
String id = request.getParameter("id");
String userpwd = request.getParameter("userpwd");
String realname = request.getParameter("realname");
String sex = request.getParameter("sex");
String idcard = request.getParameter("idcard");
String tel = request.getParameter("tel");
String email = request.getParameter("email");
String addr = request.getParameter("addr");
dao.commOper("update sysuser set userpwd='" + userpwd
+ "',realname='" + realname + "',sex='" + sex
+ "',idcard='" + idcard + "',tel='" + tel + "',email='"
+ email + "',addr='" + addr + "' where id=" + id);
request.setAttribute("suc", "");
go("/admin/sysuseredit.jsp?id=" + id, request, response);
}
// 商品类别新增
if (ac.equals("protypeadd")) {
String typename = request.getParameter("typename");
String fatherid = request.getParameter("fatherid");
dao.commOper("insert into protype (typename,fatherid,delstatus) values ('"
+ typename + "','" + fatherid + "','0') ");
request.setAttribute("suc", "操作成功!");
go("/admin/protype.jsp", request, response);
}
// 商品类别编辑
if (ac.equals("protypeedit")) {