一、向数据库插入数据
1.1、在UserDAO中添加addUser方法
1.2、在UserMapp.xml中匹配addUser方法,并维护sql语句
< insert id = " addUser" >
insert into t_user (id, user_name, passwd) values (#{id}, #{name}, #{passwd})
</ insert>
1.3、在controller中测试
@RequestMapping ( "/t8" )
public int t8 ( ) {
int count = dao. addUser ( new User ( 1001L , "mike" , "321" ) ) ;
return count;
}
二、从数据库查询数据
2.1、在UserDAO中添加login方法
2.2、在UserMapp.xml中匹配login方法,并维护sql语句
< select id = " login" resultType = " demo.entity.User" >
select * from t_user where user_name=#{userName} and passwd=#{passwd}
</ select>
2.3、在controller中测试
@RequestMapping ( "/login" )
public String login ( String userName, String passwd) {
User u = dao. login ( userName, passwd) ;
if ( u != null ) {
return "登录成功" ;
} else {
return "登录失败" ;
}
}
三、根据id修改数据
3.1、在UserDAO中添加updateUser方法
3.2、在UserMapp.xml中匹配updateUser方\法,并维护sql语句
< update id = " updateUser" >
update t_user set user_name=#{name} , passwd=#{passwd} where id=#{id}
</ update>
3.3、在controller中测试
@RequestMapping ( "/t9" )
public int t9 ( ) {
int count = dao. updateUser ( new User ( 1001L , "tom10" , "123" ) ) ;
return count;
}
四、根据id删除数据
4.1、在UserDAO中添加deleteUser方法
4.2、在UserMapp.xml中匹配deleteUser方法,并维护sql语句
< delete id = " deleteUser" >
delete from t_user where id=#{id}
</ delete>
4.3、在controller中测试
@RequestMapping ( "/t10" )
public int t10 ( ) {
int count = dao. deleteUser ( 1001L ) ;
return count;
}
五、完整的代码
5.1、UserDAO
package demo. dao ;
import com. baomidou. mybatisplus. core. mapper. BaseMapper ;
import demo. entity. User ;
public interface UserDAO extends BaseMapper < User > {
public User login ( String userName, String passwd) ;
public int addUser ( User user) ;
public int updateUser ( User user) ;
public int deleteUser ( Long id) ;
}
5.2、UserMapper.xml
<?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 = " demo.dao.UserDAO" >
< select id = " login" resultType = " demo.entity.User" >
select * from t_user where user_name=#{userName} and passwd=#{passwd}
</ select>
< insert id = " addUser" >
insert into t_user (id, user_name, passwd) values (#{id}, #{name}, #{passwd})
</ insert>
< update id = " updateUser" >
update t_user set user_name=#{name} , passwd=#{passwd} where id=#{id}
</ update>
< delete id = " deleteUser" >
delete from t_user where id=#{id}
</ delete>
</ mapper>
5.3、User.java
package demo. entity ;
import com. baomidou. mybatisplus. annotation. TableField ;
import com. baomidou. mybatisplus. annotation. TableId ;
import com. baomidou. mybatisplus. annotation. TableName ;
import lombok. AllArgsConstructor ;
import lombok. Data ;
import lombok. NoArgsConstructor ;
@Data
@AllArgsConstructor
@NoArgsConstructor
@TableName ( "t_user" )
public class User {
@TableId
private Long id;
@TableField ( "user_name" )
private String name;
private String passwd;
}
User {
@TableId
private Long id;
@TableField ( "user_name" )
private String name;
private String passwd;
}