基于javaweb+mysql的jsp+servlet球队nba及其周边商城系统(java+jdbc+servlet+jsp+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的JSP+Servlet球队nba及其周边商城系统(java+jdbc+servlet+jsp+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配置文件中的数据库配置改为自己的配置;
-
运行项目,输入localhost:8080/jsp_zhctms_site 登录 注:tomcat中配置项目路径必须为jsp_zhctms_site
用户账号/密码: user/123456
管理员账号/密码:admin/admin
+ "',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");
dao.commOper("update protype set typename='" + typename
+ "' where id=" + id);
request.setAttribute("suc", "操作成功!");
go("/admin/protype.jsp?id=" + id, request, response);
}
// 商品属性新增
if (ac.equals("propertyadd")) {
String propertyname = request.getParameter("propertyname");
dao.commOper("insert into property (propertyname,delstatus) values ('"
+ propertyname + "','0') ");
request.setAttribute("suc", "");
go("/admin/propertyadd.jsp", request, response);
}
// 商品属性编辑
if (ac.equals("propertyedit")) {
String id = request.getParameter("id");
String propertyname = request.getParameter("propertyname");
dao.commOper("update property set propertyname='" + propertyname
+ "' where id=" + id);
request.setAttribute("suc", "");
go("/admin/propertyedit.jsp?id=" + id, request, response);
}
// AJAX根据父类查子类
if (ac.equals("searchsontype")) {
String xml_start = "<selects>";
String xml_end = "</selects>";
String xml = "";
public void go(String url, HttpServletRequest request,
HttpServletResponse response) {
try {
request.getRequestDispatcher(url).forward(request, response);
} catch (ServletException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
public void gor(String url, HttpServletRequest request,
HttpServletResponse response) {
try {
response.sendRedirect(url);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
HttpSession session = request.getSession();
HashMap admin = (HashMap) session.getAttribute("admin");
HashMap member = (HashMap) session.getAttribute("member");
String ac = request.getParameter("ac");
if (ac == null)
ac = "";
CommDAO dao = new CommDAO();
String date = Info.getDateStr();
String today = date.substring(0, 10);
String tomonth = date.substring(0, 7);
// 登录
if (ac.equals("login")) {
String username = request.getParameter("username");
String userpwd = request.getParameter("userpwd");
String sql = "select * from sysuser where username='" + username
+ "' and userpwd='" + userpwd
+ "' and usertype in ('管理员') ";
List<HashMap> list = dao.select(sql);
if (list.size() == 1) {
session.setAttribute("admin", list.get(0));
gor("/jsp_nbashop/admin/index.jsp", request, response);
} else {
e.printStackTrace();
}
}
}
public static String getImgUpInfo2(int height)
{
String jscode = "";
jscode+="<img style=\"cursor: hand\" οnclick=\"uploadimg()\" src=\"/jsp_nbashop/js/nopic.jpg\" id=txt height=\""+height+"\"/>";
jscode+="<input type=hidden name=\"filename\" id=\"filename\" value=\"\" />";
return jscode;
}
public static int getkc(String gid){
CommDAO dao = new CommDAO();
int znum = 0;
int innum = 0;
int outnum = 0;
ArrayList<HashMap> inlist = (ArrayList<HashMap>)dao.select("select * from kcrecord where type='in' and gid='"+gid+"' ");
ArrayList<HashMap> outlist = (ArrayList<HashMap>)dao.select("select * from kcrecord where type='out' and gid='"+gid+"' ");
if(inlist.size()>0){
for(HashMap inmap:inlist){
innum += Integer.parseInt(inmap.get("happennum").toString());//总入库量
}
}
if(outlist.size()>0){
for(HashMap outmap:outlist){
outnum += Integer.parseInt(outmap.get("happennum").toString());//总出库量
}
}
znum = innum - outnum;//库存量
return znum;
}
}
if (this.count != 0) {
this.pageNumber = count % this.pageSize == 0 ? this.count
/ this.pageSize : this.count / this.pageSize + 1;
if (this.currentPage > this.pageNumber)
this.currentPage = (int) this.pageNumber;
}
this.request.getSession().setAttribute("currentPage",
String.valueOf(this.currentPage));
this.collection = this.dao.select(hql,
this.currentPage , this.pageSize);
this.refreshUrl();
}
/**
*
* @param 查询条件集合
* 如没有条件只是列表就不使用这个方法
*/
public void addParameter(List parameter) {
StringBuffer para = new StringBuffer("");
if (parameter != null && parameter.size() != 0) {
Iterator iterator = parameter.iterator();
while (iterator.hasNext()) {
para.append("&").append(iterator.next().toString());
}
}
this.parameter = para.toString();
}
/**
* 刷新分页路径
*
*/
protected void refreshUrl() {
StringBuffer buf = new StringBuffer();
buf.append("<font color='#1157B7'>共").append(count);
buf.append("条");
buf.append(" ");
buf.append("第").append(this.currentPage).append("/").append(
this.pageNumber).append("页");
buf.append(" ");
if (this.currentPage == 1)
buf.append("首页");
else
buf.append("<a href='").append(this.path).append("¤tPage=1")
.append(parameter)
.append("' class='ls'>").append("首页")
.append("</a>");
// #1157B7
+ "','" + Info.getDateStr() + "','新闻')";
dao.commOper(sql);
request.setAttribute("suc", "操作成功!");
go("/admin/newslist.jsp", request, response);
} catch (Exception e1) {
e1.printStackTrace();
request.setAttribute("error", "");
request.getRequestDispatcher("/admin/newsadd.jsp").forward(
request, response);
}
}
// 编辑新闻
if (ac.equals("newsedit")) {
String id = request.getParameter("id");
HashMap map = dao.select("select * from news where id=" + id)
.get(0);
try {
String title = "";
String note = "";
String img = map.get("img").toString();
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);
title = ((FileItem) items.get(0)).getString();
title = Info.getUTFStr(title);
note = ((FileItem) items.get(2)).getString();
note = Info.getUTFStr(note);
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
StringBuffer sb = new StringBuffer(50);
response.setContentType("application/x-msdownload;charset=utf-8");
try {
response.setHeader("Content-Disposition", new String(sb.toString()
.getBytes(), "ISO8859-1"));
} catch (UnsupportedEncodingException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
String filename = request.getParameter("filename");
if (request.getHeader("User-Agent").toLowerCase().indexOf("firefox") > 0){
try {
filename = new String(filename.getBytes("UTF-8"), "ISO8859-1");
} catch (UnsupportedEncodingException e) {
// TODO Auto-generated catch block
}
}
String sql = "update siteinfo set tel='" + tel + "',addr='"
+ addr + "',note='" + note + "',logoimg='" + logoimg
+ "' where id=" + id;
dao.commOper(sql);
request.setAttribute("suc", "");
go("/admin/siteinfo.jsp?id=" + id, request, response);
} catch (Exception e1) {
e1.printStackTrace();
request.setAttribute("error", "");
request.getRequestDispatcher("/admin/siteinfo.jsp?id=" + id)
.forward(request, response);
}
}
// 检查用户名唯一性AJAX
if (ac.equals("sysuserscheck")) {
String username = request.getParameter("username");
ArrayList cklist = (ArrayList) dao
.select("select * from sysuser where username='" + username
+ "' and delstatus='0' ");
if (cklist.size() > 0) {
out.write("1");
} else {
out.write("0");
}
}
// 新增管理员
if (ac.equals("sysuseradd")) {
String usertype = "管理员";
String username = request.getParameter("username");
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");
String delstatus = "0";
String savetime = Info.getDateStr();
dao.commOper("insert into goods (goodno,goodname,fid,sid,price,note,savetime,shstatus,filename,istj,tprice,delstatus,salestatus,goodpp) "
+ "values ('"
+ goodno
+ "','"
+ goodname
+ "','"
+ fid
+ "','"
+ sid
+ "','"
+ price
+ "','"
+ note
+ "','"
+ savetime
+ "','通过','"
+ filename
+ "','"
+ istj
+ "','"
+ tprice
+ "','0','在售','" + goodpp + "') ");
request.setAttribute("suc", "操作成功!");
go("/admin/goodsgl.jsp", request, response);
} catch (Exception e1) {
e1.printStackTrace();
request.setAttribute("error", "");
request.getRequestDispatcher("/admin/goodsgl.jsp").forward(
request, response);
}
}
// 会员修改商品
if (ac.equals("goodsedit")) {
String id = request.getParameter("id");
HashMap map = dao.select("select * from goods where id=" + id).get(
0);
try {
String goodname = "";
String fid = "";
String sid = "";
String goodpp = "";
String price = "";
String note = "";
String filename = map.get("filename").toString();
/**
* 过滤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;
}
subLowcase1=sourceLowcase.substring(0,start);
sub1=source.substring(0,start);
end=sourceLowcase.indexOf(to,start);
if(end==-1){
end=sourceLowcase.indexOf("/>",start);
if(end==-1) {
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();
: 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);
}
// 会员修改个人信息
if (ac.equals("memberinfo")) {
String id = request.getParameter("id");
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 ? ""
String.valueOf(this.currentPage));
this.collection = this.dao.select(hql,
this.currentPage , this.pageSize);
this.refreshUrl();
}
/**
*
* @param 查询条件集合
* 如没有条件只是列表就不使用这个方法
*/
public void addParameter(List parameter) {
StringBuffer para = new StringBuffer("");
if (parameter != null && parameter.size() != 0) {
Iterator iterator = parameter.iterator();
while (iterator.hasNext()) {
para.append("&").append(iterator.next().toString());
}
}
this.parameter = para.toString();
}
/**
* 刷新分页路径
*
*/
protected void refreshUrl() {
StringBuffer buf = new StringBuffer();
buf.append("<font color='#1157B7'>共").append(count);
buf.append("条");
buf.append(" ");
buf.append("第").append(this.currentPage).append("/").append(
this.pageNumber).append("页");
buf.append(" ");
if (this.currentPage == 1)
buf.append("首页");
else
buf.append("<a href='").append(this.path).append("¤tPage=1")
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);
}
}
}
// 取消收藏
if (ac.equals("delfav")) {
String goodid = request.getParameter("goodid");
String page = request.getParameter("page");
dao.commOper("delete from fav where memberid='" + member.get("id")
+ "' and goodid='" + goodid + "'");
request.setAttribute("suc", "取消收藏成功!");
go("/" + page, request, response);
}
e.printStackTrace();
}
}
response.setContentType("text/plain");
response.setHeader("Location",filename);
response.reset();
response.setHeader("Cache-Control", "max-age=0" );
response.setHeader("Content-Disposition", "attachment; filename=" + filename);
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 {
go("/admin/imgadvadd.jsp", request, response);
}
} catch (Exception e1) {
e1.printStackTrace();
request.setAttribute("no", "");
request.getRequestDispatcher("/admin/imgadvadd.jsp").forward(
request, response);
}
}
// 编辑图片
if (ac.equals("imgadvedit")) {
String id = request.getParameter("id");
HashMap map = dao.select("select * from imgadv where id=" + id)
.get(0);
try {
String img = map.get("filename").toString();
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());
img = Info.generalFileName(fullFile.getName());
File newFile = new File(
request.getRealPath("/upfile/") + "/" + img);
try {
fileItem.write(newFile);
} catch (Exception e) {
e.printStackTrace();
}
} else {
}
}
}
String sql = "update imgadv set filename='" + img
} 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;
}
subLowcase1=sourceLowcase.substring(0,start);
sub1=source.substring(0,start);
end=sourceLowcase.indexOf(to,start);
if(end==-1){
end=sourceLowcase.indexOf("/>",start);
if(end==-1) {
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);
}
// request.setAttribute("suc", "");
// go("/tocar.jsp?gid="+gid, request, response);
}
// 直接购买
if (ac.equals("tobuy")) {
String gid = request.getParameter("gid");
int sl = Integer.valueOf(request.getParameter("sl"));
String ddno = Info.getAutoNo();
String shrname = "";
String shrtel = "";
String shraddr = request.getParameter("addr");
double ddprice = 0.0;
String fhstatus = "待发货";
String shstatus = "待收货";
String fkstatus = "待付款";
String wlinfo = "暂无物流信息";
String savetime = Info.getDateStr();
if (member != null) {
String memberid = member.get("id").toString();
ArrayList<HashMap> addrlist = (ArrayList<HashMap>) dao
.select("select * from addr where delstatus='0' and memberid="
+ member.get("id"));
if (addrlist.size() == 0) {
out.print("false");
} else {
shraddr = addrlist.get(0).get("id").toString();
HashMap gmap = dao.select(
"select * from goods where id=" + gid).get(0);
String price = gmap.get("price").toString();
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
+ "','"
response.setContentType("text/html");
PrintWriter out = response.getWriter();
HttpSession session = request.getSession();
HashMap admin = (HashMap) session.getAttribute("admin");
HashMap member = (HashMap) session.getAttribute("member");
String ac = request.getParameter("ac");
if (ac == null)
ac = "";
CommDAO dao = new CommDAO();
String date = Info.getDateStr();
String today = date.substring(0, 10);
String tomonth = date.substring(0, 7);
// 登录
if (ac.equals("login")) {
String username = request.getParameter("username");
String userpwd = request.getParameter("userpwd");
String sql = "select * from sysuser where username='" + username
+ "' and userpwd='" + userpwd
+ "' and usertype in ('管理员') ";
List<HashMap> list = dao.select(sql);
if (list.size() == 1) {
session.setAttribute("admin", list.get(0));
gor("/jsp_nbashop/admin/index.jsp", request, response);
} else {
request.setAttribute("error", "");
go("admin/login.jsp", request, response);
}
}
// 后台退出
if (ac.equals("backexit")) {
session.removeAttribute("admin");
go("admin/login.jsp", request, response);
}
// 新增新闻
if (ac.equals("newsadd")) {
try {
String title = "";
String img = "";
String note = "";
request.setCharacterEncoding("utf-8");
RequestContext requestContext = new ServletRequestContext(
request);
if (FileUpload.isMultipartContent(requestContext)) {
DiskFileItemFactory factory = new DiskFileItemFactory();
factory.setRepository(new File(request
.getRealPath("/upfile/") + "/"));
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);
}
}
}
// 取消收藏
if (ac.equals("delfav")) {
String goodid = request.getParameter("goodid");
String page = request.getParameter("page");
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