基于javaweb+mysql的ssm茶叶溯源系统(java+ssm+jsp+bootstrap+layui+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SSM茶叶溯源系统(java+ssm+jsp+bootstrap+layui+mysql)
项目介绍
茶叶溯源系统,分为前台与后台。普通用户可在前台通过18位的编码查询茶叶的出售历史。 后台分为两种角色,管理员与经销商; 管理员主要功能包括: 主界面; 管理员管理:管理员列表、添加管理员; 分类管理:茶叶类型的添加、删除、修改; 茶叶管理:茶叶列表、添加、删除、修改茶叶; 大包装管理:大包装列表、添加、删除、修改大包装; 单品管理:售出统计、单品信息修改; 经销商主要功能包括: 主界面; 售出单品:确认售出单品;
环境需要
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.是否Maven项目: 否;查看源码目录中是否包含pom.xml;若包含,则为maven项目,否则为非maven项目 6.数据库:MySql 5.7版本;
技术栈
- 后端:Spring SpringMVC MyBatis 2. 前端:JSP+bootstrap+jQuery+layUI
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 将项目中jdbc.properties配置文件中的数据库配置改为自己的配置; 3. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven; 若为maven项目,导入成功后请执行maven clean;maven install命令,配置tomcat,然后运行; 4. 运行项目,输入localhost:8080/tea-web/ 登录
System.out.print("************************");
if(uname==null){
request.setAttribute("msg", "管理员不存在");
System.out.print("管理员不存在");
return "views/login";
}
if(!admin.getPwd().equals(password)){
System.out.print("密码不存在");
request.setAttribute("msg", "密码不存在");
return "views/login";
}
session.setAttribute("admin", admin);
session.setAttribute("adminname", admin.getNickname());
return "views/index";
}
@RequestMapping("/AdminLoginPage")
public String AdminLoginPage(HttpServletRequest request,HttpServletResponse response,HttpSession session
) throws UnknownHostException{
return "views/admin_login";
}
//查询并分页
@RequestMapping("/AdminPage")
public ModelAndView AdminPage(
@RequestParam(defaultValue="1") Integer currentPage,Map<String,Object> map){
System.out.println("已到达");
PageHelper.startPage(currentPage,8);
List<Admin> list=as.selectAll();
PageInfo<Admin> pageInfo=new PageInfo<Admin>(list,8);
map.put("pageInfo", pageInfo);
return new ModelAndView("views/admin");
}
@RequestMapping("/InsertAdmin")
public ModelAndView addAdmin(HttpServletRequest request,String uname,String pwd,String nickname)throws Exception {
Admin record=new Admin();
record.setUname(uname);
record.setPwd(nickname);
record.setNickname(nickname);
as.insert(record);
return new ModelAndView("redirect:AdminPage");
}
//根据主键删除id
@RequestMapping("/DeleteByAdminId")
@ResponseBody
public String deleteByPrimaryKey(@Param("id") int id) {
@Autowired
TeasService tea;
@Autowired
RetailerService re;
@RequestMapping("/toViewsLogin")
public String toViewsLogin(){
return "views/login";
}
@RequestMapping("/toWebMain")
public String toWebMain(){
return "web/main";
}
@RequestMapping("/toViewsLoginOut")
public String toViewsLoginOut(HttpServletRequest request) {
request.getSession().invalidate();
return "views/login";
}
@RequestMapping("/toLoginOutRetailer")
public String toViewsLoginOutRetailer(HttpServletRequest request) {
request.getSession().invalidate();
return "views/retailer_login";
}
@RequestMapping("/toWebHome")
public String toWebHome(HttpServletRequest request) {
return "web/main1";
}
@RequestMapping("/toWebLoginOut")
public String toWebLoginOut(HttpServletRequest request) {
request.getSession().invalidate();
return "web/login";
}
@RequestMapping("/toViewsInfo")
public String toViewsInfo(HttpServletRequest request) {
return "views/info";
}
@RequestMapping("/toViewsAddAdmin")
public String toViewsAddAdmin(HttpServletRequest request) {
return "views/add_admin";
}
@RequestMapping("/toViewsAddUser")
public String toViewsAddUse() {
return "views/add_user";
@RequestMapping("toWebLogin")
public String toWebLogin() {
return "/web/login2";
}
@RequestMapping("toViewsAddTeas")
public String toViewsAddTeas(HttpServletRequest request) {
request.setAttribute("typeList", ts.selectAll());
return "views/add_teas";
}
@RequestMapping("toViewsAddPack")
public String toViewsAddPack(HttpServletRequest request) {
request.setAttribute("teaList", tea.selectAll());
request.setAttribute("retailerList", re.selectAll());
return "views/add_pack";
}
}
@Controller
public class RetailerController {
@Autowired
RetailerService re;
public Retailer getParameter(HttpServletRequest request)throws Exception{
}
if(!admin.getPwd().equals(password)){
System.out.print("密码不存在");
request.setAttribute("msg", "密码不存在");
return "views/login";
}
session.setAttribute("admin", admin);
session.setAttribute("adminname", admin.getNickname());
return "views/index";
}
@RequestMapping("/AdminLoginPage")
public String AdminLoginPage(HttpServletRequest request,HttpServletResponse response,HttpSession session
) throws UnknownHostException{
return "views/admin_login";
}
//查询并分页
@RequestMapping("/AdminPage")
public ModelAndView AdminPage(
@RequestParam(defaultValue="1") Integer currentPage,Map<String,Object> map){
System.out.println("已到达");
PageHelper.startPage(currentPage,8);
List<Admin> list=as.selectAll();
PageInfo<Admin> pageInfo=new PageInfo<Admin>(list,8);
map.put("pageInfo", pageInfo);
return new ModelAndView("views/admin");
}
@RequestMapping("/InsertAdmin")
public ModelAndView addAdmin(HttpServletRequest request,String uname,String pwd,String nickname)throws Exception {
Admin record=new Admin();
record.setUname(uname);
record.setPwd(nickname);
record.setNickname(nickname);
as.insert(record);
return new ModelAndView("redirect:AdminPage");
}
//根据主键删除id
@RequestMapping("/DeleteByAdminId")
@ResponseBody
public String deleteByPrimaryKey(@Param("id") int id) {
as.delete(id);
return "ok";
}
@ResponseBody
public List<Teas> getLesson(){
List<Teas> list=ts.selectAll();
return list;
}
@RequestMapping("/InsertTeas")
public ModelAndView InsertTeas(HttpServletRequest request,MultipartFile tCover, MultipartFile img)throws Exception {
Teas record=new Teas();
record.setTeaName(request.getParameter("teaName"));
record.settCover(UploadUtil.fileUpload(tCover));
record.setImg(UploadUtil.fileUpload(img));
record.setPrice(Double.parseDouble(request.getParameter("price")));
record.setInfo(request.getParameter("info"));
record.setCount(Integer.parseInt(request.getParameter("count")));
record.settId(Integer.parseInt(request.getParameter("tId")));
ts.insert(record);
return new ModelAndView("redirect:TeasPage");
}
@RequestMapping(value="/ToUpdateTeas")
public String ToUpdateTeas(HttpServletRequest request,int id) {
request.setAttribute("typeList", ts1.selectAll());
Teas record=ts.findById(id);
request.setAttribute("teas", record);
return "views/update_teas";
}
@RequestMapping("/UpdateTeas")
public ModelAndView UpdateTeas(HttpServletRequest request,int id,MultipartFile tCover, MultipartFile img)throws Exception {
Teas record=new Teas();
record.setTeaName(request.getParameter("teaName"));
record.settCover(UploadUtil.fileUpload(tCover));
record.setImg(UploadUtil.fileUpload(img));
record.setPrice(Double.parseDouble(request.getParameter("price")));
record.setInfo(request.getParameter("info"));
record.setCount(Integer.parseInt(request.getParameter("count")));
record.settId(Integer.parseInt(request.getParameter("tId")));
ts.update(record, id);
return new ModelAndView("redirect:TeasPage");
}
@Controller
public class TeasController {
@Autowired
TeasDao teasDao;
@Autowired
TeasService ts;
@Autowired
TypeService ts1;
/*
* 重复代码块,用来进行插入和更改时的时候对其进行调用。
*/
@RequestMapping("/TeasPage")
public ModelAndView TeasPage(
@RequestParam(defaultValue="1") Integer currentPage,Map<String,Object> map){
System.out.println("已到达");
PageHelper.startPage(currentPage,8);
List<Teas> list=ts.selectAll();
PageInfo<Teas> pageInfo=new PageInfo<Teas>(list,8);
map.put("pageInfo", pageInfo);
@Controller
public class PackController {
@Autowired
PackService pa;
@Autowired
ItemService it;
public static String getRandomUUID() {
//1、创建时间戳
java.util.Date dateNow = new java.util.Date();
SimpleDateFormat dateFormat = new SimpleDateFormat("yyyyMMddHHmmss");
String dateNowStr = dateFormat.format(dateNow);
StringBuffer sb = new StringBuffer(dateNowStr);
//2、创建随机对象
Random rd = new Random();
HttpServletRequest request,Map<String,Object> map) {
String Adminname=request.getParameter("search");
System.out.println(Adminname);
PageHelper.startPage(currentPage,8);
List<Admin> list=AdminService.selectByName(Adminname);
PageInfo<Admin> pageInfo=new PageInfo<Admin>(list,8);
map.put("pageInfo", pageInfo);
return "/Admin/showAdmin";
}*/
}
@Controller
public class PackController {
@Autowired
PackService pa;
@Autowired
ItemService it;
public class TeasController {
@Autowired
TeasDao teasDao;
@Autowired
TeasService ts;
@Autowired
TypeService ts1;
/*
* 重复代码块,用来进行插入和更改时的时候对其进行调用。
*/
@RequestMapping("/TeasPage")
public ModelAndView TeasPage(
@RequestParam(defaultValue="1") Integer currentPage,Map<String,Object> map){
System.out.println("已到达");
PageHelper.startPage(currentPage,8);
List<Teas> list=ts.selectAll();
PageInfo<Teas> pageInfo=new PageInfo<Teas>(list,8);
map.put("pageInfo", pageInfo);
return new ModelAndView("/views/list_teas");
}
@RequestMapping("/TeaWebPage")
public ModelAndView TeaWebPage(
@RequestParam(defaultValue="1") Integer currentPage,Map<String,Object> map){
System.out.println("已到达");
PageHelper.startPage(currentPage,5);
List<Teas> list=ts.selectAll();
PageInfo<Teas> pageInfo=new PageInfo<Teas>(list,5);
map.put("pageInfo", pageInfo);
return new ModelAndView("/web/info");
}
@RequestMapping("/getTeas.do")
@ResponseBody
public List<Teas> getLesson(){
List<Teas> list=ts.selectAll();
return list;
}
map.put("pageInfo", pageInfo);
return new ModelAndView("/views/list_type");
}
@RequestMapping("/TypeWebPage")
public ModelAndView TypeWebPage(
@RequestParam(defaultValue="1") Integer currentPage,HttpServletRequest request,Map<String,Object> map){
System.out.println("已到达");
PageHelper.startPage(currentPage,5);
List<Type> list=ts.selectAll();
PageInfo<Type> pageInfo=new PageInfo<Type>(list,8);
map.put("pageInfo", pageInfo);
return new ModelAndView("/web/main");
}
@RequestMapping("/InsertType")
public ModelAndView InsertType(HttpServletRequest request)throws Exception {
Type record=new TypeController().getParameter(request);
ts.insert(record);
return new ModelAndView("redirect:TypePage");
}
@RequestMapping("/getTypes.do")
@ResponseBody
public List<Type> getLesson(){
List<Type> list=ts.selectAll();
return list;
}
@RequestMapping(value="/ToUpdateType")
public String ToUpdateType(HttpServletRequest request,int id) {
Type record=ts.findById(id);
request.setAttribute("type", record);
return "views/update_type";
}
@RequestMapping("/UpdateType")
@RequestMapping("/TypePage")
public ModelAndView TypePage(
@RequestParam(defaultValue="1") Integer currentPage,HttpServletRequest request,Map<String,Object> map){
System.out.println("已到达");
PageHelper.startPage(currentPage,8);
List<Type> list=ts.selectAll();
PageInfo<Type> pageInfo=new PageInfo<Type>(list,8);
map.put("pageInfo", pageInfo);
return new ModelAndView("/views/list_type");
}
@RequestMapping("/TypeWebPage")
public ModelAndView TypeWebPage(
@RequestParam(defaultValue="1") Integer currentPage,HttpServletRequest request,Map<String,Object> map){
System.out.println("已到达");
PageHelper.startPage(currentPage,5);
List<Type> list=ts.selectAll();
PageInfo<Type> pageInfo=new PageInfo<Type>(list,8);
map.put("pageInfo", pageInfo);
return new ModelAndView("/web/main");
}
@RequestMapping("/InsertType")
public ModelAndView InsertType(HttpServletRequest request)throws Exception {
Type record=new TypeController().getParameter(request);
ts.insert(record);
return new ModelAndView("redirect:TypePage");
}
@RequestMapping("/getTypes.do")
@ResponseBody
public List<Type> getLesson(){
List<Type> list=ts.selectAll();
return list;
}
@RequestMapping(value="/ToUpdateType")
public String ToUpdateType(HttpServletRequest request,int id) {
Type record=ts.findById(id);
request.setAttribute("type", record);
public String ToUpdateAdmin(HttpServletRequest request,int id) {
Admin admin=as.findById(id);
request.setAttribute("admin", admin);
return "views/update_admin";
}
@RequestMapping("/UpdateAdmin")
public ModelAndView UpdateAdmin(HttpServletRequest request,int id,String uname,String pwd,String nickname)throws Exception {
Admin record=new Admin();
record.setUname(uname);
record.setPwd(pwd);
record.setNickname(nickname);
as.update(record,id);
return new ModelAndView("redirect:AdminPage");
}
/*//模糊查询
@RequestMapping("/selectByName")
public String findByName(
@RequestParam(defaultValue="1") Integer currentPage,
HttpServletRequest request,Map<String,Object> map) {
String Adminname=request.getParameter("search");
System.out.println(Adminname);
PageHelper.startPage(currentPage,8);
List<Admin> list=AdminService.selectByName(Adminname);
PageInfo<Admin> pageInfo=new PageInfo<Admin>(list,8);
map.put("pageInfo", pageInfo);
return "/Admin/showAdmin";
}*/
}
@Controller
public class TypeController {
@Autowired
TypeService ts;
/*
* 重复代码块,用来进行插入和更改时的时候对其进行调用。
*/
public Type getParameter(HttpServletRequest request)throws Exception{
Type record=new Type();
record.settName(request.getParameter("tName"));
return record;
}
@RequestMapping("/TypePage")
public ModelAndView TypePage(
@RequestParam(defaultValue="1") Integer currentPage,HttpServletRequest request,Map<String,Object> map){
System.out.println("已到达");
PageHelper.startPage(currentPage,8);
List<Type> list=ts.selectAll();
PageInfo<Type> pageInfo=new PageInfo<Type>(list,8);
map.put("pageInfo", pageInfo);
return new ModelAndView("/views/list_type");
}
@Controller
public class PackController {
@Autowired
PackService pa;
@Autowired
ItemService it;
public static String getRandomUUID() {
//1、创建时间戳
java.util.Date dateNow = new java.util.Date();
SimpleDateFormat dateFormat = new SimpleDateFormat("yyyyMMddHHmmss");
String dateNowStr = dateFormat.format(dateNow);
StringBuffer sb = new StringBuffer(dateNowStr);
//2、创建随机对象
Random rd = new Random();
//3、产生4位随机数
String n = "";
int rdGet; //取得随机数
do {
rdGet = Math.abs(rd.nextInt()) % 10 + 48; //产生48到57的随机数(0-9的键位值)
// rdGet=Math.abs(rd.nextInt())%26+97; //产生97到122的随机数(a-z的键位值)
char num1 = (char) rdGet;
String dd = Character.toString(num1);
@RequestMapping("/UpdateAdmin")
public ModelAndView UpdateAdmin(HttpServletRequest request,int id,String uname,String pwd,String nickname)throws Exception {
Admin record=new Admin();
record.setUname(uname);
record.setPwd(pwd);
record.setNickname(nickname);
as.update(record,id);
return new ModelAndView("redirect:AdminPage");
}
/*//模糊查询
@RequestMapping("/selectByName")
public String findByName(
@RequestParam(defaultValue="1") Integer currentPage,
HttpServletRequest request,Map<String,Object> map) {
String Adminname=request.getParameter("search");
System.out.println(Adminname);
PageHelper.startPage(currentPage,8);
List<Admin> list=AdminService.selectByName(Adminname);
PageInfo<Admin> pageInfo=new PageInfo<Admin>(list,8);
map.put("pageInfo", pageInfo);
return "/Admin/showAdmin";
}*/
}
) throws UnknownHostException{
String uname=request.getParameter("uname");
String password=request.getParameter("pwd");
Admin admin = as.selectByUname(uname);
System.out.print("************************");
if(uname==null){
request.setAttribute("msg", "管理员不存在");
System.out.print("管理员不存在");
return "views/login";
}
if(!admin.getPwd().equals(password)){
System.out.print("密码不存在");
request.setAttribute("msg", "密码不存在");
return "views/login";
}
session.setAttribute("admin", admin);
session.setAttribute("adminname", admin.getNickname());
return "views/index";
}
@RequestMapping("/AdminLoginPage")
public String AdminLoginPage(HttpServletRequest request,HttpServletResponse response,HttpSession session
) throws UnknownHostException{
return "views/admin_login";
}
//查询并分页
@RequestMapping("/AdminPage")
public ModelAndView AdminPage(
@RequestParam(defaultValue="1") Integer currentPage,Map<String,Object> map){
System.out.println("已到达");
PageHelper.startPage(currentPage,8);
List<Admin> list=as.selectAll();
PageInfo<Admin> pageInfo=new PageInfo<Admin>(list,8);
map.put("pageInfo", pageInfo);
return new ModelAndView("views/admin");
}
/*
* @RequestMapping("")
public String() {
return "views/addAdmin";
}*/
@RequestMapping("toWebLogin")
public String toWebLogin() {
return "/web/login2";
}
@RequestMapping("toViewsAddTeas")
public String toViewsAddTeas(HttpServletRequest request) {
request.setAttribute("typeList", ts.selectAll());
return "views/add_teas";
}
@RequestMapping("toViewsAddPack")
public String toViewsAddPack(HttpServletRequest request) {
request.setAttribute("teaList", tea.selectAll());
request.setAttribute("retailerList", re.selectAll());
return "views/add_pack";
}
}