网上书店 springboot mybatis mysql ssmk框架

package com.example.bookshop.controller; import com.example.bookshop.entity.books; import com.example.bookshop.entity.orders; import com.example.bookshop.entity.messages; import com.example.bookshop.entity.adminorder; import com.example.bookshop.entity.userinfo; import com.example.bookshop.entity.types; import com.example.bookshop.entity.nations; import com.example.bookshop.entity.writers; import com.example.bookshop.entity.press; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.jdbc.core.JdbcTemplate; import javax.servlet.http.HttpServletRequest; import java.util.HashMap; import java.util.List; import java.util.Map; import org.springframework.jdbc.core.BeanPropertyRowMapper; import org.springframework.jdbc.core.RowMapper; /** * 这部分是最开始创建项目时，为了测试项目能否正常运行写的一个测试 * * 访问http://localhost:8080/hello/springboot 可在页面看见：HelloWord * * */ @Controller @RequestMapping(value = {"/"}) public class HelloController { @Autowired private JdbcTemplate jdbcTemplate; @RequestMapping("/") public String Index(Model model,HttpServletRequest request) { String sql = "select * from books"; RowMapper<books> rowMapper=new BeanPropertyRowMapper<books>(books.class); List<books> books= jdbcTemplate.query(sql, rowMapper); model.addAttribute("hello",books); Map<String, Object> map = new HashMap<>(); map.put("sessionId", request.getSession().getId()); // 取值 map.put("message", request.getSession().getAttribute("session_user")); model.addAttribute("user",map.get("message")); return "index"; } @RequestMapping("/all") public String all(Model model,HttpServletRequest request) { String sql = "select * from books"; RowMapper<books> rowMapper=new BeanPropertyRowMapper<books>(books.class); List<books> books= jdbcTemplate.query(sql, rowMapper); model.addAttribute("hello",books); Map<String, Object> map = new HashMap<>(); map.put("sessionId", request.getSession().getId()); // 取值 map.put("message", request.getSession().getAttribute("session_user")); model.addAttribute("user",map.get("message")); return "all"; } @RequestMapping("/category") public String category(Model model,HttpServletRequest request) { //获取全部分类 String sql = "select distinct(Type) from books"; RowMapper<types> rowMapper=new BeanPropertyRowMapper<types>(types.class); List<types> types= jdbcTemplate.query(sql, rowMapper); model.addAttribute("types",types); //获取全部作者 String sql2 = "select * from author"; RowMapper<writers> rowMapper2=new BeanPropertyRowMapper<writers>(writers.class); List<writers> con= jdbcTemplate.query(sql2, rowMapper2); model.addAttribute("authors",con); //获取全部出版社 String sql4 = "select * from press"; RowMapper<press> rowMapper4=new BeanPropertyRowMapper<press>(press.class); List<press> press= jdbcTemplate.query(sql4, rowMapper4); model.addAttribute("press",press); Map<String, Object> map = new HashMap<>(); map.put("sessionId", request.getSession().getId()); // 取值 map.put("message", request.getSession().getAttribute("session_user")); model.addAttribute("user",map.get("message")); return "category"; } //具体的某个分类页面 @RequestMapping(value="/cate") public String cate(@RequestParam("id")String id, Model model,HttpServletRequest request) { String sql = "select * from books where Type=? "; RowMapper<books> rowMapper=new BeanPropertyRowMapper<books>(books.class); List<books> books= jdbcTemplate.query(sql, rowMapper,id); model.addAttribute("hello",books);//添加一个值为"hello thymeleaf"的hello变量到视图 //获取用户名 Map<String, Object> map = new HashMap<>(); map.put("sessionId", request.getSession().getId()); // 取值 map.put("message", request.getSession().getAttribute("session_user")); model.addAttribute("user",map.get("message")); return "all"; } @RequestMapping(value="/cateau") public String cateau(@RequestParam("au")int au, Model model,HttpServletRequest request) { String sql = "select * from books where authorid=? "; RowMapper<books> rowMapper=new BeanPropertyRowMapper<books>(books.class); List<books> books= jdbcTemplate.query(sql, rowMapper,au); model.addAttribute("hello",books);//添加一个值为"hello thymeleaf"的hello变量到视图 //获取用户名 Map<String, Object> map = new HashMap<>(); map.put("sessionId", request.getSession().getId()); // 取值 map.put("message", request.getSession().getAttribute("session_user")); model.addAttribute("user",map.get("message")); return "all"; } @RequestMapping(value="/catepress") public String catepress(@RequestParam("id")int id, Model model,HttpServletRequest request) { String sql = "select * from books where pressid=? "; RowMapper<books> rowMapper=new BeanPropertyRowMapper<books>(books.class); List<books> books= jdbcTemplate.query(sql, rowMapper,id); model.addAttribute("hello",books);//添加一个值为"hello thymeleaf"的hello变量到视图 //获取用户名 Map<String, Object> map = new HashMap<>(); map.put("sessionId", request.getSession().getId()); // 取值 map.put("message", request.getSession().getAttribute("session_user")); model.addAttribute("user",map.get("message")); return "all"; } @RequestMapping(value="/catena") public String catena(@RequestParam("id")String id, Model model,HttpServletRequest request) { String sql = "select * from books where Nation=? "; RowMapper<books> rowMapper=new BeanPropertyRowMapper<books>(books.class); List<books> books= jdbcTemplate.query(sql, rowMapper,id); model.addAttribute("hello",books);//添加一个值为"hello thymeleaf"的hello变量到视图 //获取用户名 Map<String, Object> map = new HashMap<>(); map.put("sessionId", request.getSession().getId()); // 取值 map.put("message", request.getSession().getAttribute("session_user")); model.addAttribute("user",map.get("message")); return "all"; } @RequestMapping(value="/search") public String search(@RequestParam("text")String text, Model model,HttpServletRequest request) { String sql = "select * from books where Title like ? or Brief like ?"; RowMapper<books> rowMapper=new BeanPropertyRowMapper<books>(books.class); List<books> books= jdbcTemplate.query(sql, rowMapper,"%"+text+"%","%"+text+"%"); model.addAttribute("hello",books); Map<String, Object> map = new HashMap<>(); map.put("sessionId", request.getSession().getId()); // 取值 map.put("message", request.getSession().getAttribute("session_user")); model.addAttribute("user",map.get("message")); return "search"; } @RequestMapping(value="/detail") public String detail(@RequestParam("id")int id, Model model,HttpServletRequest request) { String sql = "select books.* ,author.Nation,author.Author,press.Press from books,author,press where books.authorid=author.ID and books.pressid=press.ID and books.ID=?"; RowMapper<books> rowMapper=new BeanPropertyRowMapper<books>(books.class); books book= jdbcTemplate.queryForObject(sql, rowMapper,id);