1、搭建环境
(1)、搭建环境准备工作
a、官网下载eclipse
b、官网下载maven,并配置maven环境,和本地仓库路径
c、eclipse配置maven
(2)、新建项目
(1)file—》new—》maven project
(2)点击next
(3)next
(4)finish完成
(5)哈哈到此环境就搭建完了
2、代码和框架构架
(1)、dao
@Mapper
public interface UserDAO extends BaseMapper<User> {
List<User> selectUser();
List<User> selectByUserId(String userId);
User selectOneById(String userId);
void addUser(User user);
void updateUser(User user);
void deleteByUserId(String userId);
}
(2)、server
public interface UserService {
List<User> getUser();
void addUser(User user);
List<User> selectByUserId(String userId);
void updateUser(User user);
void deleteByUserId(String userId);
User selectOneById(String userId);
}
(3)、serverimpl
@Service("userService")
public class UserServiceImpl implements UserService {
@Autowired
private UserDAO userDao;
@Override
public List<User> getUser() {
return userDao.selectUser();
}
@Override
public void addUser(User user) {
userDao.addUser(user);
}
@Override
public List<User> selectByUserId(String userId) {
List<User> selectByUserId = userDao.selectByUserId(userId);
return selectByUserId;
}
@Override
public void updateUser(User user) {
userDao.updateUser(user);
}
@Override
public void deleteByUserId(String userId) {
userDao.deleteByUserId(userId);
}
@Override
public User selectOneById(String userId) {
return userDao.selectOneById(userId);
}
}
(4)、entity
public class User {
private String userId ;
private String userCode ;
private String userName;
public String getUserId() {
return userId;
}
public void setUserId(String userId) {
this.userId = userId;
}
public String getUserCode() {
return userCode;
}
public void setUserCode(String userCode) {
this.userCode = userCode;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
@Override
public String toString() {
return "User [userId=" + userId + ", userCode=" + userCode + ", userName=" + userName + "]";
}
}
(5)、application.properties
server.port=8081
context-path:/demoWeb
spring.application.name=demoWeb
server.tomcat.uri-encoding=utf-8
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url = jdbc:mysql://localhost:3306/mysql?setUnicode=true&characterEncoding=utf8
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.max-idle=10
spring.datasource.max-wait=10000
spring.datasource.min-idle=5
spring.datasource.initial-size=5
server.servlet.session.timeout=30m
mybatis.typeAliasesPackage=com.springboot.entity
mybatis.mapper-locations=classpath:mapper/*Mapper.xml
spring.thymeleaf.content-type: text/html
spring.thymeleaf.cache: false
spring.thymeleaf.mode: LEGACYHTML5
spring.mvc.view.prefix=/WEB-INF/jsp/
spring.mvc.view.suffix=.jsp
(6)、mapper
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.springboot.dao.UserDAO">
<!-- 通用查询映射结果 -->
<resultMap id="BaseResultMap" type="com.springboot.entity.User">
<id column="userId" property="userId" />
<result column="userCode" property="userCode" />
<result column="userName" property="userName" />
</resultMap>
<select id="selectUser" resultType="com.springboot.entity.User">
SELECT * FROM userstu
</select>
<select id="selectByUserId" resultType="com.springboot.entity.User" parameterType="String">
SELECT * FROM userstu where userId=#{
userId}
</select>
<select id="selectOneById" resultType="com.springboot.entity.User" parameterType="String">
SELECT * FROM userstu where userId=#{
userId}
</select>
<insert id="addUser" parameterType="com.springboot.entity.User">
insert into userstu(userId,userCode,userName)values(#{
userId},#{
userCode},#{
userName})
</insert>
<update id="updateUser" parameterType="com.springboot.entity.User">
update userstu set userCode = #{
userCode},userName = #{
userName} where userId = #{
userId}
</update>
<delete id="deleteByUserId" parameterType="String">
delete from userstu where userId = #{
userId}
</delete>
</mapper>
(7)、controller
@Controller
@RequestMapping("test")
public class UserController {
@Autowired
private UserService userService;
@ApiOperation(value = "获取用户列表")
@RequestMapping("index")
public ModelAndView select() {
ModelAndView mv = new ModelAndView();
List<User> user = userService.getUser();
mv.addObject("user", user);
mv.setViewName("index");
return mv;
}
// 通过id删除学生信息
@RequestMapping("/deleteStudentById")
public String deleteStudent(String id) {
userService.deleteByUserId(id);
return "redirect:index";
}
// 通过id查询学生的信息
@RequestMappi