mybatis增删改
package com.rzk.dao; import com.rzk.pojo.User; import java.util.List; import java.util.Map; public interface UserMapper { //模糊查詢 List<User> getUserLike(String value); //查询全部用户 List<User> getUserList(); //根据ID查询用户 User getUserById(int id); //插入一个用户 int addUser(User user); //修改用户 int updateUser(User user); //删除一个用户 int deleteUser(int id); //插入的Map--------有帮助------------ int addUser1(Map<String,Object> map); //查询的Map User getUserId1(Map<String,Object> map); } ------- 对应的Mapper.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"> <!--namespace 绑定一个对应的Dao/Mapper接口--> <mapper namespace="com.rzk.dao.UserMapper"> <!--模糊查詢--> <select id="getUserLike" resultType="com.rzk.pojo.User"> select * from mybatis.user where name like "%"#{value}"%"; </select> <!--select 查询语句 查询全部用户--> <select id="getUserList" resultType="com.rzk.pojo.User"> select * from mybatis.user </select> <!--根据id查询单个用户--> <select id="getUserById" parameterType="int" resultType="com.rzk.pojo.User"> select * from mybatis.user where id = #{id} </select> <!--插入--> <insert id="addUser" parameterType="com.rzk.pojo.User" > insert into mybatis.user (id, name, pwd) values (#{id},#{name},#{pwd}) </insert> <!--修改--> <update id="updateUser" parameterType="com.rzk.pojo.User"> update mybatis.user set name=#{name},pwd=#{pwd} where id=#{id}; </update> <!--删除--> <delete id="deleteUser" parameterType="int"> delete from mybatis.user where id = #{id} </delete> <!--Map 传递map的key就可以了、 --> <insert id="addUser1" parameterType="map"> insert into mybatis.user(id, name, pwd) values(#{userid},#{username},#{userpassword}); </insert> <!--Map 传递map的key就可以了、 --> <select id="getUserId1" parameterType="map" resultType="com.rzk.pojo.User"> select * from mybatis.user where id = #{id} and pwd =#{password}; </select> </mapper> ----------------------------- 实体类 package com.rzk.pojo; public class User { private int id; private String name; private String pwd; public User(){ } public User(int id,String name,String pwd){ this.id=id; this.name=name; this.pwd=pwd; } public int getId(){ return id; } public void setId(int id){ this.id=id; } public String getName(){ return name; } public void setName(String name){ this.name=name; } public String getPwd(){ return pwd; } public void setPwd(String pwd){ this.pwd=pwd; } @Override public String toString() { return "User{" + "id=" + id + ", name='" + name + '\'' + ", pwd='" + pwd + '\'' + '}'; } } - ------------------------------ package com.rzk.util; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; import java.io.IOException; import java.io.InputStream; public class MybatisUtils { private static SqlSessionFactory sqlSessionFactory; static{ try { String resource = "mybatis-config.xml"; InputStream inputStream = Resources.getResourceAsStream(resource); sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream); } catch (IOException e) { e.printStackTrace(); } } public static SqlSession getSqlSession(){ return sqlSessionFactory.openSession(); } } -------------------------------- 测试类 package com.rzk.dao; import com.rzk.pojo.User; import com.rzk.util.MybatisUtils; import com.sun.corba.se.spi.ior.ObjectKey; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.junit.Test; import java.util.HashMap; import java.util.List; import java.util.Map; public class UserDaoTest { @Test public void getUserLike(){ SqlSession sqlSession = MybatisUtils.getSqlSession(); UserMapper mapper = sqlSession.getMapper(UserMapper.class); List<User> userList = mapper.getUserLike("李"); for (User user : userList){ System.out.println(user); } sqlSession.close(); } @Test public void test(){ //获得sqlSession对象 SqlSession sqlSession = MybatisUtils.getSqlSession(); //方式一:getMapper UserMapper mapper = sqlSession.getMapper(UserMapper.class); List<User> userList = mapper.getUserList(); for (User user : userList) { System.out.println(user); } sqlSession.close(); } @Test public void getUserById(){ SqlSession sqlSession = MybatisUtils.getSqlSession(); UserMapper mapper = sqlSession.getMapper(UserMapper.class); User userById = mapper.getUserById(1); System.out.println(userById); sqlSession.close(); } @Test public void addUser(){ SqlSession sqlSession = MybatisUtils.getSqlSession(); UserMapper mapper = sqlSession.getMapper(UserMapper.class); int i = mapper.addUser(new User(4,"赵柳","1234556")); sqlSession.commit(); System.out.println("插入成功"); sqlSession.close(); } @Test public void updateUser(){ SqlSession sqlSession = MybatisUtils.getSqlSession(); UserMapper mapper = sqlSession.getMapper(UserMapper.class); int user = mapper.updateUser(new User(1, "李倩", "123123")); if (user>0){ System.out.println("修改成功"); } sqlSession.commit(); sqlSession.close(); } @Test public void deleteUser(){ SqlSession sqlSession = MybatisUtils.getSqlSession(); UserMapper mapper = sqlSession.getMapper(UserMapper.class); int i = mapper.deleteUser(5); if (i>0){ System.out.println("删除成功"); }else{ System.out.println("删除失败"); } sqlSession.commit(); sqlSession.close(); } @Test public void getUserId1(){ SqlSession sqlSession = MybatisUtils.getSqlSession(); UserMapper mapper = sqlSession.getMapper(UserMapper.class); Map<String, Object> map = new HashMap<String, Object>(); map.put("id",1); map.put("password","123123"); User user = mapper.getUserId1(map); System.out.println(user); sqlSession.close(); } }
------------------------------------
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<!--configguration核心配置文件-->
<configuration>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="鏈接?userSSL=true&useUnicode=true&characterEncoding=UTF8"/>
<property name="username" value="root"/>
<property name="password" value="123456"/>
</dataSource>
</environment>
</environments>
<!--每一个Mapper.xml 都需要在Mybatis核心配置文件中注册-->
<mappers>
<mapper resource="com/rzk/dao/UserMapper.xml"/>
</mappers>
</configuration>