jsp + servlet seckill and bidding auction system based on javaweb + mysql (java + jsp + bootstrap + jquery + mysql)
operating environment
Java≥8, MySQL≥5.7, Tomcat≥8
development tools
eclipse/idea/myeclipse/sts can be configured to run
Be applicable
Course design, major assignments, graduation design, project exercises, learning presentations, etc.
Function Description
JSP + Servlet seckill and bidding auction system based on javaweb + mysql (java + jsp + bootstrap + jquery + mysql)
Project Introduction
The B2C-based online auction system is mainly used to help people use the Internet to buy their favorite commodities conveniently and quickly, and participate in flash sales and auctions.
The main functions include: 1. Foreground module (1) Login/registration of ordinary users. (2) View products by category (common products and promotional products) (3) View product details (4) View flash sale products (5) View auction products (6) Add products to the shopping cart (7) Purchase, settlement function (8) Message 2. Background module (1) Change password (2) Commodity management: edit/delete setting/cancel promotion (3) Lightning flash product: setting/cancelling flash sale (4) Bidding product: setting/cancelling bidding (5) Order management: view Order (6) message management: view/delete messages
environmental needs
1. Operating environment: preferably java jdk 1.8, we run on this platform. Other versions are also theoretically possible. 2. IDE environment: IDEA, Eclipse, Myeclipse are all available. IDEA is recommended; 3. Tomcat environment: Tomcat 7.x, 8.x, 9.x versions are all available 4. Hardware environment: windows 7/8/10 with 1G memory or more; or Mac OS; 5. Maven project or not: No; Check whether pom.xml is included in the source code directory; if it is included, it is a maven project, otherwise it is a non-maven project 6. Database: MySql 5.7 version;
technology stack
- Backend: Servlet 2. Frontend: JSP + bootstrap + jQuery
Instructions for use
- Use Navicat or other tools to create a database with the corresponding name in mysql, and import the sql file of the project; 2. Change the database configuration in the resources/ioc/dao.js configuration file in the project to your own configuration; 3. Use IDEA /Eclipse/MyEclipse import project, when Eclipse/MyEclipse imports, if it is a maven project, please select maven; if it is a maven project, please execute the maven clean;maven install command after the import is successful, configure tomcat, and then run; 4. Project access path: Foreground: http://localhost:8080/sale Background: http://localhost:8080/sale/user/adminlogin
pagerNum = "1";
}
List<Product> list = productService. findListProduct();
request.setAttribute("count", list.size());
request.setAttribute("maxPager", PagerUtil.getMaxPager(list.size()));
list = (List<Product>) PagerUtil. getPager(list,
Integer. parseInt(pagerNum));
request.setAttribute("list", list);
request.setAttribute("pagerNum", pagerNum);
return new JspView("jsp.admin.product.list");
}
@At("/qxcx")
public View qxcx(HttpServletRequest request) {<!-- -->
String id = request. getParameter("id");
Product product = productService. findProductById(Integer. parseInt(id));
product.setSfcx(0);
product.setNewprice(null);
int i = productService. editProduct(product);
if (i == 1) {<!-- -->
request.setAttribute("msg", "Modified successfully");
} else {<!-- -->
request.setAttribute("msg", "Failed to modify");
}
// ****
String pagerNum = request. getParameter("pagerNum");
if (pagerNum == null) {<!-- -->
pagerNum = "1";
}
List<Product> list = productService. findListProduct();
request.setAttribute("count", list.size());
request.setAttribute("maxPager", PagerUtil.getMaxPager(list.size()));
list = (List<Product>) PagerUtil. getPager(list,
Integer. parseInt(pagerNum));
request.setAttribute("list", list);
request.setAttribute("pagerNum", pagerNum);
return new JspView("jsp.admin.product.list");
}
// seckill start ************************************************* ****
product.setJpdate(time);
int i = productService. editProduct(product);
if (i == 1) {<!-- -->
request.setAttribute("msg", "Modified successfully");
} else {<!-- -->
request.setAttribute("msg", "Failed to modify");
}
String pagerNum = request. getParameter("pagerNum");
if (pagerNum == null) {<!-- -->
pagerNum = "1";
}
List<Product> list = productService. findListSpike();
request.setAttribute("count", list.size());
request.setAttribute("maxPager", PagerUtil.getMaxPager(list.size()));
list = (List<Product>) PagerUtil. getPager(list,
Integer. parseInt(pagerNum));
request.setAttribute("list", list);
request.setAttribute("pagerNum", pagerNum);
return new JspView("jsp.admin.product.promolist");
}
@At("/qxjp")
public View qxjp(HttpServletRequest request) {<!-- -->
String id = request. getParameter("id");
Product product = productService. findProductById(Integer. parseInt(id));
product.setSfjp(0);
product.setQpprice(null);
product.setJpdate(null);
product.setJpprice(null);
int i = productService. editProduct(product);
if (i == 1) {<!-- -->
request.setAttribute("msg", "Modified successfully");
} else {<!-- -->
request.setAttribute("msg", "Failed to modify");
}
// ****
String pagerNum = request. getParameter("pagerNum");
if (pagerNum == null) {<!-- -->
orderService. deleteOrder(Integer. parseInt(id));
//**
User user = (User)request.getSession().getAttribute("user");
List<Order> list = orderService.getCartList(user.getId());
request.setAttribute("list", list);
int sumprice = 0;
for(int i=0;i<list. size();i ++ ){<!-- -->
list.get(i).setUser(userService.findUserById(list.get(i).getUserid()));
list.get(i).setProduct(productService.findProductById(list.get(i).getProid()));
if(sumprice==0){<!-- -->
sumprice = Integer. parseInt(list. get(i). getPrice());
}else{<!-- -->
sumprice + = Integer.parseInt(list.get(i).getPrice());
}
}
request.setAttribute("sumprice", sumprice);
request.setAttribute("count", list.size());
return new JspView("jsp. cart");
}
/**
* Go to the checkout page
*/
@At("/tocheckout")
public View to checkout(HttpServletRequest request){<!-- -->
String price = request. getParameter("price");
request.setAttribute("price", price);
return new JspView("jsp. checkout");
}
/**
* Go to the payment interface
*/
@At("/topay")
public View topay(HttpServletRequest request){<!-- -->
String price = request. getParameter("price");
DateFormat df = new SimpleDateFormat("yyyy-MM-dd");
String tel = request. getParameter("tel");
String address = request. getParameter("address");
String senddept = request. getParameter("senddept");
User user = (User)request.getSession().getAttribute("user");
List<Order> list = orderService.getCartList(user.getId());
Order order = new Order();
for(int i=0;i<list. size();i ++ ){<!-- -->
* @return
*/
@At("/toDetail")
public View toDetail(HttpServletRequest request){<!-- -->
String id = request. getParameter("id");
Product product = productService. findProductById(Integer. parseInt(id));
//New product launch
List<Product> newlist = productService. findNewProduct();
request.setAttribute("newlist", newlist);
request.setAttribute("product", product);
return new JspView("jsp.detail");
}
/**
* Jump to promotional product details
* @param request
* @return
*/
@At("/tocxDetail")
public View tocxDetail(HttpServletRequest request){<!-- -->
String id = request. getParameter("id");
Product product = productService. findProductById(Integer. parseInt(id));
//Promotion
List<Product> cxlist = productService. findCxProduct();
request.setAttribute("cxlist", cxlist);
request.setAttribute("product", product);
return new JspView("jsp.cxdetail");
}
/**
* Skip to the seckill product details
* @param request
* @return
*/
@At("/tomsDetail")
public View tomsDetail(HttpServletRequest request){<!-- -->
String id = request. getParameter("id");
Product product = productService. findProductById(Integer. parseInt(id));
//Promotion
List<Product> cxlist = productService. findCxProduct();
request.setAttribute("cxlist", cxlist);
request.setAttribute("product", product);
\t\t
Calendar c = Calendar. getInstance();
public View promolist(HttpServletRequest request) {<!-- -->
String pagerNum = request. getParameter("pagerNum");
if (pagerNum == null) {<!-- -->
pagerNum = "1";
}
List<Product> list = productService. findListPromo();
request.setAttribute("count", list.size());
request.setAttribute("maxPager", PagerUtil.getMaxPager(list.size()));
list = (List<Product>) PagerUtil. getPager(list,
Integer. parseInt(pagerNum));
request.setAttribute("list", list);
request.setAttribute("pagerNum", pagerNum);
return new JspView("jsp.admin.product.promolist");
}
@At("/toszjp")
public View toszjp(HttpServletRequest request) {<!-- -->
String id = request. getParameter("id");
Product product = productService. findProductById(Integer. parseInt(id));
request.setAttribute("product", product);
return new JspView("jsp.admin.product.szjp");
}
@At("/szjp")
public View szjp(HttpServletRequest request) {<!-- -->
String id = request. getParameter("id");
Product product = productService. findProductById(Integer. parseInt(id));
String price = request. getParameter("price");
String time = request. getParameter("time");
product.setSfjp(1);
product.setJpprice(price);
product.setJpdate(time);
int i = productService. editProduct(product);
if (i == 1) {<!-- -->
request.setAttribute("msg", "Modified successfully");
} else {<!-- -->
request.setAttribute("msg", "Failed to modify");
}
String pagerNum = request. getParameter("pagerNum");
if (pagerNum == null) {<!-- -->
pagerNum = "1";
request.setAttribute("maxPager", PagerUtil.getMaxPager(list.size()));
list = (List<Product>) PagerUtil. getPager(list,
Integer. parseInt(pagerNum));
request.setAttribute("list", list);
request.setAttribute("pagerNum", pagerNum);
return new JspView("jsp.admin.product.spikelist");
}
// seckill end ************************************************* ****
// Auction starts *********************************************** ****
/**
* Auction list
*
* @param request
* @return
*/
@At("/promolist")
public View promolist(HttpServletRequest request) {<!-- -->
String pagerNum = request. getParameter("pagerNum");
if (pagerNum == null) {<!-- -->
pagerNum = "1";
}
List<Product> list = productService. findListPromo();
request.setAttribute("count", list.size());
request.setAttribute("maxPager", PagerUtil.getMaxPager(list.size()));
list = (List<Product>) PagerUtil. getPager(list,
Integer. parseInt(pagerNum));
request.setAttribute("list", list);
request.setAttribute("pagerNum", pagerNum);
return new JspView("jsp.admin.product.promolist");
}
@At("/toszjp")
public View toszjp(HttpServletRequest request) {<!-- -->
String id = request. getParameter("id");
Product product = productService. findProductById(Integer. parseInt(id));
request.setAttribute("product", product);
return new JspView("jsp.admin.product.szjp");
}
@At("/szjp")
public View szjp(HttpServletRequest request) {<!-- -->
String id = request. getParameter("id");
Product product = productService. findProductById(Integer. parseInt(id));
String price = request. getParameter("price");
public View toszcx(HttpServletRequest request) {<!-- -->
String id = request. getParameter("id");
Product product = productService. findProductById(Integer. parseInt(id));
request.setAttribute("product", product);
return new JspView("jsp.admin.product.szcx");
}
@At("/szcx")
public View szcx(HttpServletRequest request) {<!-- -->
String id = request. getParameter("id");
String newprice = request. getParameter("newprice");
Product product = productService. findProductById(Integer. parseInt(id));
product.setNewprice(newprice);
product.setSfcx(1);
int i = productService. editProduct(product);
if (i == 1) {<!-- -->
request.setAttribute("msg", "Modified successfully");
} else {<!-- -->
request.setAttribute("msg", "Failed to modify");
}
// ****
String pagerNum = request. getParameter("pagerNum");
if (pagerNum == null) {<!-- -->
pagerNum = "1";
}
List<Product> list = productService. findListProduct();
request.setAttribute("count", list.size());
request.setAttribute("maxPager", PagerUtil.getMaxPager(list.size()));
list = (List<Product>) PagerUtil. getPager(list,
Integer. parseInt(pagerNum));
request.setAttribute("list", list);
request.setAttribute("pagerNum", pagerNum);
return new JspView("jsp.admin.product.list");
}
@At("/qxcx")
public View qxcx(HttpServletRequest request) {<!-- -->
String id = request. getParameter("id");
Product product = productService. findProductById(Integer. parseInt(id));
product.setSfcx(0);
product.setNewprice(null);
int i = productService. editProduct(product);
if (i == 1) {<!-- -->
request.setAttribute("msg", "Modified successfully");
} else {<!-- -->
request.setAttribute("msg", "Failed to modify");
}
list = (List<Product>) PagerUtil. getPager(list,
Integer. parseInt(pagerNum));
request.setAttribute("list", list);
request.setAttribute("pagerNum", pagerNum);
return new JspView("jsp.admin.product.promolist");
}
@At("/toszjp")
public View toszjp(HttpServletRequest request) {<!-- -->
String id = request. getParameter("id");
Product product = productService. findProductById(Integer. parseInt(id));
request.setAttribute("product", product);
return new JspView("jsp.admin.product.szjp");
}
@At("/szjp")
public View szjp(HttpServletRequest request) {<!-- -->
String id = request. getParameter("id");
Product product = productService. findProductById(Integer. parseInt(id));
String price = request. getParameter("price");
String time = request. getParameter("time");
product.setSfjp(1);
product.setJpprice(price);
product.setJpdate(time);
int i = productService. editProduct(product);
if (i == 1) {<!-- -->
request.setAttribute("msg", "Modified successfully");
} else {<!-- -->
request.setAttribute("msg", "Failed to modify");
}
String pagerNum = request. getParameter("pagerNum");
if (pagerNum == null) {<!-- -->
pagerNum = "1";
}
List<Product> list = productService. findListSpike();
request.setAttribute("count", list.size());
request.setAttribute("maxPager", PagerUtil.getMaxPager(list.size()));
list = (List<Product>) PagerUtil. getPager(list,
Integer. parseInt(pagerNum));
request.setAttribute("list", list);
request.setAttribute("pagerNum", pagerNum);
return new JspView("jsp.admin.product.promolist");
}
@At("/qxjp")
public View qxjp(HttpServletRequest request) {<!-- -->
String id = request. getParameter("id");
Product product = productService. findProductById(Integer. parseInt(id));
product.setSfjp(0);
product.setQpprice(null);
product.setJpdate(null);
request.setAttribute("jplist", jplist);
return new JspView("jsp.auction");
}
/**
* Jump to message
* @param request
* @return
*/
@At("/toMessage")
public View toMessage(HttpServletRequest request){<!-- -->
return new JspView("jsp. message");
}
/**
* Jump to product details
* @param request
* @return
*/
@At("/toDetail")
public View toDetail(HttpServletRequest request){<!-- -->
String id = request. getParameter("id");
Product product = productService. findProductById(Integer. parseInt(id));
//New product launch
List<Product> newlist = productService. findNewProduct();
request.setAttribute("newlist", newlist);
request.setAttribute("product", product);
return new JspView("jsp.detail");
}
/**
* Jump to promotional product details
* @param request
* @return
*/
@At("/tocxDetail")
public View tocxDetail(HttpServletRequest request){<!-- -->
String id = request. getParameter("id");
Product product = productService. findProductById(Integer. parseInt(id));
//Promotion
List<Product> cxlist = productService. findCxProduct();
request.setAttribute("cxlist", cxlist);
request.setAttribute("product", product);
return new JspView("jsp.cxdetail");
}
/**
* Skip to the seckill product details
* @param request
* @param request
* @return
*/
@At("/delete")
public View delete(HttpServletRequest request){<!-- -->
String id = request. getParameter("id");
int i = messageService.deleteMessage(Integer.parseInt(id));
if(i==1){<!-- -->
request.setAttribute("msg", "Deleted successfully");
}else{<!-- -->
request.setAttribute("msg", "Failed to delete");
}
String pagerNum = request. getParameter("pagerNum");
if(pagerNum==null){<!-- -->
pagerNum = "1";
}
List<Message> list = messageService. findListMessage();
list = (List<Message>) PagerUtil. getPager(list, Integer. parseInt(pagerNum));
request.setAttribute("list", list);
request.setAttribute("count", list.size());
request.setAttribute("maxPager", list.size()/10 + 1);
request.setAttribute("pagerNum", pagerNum);
return new JspView("jsp. admin. message");
}
}
@IocBean
public class DownloadAction {<!-- -->
\t
@At("download")
if (i == 1) {<!-- -->
request.setAttribute("msg", "Deleted successfully");
} else {<!-- -->
request.setAttribute("msg", "Failed to delete");
}
// ****
String pagerNum = request. getParameter("pagerNum");
if (pagerNum == null) {<!-- -->
pagerNum = "1";
}
List<Product> list = productService. findListProduct();
request.setAttribute("count", list.size());
request.setAttribute("maxPager", PagerUtil.getMaxPager(list.size()));
list = (List<Product>) PagerUtil. getPager(list,
Integer. parseInt(pagerNum));
request.setAttribute("list", list);
request.setAttribute("pagerNum", pagerNum);
return new JspView("jsp.admin.product.list");
}
@At("/toupdate")
public View toupdate(HttpServletRequest request) {<!-- -->
String id = request. getParameter("id");
Product product = productService. findProductById(Integer. parseInt(id));
request.setAttribute("product", product);
return new JspView("jsp.admin.product.update");
}
/**
* update pro
*
* @param request
* @return
* @throws IOException
*/
@At("/update")
@AdaptBy(type = UploadAdaptor. class, args = {<!-- --> "${app. root}/WEB-INF/tmp" })
public View update(HttpServletRequest request,
@Param("file") TempFile file, @Param("name") String name,
@Param("price") String price, @Param("content") String content,
@Param("id") String id) throws IOException {<!-- -->
request.setAttribute("maxPager", PagerUtil.getMaxPager(list.size()));
list = (List<Product>) PagerUtil. getPager(list,
Integer. parseInt(pagerNum));
request.setAttribute("list", list);
request.setAttribute("pagerNum", pagerNum);
return new JspView("jsp.admin.product.list");
}
/**
* Jump to add product page
*
* @param request
* @return
*/
@At("/toadd")
public View toadd(HttpServletRequest request) {<!-- -->
return new JspView("jsp.admin.product.add");
}
/**
* add pro
*
* @param request
* @return
* @throws IOException
*/
@At("/add")
@AdaptBy(type = UploadAdaptor. class, args = {<!-- --> "${app. root}/WEB-INF/tmp" })
public View add(HttpServletRequest request, @Param("file") TempFile file,
@Param("name") String name, @Param("price") String price,
@Param("content") String content) throws IOException {<!-- -->
Product product = new Product();
product.setName(name);
product.setPrice(price);
product.setContent(content);
// save image to start
File f = file. getFile();
String filename = f. getName();
int address = filename. lastIndexOf(".");
String type = filename. substring(address + 1, filename. length());
//Promotion
List<Product> cxlist = productService. findCxProduct();
request.setAttribute("cxlist", cxlist);
request.setAttribute("product", product);
return new JspView("jsp.cxdetail");
}
/**
* Skip to the seckill product details
* @param request
* @return
*/
@At("/tomsDetail")
public View tomsDetail(HttpServletRequest request){<!-- -->
String id = request. getParameter("id");
Product product = productService. findProductById(Integer. parseInt(id));
//Promotion
List<Product> cxlist = productService. findCxProduct();
request.setAttribute("cxlist", cxlist);
request.setAttribute("product", product);
\t\t
Calendar c = Calendar. getInstance();
try{<!-- -->
c.setTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse(product.getMsdate()));
} catch (ParseException e) {<!-- -->
e.printStackTrace();
}
long current_time = System. currentTimeMillis();
long end_time=c.getTimeInMillis();
long time=end_time-current_time;
request.setAttribute("time", time/1000);
return new JspView("jsp. msdetail");
}
/**
* Jump to auction product details
* @param request
* @return
*/
@At("/tojpDetail")
public View tojpDetail(HttpServletRequest request){<!-- -->
String id = request. getParameter("id");
Product product = productService. findProductById(Integer. parseInt(id));
//Promotion
List<Product> cxlist = productService. findCxProduct();
request.setAttribute("cxlist", cxlist);
order.setSenddept(senddept);
order.setTel(tel);
orderService. editOrder(order);
}
request.setAttribute("price", price);
return new JspView("jsp. pay");
}
/**
* pay
* @param request
* @return
*/
@At("/pay")
public View pay(HttpServletRequest request){<!-- -->
User user = (User)request.getSession().getAttribute("user");
List<Order> list = orderService.getCartList(user.getId());
Order order = new Order();
Product product = new Product();
for(int i=0;i<list. size();i ++ ){<!-- -->
order = list. get(i);
order.setSffk(1);
order. setVisible(1);
orderService. editOrder(order);
product = productService.findProductById(order.getProid());
if(product.getSfms()==1){<!-- -->//If it is a spike, the number of spikes -1
product.setMscount(product.getMscount()-1);
productService. editProduct(product);
}
\t\t\t
}
request.setAttribute("msg", "Payment succeeded");
//New product launch
List<Product> newlist = productService. findNewProduct();
request.setAttribute("newlist", newlist);
//Promotion
List<Product> cxlist = productService. findCxProduct();
request.setAttribute("cxlist", cxlist);
return new JspView("jsp. index");
}
/**
*
* @param request
* @return
*/
@At("/toOrderList")
public View toOrderList(HttpServletRequest request){<!-- -->
User user = (User)request.getSession().getAttribute("user");
List<Order> list = orderService. getOrderList(user. getId());
for(int i=0;i<list. size();i ++ ){<!-- -->
list.get(i).setUser(userService.findUserById(list.get(i).getUserid()));
list.get(i).setProduct(productService.findProductById(list.get(i).getProid()));
}
request.setAttribute("list", list);
return new JspView("jsp. orderlist");
@IocBean
@At("/index")
public class IndexAction {<!-- -->
\t
@Inject("refer: productService")
private ProductService productService;
@Inject("refer: orderService")
private OrderService orderService;
@Inject("refer: userService")
private UserService userService;
/**
* Jump to home page
* @param request
* @return
*/
@At("/toIndex")
public View toIndex(HttpServletRequest request){<!-- -->
//New product launch
List<Product> newlist = productService. findNewProduct();
request.setAttribute("newlist", newlist);
//Promotion
List<Product> cxlist = productService. findCxProduct();
request.setAttribute("cxlist", cxlist);
return new JspView("jsp. index");
}
/**
* Skip to promotion
* @param request
* @return
*/
@At("/toPromotions")
public View toPromotions(HttpServletRequest request){<!-- -->
//Promotion
List<Product> cxlist = productService. findCxProduct();
request.setAttribute("cxlist", cxlist);
//New product launch
List<Product> newlist = productService. findNewProduct();
request.setAttribute("newlist", newlist);
return new JspView("jsp. promotions");
list = (List<Product>) PagerUtil. getPager(list,
Integer. parseInt(pagerNum));
request.setAttribute("list", list);
request.setAttribute("pagerNum", pagerNum);
return new JspView("jsp.admin.product.list");
}
@At("/toupdate")
public View toupdate(HttpServletRequest request) {<!-- -->
String id = request. getParameter("id");
Product product = productService. findProductById(Integer. parseInt(id));
request.setAttribute("product", product);
return new JspView("jsp.admin.product.update");
}
/**
* update pro
*
* @param request
* @return
* @throws IOException
*/
@At("/update")
@AdaptBy(type = UploadAdaptor. class, args = {<!-- --> "${app. root}/WEB-INF/tmp" })
public View update(HttpServletRequest request,
@Param("file") TempFile file, @Param("name") String name,
@Param("price") String price, @Param("content") String content,
@Param("id") String id) throws IOException {<!-- -->
Product product = productService. findProductById(Integer. parseInt(id));
product.setName(name);
product.setPrice(price);
product.setContent(content);
String changePath = product. getImg();
if (file != null) {<!-- -->
// save image to start
File f = file. getFile();
String filename = f. getName();
int address = filename. lastIndexOf(".");
String type = filename. substring(address + 1, filename. length());
String date = new SimpleDateFormat("yyyyMMddHHmmssSS")
.format(Calendar.getInstance().getTime());
//String yp = "D:\file";
String yp = request.getServletContext().getRealPath("/");
//changePath = yp + date + "." + type;// Actual save path
changePath = yp + "\resources\file" + date + "." + type;
File desFile = new File(changePath);
File pck = new File(yp);
// check directory
if (!pck. exists()) {<!-- -->
pck.mkdirs();
List<Order> list = orderService.getCartList(user.getId());
Order order = new Order();
Product product = new Product();
for(int i=0;i<list. size();i ++ ){<!-- -->
order = list. get(i);
order.setSffk(1);
order. setVisible(1);
orderService. editOrder(order);
product = productService.findProductById(order.getProid());
if(product.getSfms()==1){<!-- -->//If it is a spike, the number of spikes -1
product.setMscount(product.getMscount()-1);
productService. editProduct(product);
}
\t\t\t
}
request.setAttribute("msg", "Payment succeeded");
//New product launch
List<Product> newlist = productService. findNewProduct();
request.setAttribute("newlist", newlist);
//Promotion
List<Product> cxlist = productService. findCxProduct();
request.setAttribute("cxlist", cxlist);
return new JspView("jsp. index");
}
/**
*
* @param request
* @return
*/
@At("/toOrderList")
public View toOrderList(HttpServletRequest request){<!-- -->
User user = (User)request.getSession().getAttribute("user");
List<Order> list = orderService. getOrderList(user. getId());
for(int i=0;i<list. size();i ++ ){<!-- -->
list.get(i).setUser(userService.findUserById(list.get(i).getUserid()));
list.get(i).setProduct(productService.findProductById(list.get(i).getProid()));
}
request.setAttribute("list", list);
return new JspView("jsp. orderlist");
}
\t
@At("/addprice")
public View addprice(HttpServletRequest request){<!-- -->
User user = (User)request.getSession().getAttribute("user");
String addprice = request. getParameter("addprice");
//***
String id = request. getParameter("id");
\t\t
Product product = productService. findProductById(Integer. parseInt(id));
int jpprice = Integer.parseInt(product.getJpprice()) + Integer.parseInt(addprice);
product.setJpprice(String.valueOf(jpprice));
productService. editProduct(product);
Order order = new Order();
List<Order> listorder = orderService. findOrderByProid(product. getId());
String username = request. getParameter("username");
String password = request. getParameter("password");
//If this method is requested directly, jump to the background login page
if(username==null & amp; & amp;password==null){<!-- -->
return new JspView("jsp.admin.login");
}
List<User> list = userService. findUserByNameAndPsd(username, password);
if(list. size()!=1){<!-- -->
request.setAttribute("msg", "Username or password error");
return new JspView("jsp.admin.login");
}else{<!-- -->
if(list.get(0).getAdmin()==1){<!-- -->
request.setAttribute("user", list.get(0));
request.getSession().setAttribute("user", list.get(0));
return new JspView("jsp.admin.index");
}else{<!-- -->
request.setAttribute("msg", "No administrator privilege");
return new JspView("jsp.admin.login");
}
}
}
/**
* adminlogout
* @param request
* @return
*/
@At("/adminlogout")
public View adminlogout(HttpServletRequest request){<!-- -->
request.getSession().setAttribute("user", null);
return new JspView("jsp.admin.login");
}
/**
* logout
* @param request
* @return
*/
@At("/logout")
public View logout(HttpServletRequest request){<!-- -->
request.getSession().setAttribute("user", null);
//New product launch
List<Product> newlist = productService. findNewProduct();
request.setAttribute("newlist", newlist);
//Promotion
List<Product> cxlist = productService. findCxProduct();
