mapper——》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="user"> <select id="findUserById" parameterType="Integer" resultType="com.qfedu.pojo.User"> select * from user where id = #{id} </select> <select id="findUserByUserName" parameterType="String" resultType="com.qfedu.pojo.User"> select * from user where username like '%${value}%' </select> <insert id="addUser" parameterType="com.qfedu.pojo.User"> insert into user(username,password)values(#{username},#{password}) </insert> </mapper> pojo——》User
package com.qfedu.pojo; public class User { private int id; private String username; private String password; public int getId() { return id; } public void setId(int id) { this.id = id; } public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } } test——》testAddUser
package com.qfedu.test; /*import com.qfedu.mapper.CustomerMapper; import com.qfedu.pojo.Customer;*/ import com.qfedu.pojo.User; 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 TestAddUser { public static void main(String[] args) throws Exception { String resource = "mybatis.xml"; try { InputStream in = Resources.getResourceAsStream(resource); SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in); SqlSession sqlSession = factory.openSession(); //添加 User user = new User(); user.setUsername("qq"); user.setPassword("2222"); // 调用SqlSession对象的insert()方法执行插入 int result = sqlSession.insert("user.addUser", user); if (result > 0) { System.out.println("成功插入" + result + "条数据"); } else { System.out.println("插入操作失败"); } // 提交事务 sqlSession.commit(); sqlSession.close(); } catch (IOException e) { e.printStackTrace(); } } } test——》testSelectUser
package com.qfedu.test; import com.qfedu.pojo.User; 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; import java.util.List; public class TestSelectUser { public static void main(String[] args) throws Exception { String resource = "mybatis.xml"; try { InputStream in = Resources.getResourceAsStream(resource); SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in); SqlSession sqlSession = factory.openSession(); //查询 List<User> selectList = sqlSession.selectList("user.findUserByUserName" /*"ff"*/); for (User user : selectList) { System.out.println(user.toString()); } // 提交事务 sqlSession.commit(); sqlSession.close(); } catch (IOException e) { e.printStackTrace(); } } } mybatis.xml
<?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> <settings> <setting name="logImpl" value="STDOUT_LOGGING" /> </settings> <!--配置别名 --> <typeAliases> <package name="com.qfedu.pojo" /> </typeAliases> <!--配置环境 --> <environments default="mysql"> <environment id="mysql"> <transactionManager type="JDBC" /> <dataSource type="POOLED"> <property name="driver" value="com.mysql.jdbc.Driver" /> <property name="url" value="jdbc:mysql://localhost:3306/db?useSSL=false" /> <property name="username" value="root" /> <property name="password" value="1234" /> </dataSource> </environment> </environments> <!-- 配置映射文件的位置 --> <mappers> <!-- 引入映射文件--> <!-- <mapper resource="com/qfedu/mapper/CustomerMapper.xml"/>--> <mapper resource="com/qfedu/mapper/UserMapper.xml"/> <!-- Mapper接口开发方式 --> <!-- <mapper class="com.qfedu.mapper.CustomMapper"/>--> </mappers> </configuration>