第一个Mybatis程序
首先创建一个普通的maven项目,在maven项目中的pom.xml文件中添加依赖
<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>org.example</groupId> <artifactId>mybatis</artifactId> <packaging>pom</packaging> <version>1.0-SNAPSHOT</version> <build> <resources> <resource> <directory>src/main/resources</directory> <includes> <include>**/*.properties</include> <include>**/*.xml</include> </includes> <filtering>false</filtering> </resource> <resource> <directory>src/main/java</directory> <includes> <include>**/*.properties</include> <include>**/*.xml</include> </includes> <filtering>false</filtering> </resource> </resources> </build> <modules> <module>mybatis-02</module> <module>mybatis-03</module> </modules> <properties> <maven.compiler.source>8</maven.compiler.source> <maven.compiler.target>8</maven.compiler.target> </properties> <!--父工程--> <dependencies> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.5.2</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.30</version> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.12</version> <scope>test</scope> </dependency> </dependencies> </project>
这是我简单的数据表
INSERT INTO `user` (`id`, `name`, `pwd`) VALUES (1, '狂神', '123456');
INSERT INTO `user` (`id`, `name`, `pwd`) VALUES (2, '张三', '123456');
INSERT INTO `user` (`id`, `name`, `pwd`) VALUES (3, '李四', '123890');
INSERT INTO `user` (`id`, `name`, `pwd`) VALUES (5, '李五', '123456789');
INSERT INTO `user` (`id`, `name`, `pwd`) VALUES (6, 'vv', NULL);
接下来就可以配置mybatis配置文件
<?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"> <configuration> <environments default="development"> <environment id="development"> <transactionManager type="JDBC"/> <dataSource type="POOLED"> <property name="driver" value="com.mysql.cj.jdbc.Driver"/> <property name="url" value="jdbc:mysql://localhost:3306/mybatis?useSSL=true&useUnicode=true&characterEncoding=UTF-8"/> <property name="username" value="root"/> <property name="password" value="123456"/> </dataSource> </environment> </environments> <mappers> <mapper resource="com/xu/dao/UserMapper.xml"/> </mappers> </configuration>
创建pojo实体类User
package com.xu.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 + '\'' + '}'; } }
使用mybatis第一部获取sqlSessionFactory对象
创建MybtaisUtils类
package com.xu.utils; 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; //使用mybatis第一部获取sqlSessionFactory对象 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(); } } //既然有了sqlsessionFactory,顾名思义,我们就可以从中获得sqlsession的实例了 //sqlsession完全包含了面向数据库执行sql命令所需要的方法 public static SqlSession getSqlSession(){ return sqlSessionFactory.openSession(); } }创建Dao层
接口UserDao
package com.xu.dao; import com.xu.pojo.User; import java.util.List; import java.util.Map; public interface UserDao { //获取全部用户 List<User>getUserList(); //根据Id查询用户 User getUserById(int id); User getUserById2(Map<String,Object>map); //insert一个用户 int addUser(User user); //修改用户 int updateUser(User user); //删除一个用户 int deleteUser(int id); //User getUserById2(Map<String,Object>map); int addUser2(Map<String,Object>map); //模糊查询 List<User>getUserLike(String value); } //Map<String,Object>map参数这是我在里面创建的增删改查的方法
创建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"> <!--命名namespace=绑定一个对应的Dao或Mapper接口--> <mapper namespace="com.xu.dao.UserDao"> <select id="getUserList" resultType="com.xu.pojo.User"> select * from mybatis.user </select> <select id="getUserById" parameterType="int" resultType="com.xu.pojo.User"> select * from mybatis.user where id = #{id} </select> <select id="getUserById2" parameterType="map" resultType="com.xu.pojo.User"> select * from mybatis.user where id = #{id} and name =#{name}; </select> <insert id="addUser" parameterType="com.xu.pojo.User"> insert into mybatis.user (id,name,pwd) value (#{id},#{name},#{pwd}) </insert> <insert id="addUser2" parameterType="map"> insert into mybatis.user (id,name) value (#{userid},#{username}) </insert> <update id="updateUser" parameterType="com.xu.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> <select id="getUserLike" resultType="com.xu.pojo.User"> select * from mybatis.user where name like "%"#{value}"%" </select> </mapper> <!--namespace命名空间,namespace中的包名要和Dao/mapper接口的包名一致! 2.select 选择,查询语句: ID:就是对应的namespace中的方法名; resultType:sql语句执行的返回值! parameterType:参数类型!-->
里面写sql代码
接来下就写测试类了
package com.xu.dao; import com.xu.dao.UserDao; import com.xu.pojo.User; import com.xu.utils.MybatisUtils; import org.apache.ibatis.session.SqlSession; import org.junit.Test; import java.util.HashMap; import java.util.List; import java.util.Map; public class UserDaoTest { @Test public void test(){ SqlSession sqlSession = MybatisUtils.getSqlSession(); UserDao userDao = sqlSession.getMapper(UserDao.class); List<User> userList = userDao.getUserList(); for (User user : userList) { System.out.println(user); } //关闭sqlSession sqlSession.close(); } @Test public void getUserById(){ SqlSession sqlSession = MybatisUtils.getSqlSession(); UserDao mapper = sqlSession.getMapper(UserDao.class); User userById = mapper.getUserById(1); System.out.println(userById); sqlSession.close(); } //增删改需要提交事务 @Test public void addUser(){ SqlSession sqlSession = MybatisUtils.getSqlSession(); UserDao mapper = sqlSession.getMapper(UserDao.class); int dd = mapper.addUser(new User(4, "打王者", "147258")); if(dd>0){ System.out.println("插入成功!"); } //提交事务 sqlSession.commit(); sqlSession.close(); } @Test public void addUser2(){ SqlSession sqlSession = MybatisUtils.getSqlSession(); UserDao mapper = sqlSession.getMapper(UserDao.class); HashMap<String,Object>map=new HashMap<String,Object>(); map.put("userid",6); map.put("username","vv"); mapper.addUser2(map); sqlSession.commit(); sqlSession.close(); } @Test public void updateUser(){ SqlSession sqlSession = MybatisUtils.getSqlSession(); UserDao mapper = sqlSession.getMapper(UserDao.class); mapper.updateUser(new User(5,"李五","123456789")); sqlSession.commit(); sqlSession.close(); } @Test public void deleteUser(){ SqlSession sqlSession = MybatisUtils.getSqlSession(); UserDao mapper = sqlSession.getMapper(UserDao.class); mapper.deleteUser(4); sqlSession.commit(); sqlSession.close(); } @Test public void getUserById2(){ SqlSession sqlSession = MybatisUtils.getSqlSession(); UserDao mapper = sqlSession.getMapper(UserDao.class); Map<String,Object>map=new HashMap<String,Object>(); map.put("id",1); mapper.getUserById2(map); System.out.println(map); sqlSession.commit(); sqlSession.close(); } @Test public void getUserLike(){ SqlSession sqlSession = MybatisUtils.getSqlSession(); UserDao mapper = sqlSession.getMapper(UserDao.class); List<User> userList = mapper.getUserLike("李"); for (User user : userList) { System.out.println(user); } } }z这就是我写的第一个mybatis程序,只是简单的sql增删改查。