<?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"><mappernamespace="com.lxc.dao.UserDao"><selectid="findAll"resultType="com.lxc.domain.User">
select * from user;
</select><insertid="addUser"parameterType="com.lxc.domain.User">
insert into user (`name`,`gender`,`age`,`address`,`qq`,`email`)
values
(#{name},#{gender},#{age},#{address},#{qq},#{email});
</insert><updateid="updateUser"parameterType="com.lxc.domain.User">
update user set `name`=#{name},`gender`=#{gender},`age`=#{age},
`address`=#{address},`qq`=#{qq},`email`=#{email}
where `id` = #{id};
</update><selectid="findUser"parameterType="java.lang.Integer"resultType="com.lxc.domain.User">
select * from user where `id`=#{id};
</select><deleteid="deleteUser"parameterType="java.lang.Integer">
delete from user where `id`=#{id};
</delete></mapper>
UserDao.java
publicinterfaceUserDao{
List<User>findAll();intaddUser(User user);intupdateUser(User user);
User findUser(int id);intdeleteUser(int id);}
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><environmentsdefault="mysql"><environmentid="mysql"><transactionManagertype="JDBC"></transactionManager><dataSourcetype="POOLED"><propertyname="driver"value="com.mysql.cj.jdbc.Driver"/><propertyname="url"value="jdbc:mysql://127.0.0.1:3306/study1?useUnicode=true&characterEncoding=utf8&useSSL=false"/><propertyname="username"value="root"/><propertyname="password"value="root"/></dataSource></environment></environments><mappers><mapperresource="dao/UserDao.xml"></mapper></mappers></configuration>
测试类
publicclassMyTest1{private SqlSession session;private InputStream is;private UserDao userDao;@Beforepublicvoidinit(){try{
is = Resources.getResourceAsStream("mybatis.xml");
SqlSessionFactoryBuilder builder =newSqlSessionFactoryBuilder();
SqlSessionFactory sqlSessionFactory = builder.build(is);
session = sqlSessionFactory.openSession();
userDao = session.getMapper(UserDao.class);}catch(IOException e){
e.printStackTrace();}}@Afterpublicvoiddestroy(){try{
session.commit();
session.close();
is.close();}catch(IOException e){
e.printStackTrace();}}@TestpublicvoidTest1(){
List<User> users = userDao.findAll();for(User u : users){
System.out.println(u.toString());}}@TestpublicvoidTest2(){
User user =newUser();
user.setName("测试");
user.setGender("男");
user.setAge(23);
user.setAddress("上海");
user.setQq("741852");
user.setEmail("456@123.com");int i = userDao.addUser(user);
System.out.println(i);}@TestpublicvoidTest3(){
User user = userDao.findUser(56);
user.setName("测试1");int i = userDao.updateUser(user);
System.out.println(i);}@TestpublicvoidTest4(){int i = userDao.deleteUser(56);
System.out.println(i);}}