设为首页 收藏本站
查看: 764|回复: 0

[经验分享] MyBatis CRUD Operations

[复制链接]

尚未签到

发表于 2016-11-24 06:17:37 | 显示全部楼层 |阅读模式
1.Maven Dependency

<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.fool.mybatis</groupId>
<artifactId>MyBatis</artifactId>
<version>0.0.1-SNAPSHOT</version>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<mybatis-version>3.2.1</mybatis-version>
<mysql-connector-version>5.1.24</mysql-connector-version>
<junit-version>4.11</junit-version>
</properties>
<dependencies>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>${mybatis-version}</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>${mysql-connector-version}</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>${junit-version}</version>
<scope>test</scope>
</dependency>
</dependencies>
</project>
 

2.Project Directory

DSC0000.png
 


3.src/main/resources

mybatis-config.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>
<properties resource="jdbc.properties" />
<typeAliases>
<package name="org.fool.mybatis.model" />
</typeAliases>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver" value="${jdbc.driverClassName}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
</dataSource>
</environment>
</environments>
<mappers>
<!-- Using classpath relative resources -->
<mapper resource="mapper/UserMapper.xml" />
<!-- Using mapper interface classes -->
<mapper class="org.fool.mybatis.mapper.UserMapper" />
</mappers>
</configuration>
注意:这里使用UserMapper.xml和UserMapper接口,只是为了说明一下,有两种实现方式,想使用哪种,全看个人喜好。
 
jdbc.properties

jdbc.driverClassName = com.mysql.jdbc.Driver
jdbc.url = jdbc:mysql://localhost:3306/test?useUnicode=true&amp;characterEncoding=UTF-8
jdbc.username = root
jdbc.password = 123456

 
schema.sql

drop table if exists t_user ;
create table t_user
(
uid integer not null auto_increment,
username varchar(20) not null,
password varchar(20) not null,
nickname varchar(20) not null,
email varchar(30) not null,
constraint user_uid_pk primary key(uid)
);
insert into t_user(username, password, nickname, email)
values("mybatis", "mybatis", "orm", "mybatis@orm.org");
insert into t_user(username, password, nickname, email)
values("mybatis", "mybatis", "orm", "mybatis@orm.org");
insert into t_user(username, password, nickname, email)
values("mybatis", "mybatis", "orm", "mybatis@orm.org");
insert into t_user(username, password, nickname, email)
values("mybatis", "mybatis", "orm", "mybatis@orm.org");
insert into t_user(username, password, nickname, email)
values("mybatis", "mybatis", "orm", "mybatis@orm.org");
insert into t_user(username, password, nickname, email)
values("mybatis", "mybatis", "orm", "mybatis@orm.org");
insert into t_user(username, password, nickname, email)
values("mybatis", "mybatis", "orm", "mybatis@orm.org");
insert into t_user(username, password, nickname, email)
values("mybatis", "mybatis", "orm", "mybatis@orm.org");
insert into t_user(username, password, nickname, email)
values("mybatis", "mybatis", "orm", "mybatis@orm.org");
insert into t_user(username, password, nickname, email)
values("mybatis", "mybatis", "orm", "mybatis@orm.org");
commit;

 
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="org.fool.mybatis.model.User">
<insert id="add" parameterType="User">
insert into t_user(username, password, nickname, email)
values(#{username}, #{password}, #{nickname}, #{email})
</insert>
<update id="update" parameterType="User">
update t_user set password = #{password}, nickname = #{nickname}, email = #{email}
where uid = #{uid}
</update>
<delete id="delete" parameterType="int">
delete from t_user where uid = #{uid}
</delete>
<select id="load" parameterType="int" resultType="User">
select * from t_user where uid = #{uid}
</select>
<select id="list" resultType="User">
select * from t_user
</select>
<select id="load_by_username" parameterType="string" resultType="User">
select * from t_user where username = #{username}
</select>
</mapper>
 

4.src/main/java

User.java

package org.fool.mybatis.model;
public class User
{
private int uid;
private String username;
private String password;
private String nickname;
private String email;
public int getUid()
{
return uid;
}
public void setUid(int uid)
{
this.uid = uid;
}
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;
}
public String getNickname()
{
return nickname;
}
public void setNickname(String nickname)
{
this.nickname = nickname;
}
public String getEmail()
{
return email;
}
public void setEmail(String email)
{
this.email = email;
}
@Override
public String toString()
{
return "User [uid=" + uid + ", username=" + username + ", password="
+ password + ", nickname=" + nickname + ", email=" + email
+ "]";
}
}

 MyBatisUtil.java

package org.fool.mybatis.util;
import java.io.IOException;
import java.io.InputStream;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
public class MyBatisUtil
{
private static SqlSessionFactory sessionFactory;
private MyBatisUtil()
{
}
static
{
try
{
InputStream is = Resources
.getResourceAsStream("mybatis-config.xml");
sessionFactory = new SqlSessionFactoryBuilder().build(is);
}
catch (IOException e)
{
e.printStackTrace();
}
}
public static SqlSessionFactory getSqlSessionFactory()
{
return sessionFactory;
}
}

 UserMapper.java

package org.fool.mybatis.mapper;
import java.util.List;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.fool.mybatis.model.User;
public interface UserMapper
{
@Insert("insert into t_user(username, password, nickname, email) values(#{username}, #{password}, #{nickname}, #{email})")
public void add(User user);
@Update("update t_user set password = #{password}, nickname = #{nickname}, email = #{email} where uid = #{uid}")
public void update(User user);
@Delete("delete from t_user where uid = #{uid}")
public void delete(int id);
@Select("select * from t_user where uid = #{uid}")
public User load(int id);
@Select("select * from t_user")
public List<User> list();
@Select("select * from t_user where username = #{username}")
public User loadByUsername(String username);
}

 

5.src/test/java

TestMyBatis.java

package org.fool.mybatis.test;
import java.util.List;
import org.apache.ibatis.session.SqlSession;
import org.fool.mybatis.model.User;
import org.fool.mybatis.util.MyBatisUtil;
import org.junit.Assert;
import org.junit.Test;
public class TestMyBatis
{
@Test
public void testAdd()
{
SqlSession session = MyBatisUtil.getSqlSessionFactory().openSession();
User user = new User();
user.setUsername("Hibernate");
user.setPassword("123456");
user.setNickname("Little Hi");
user.setEmail("hibernate@orm.org");
session.insert(User.class.getName() + ".add", user);
session.commit();
session.close();
}
@Test
public void testLoad()
{
SqlSession session = MyBatisUtil.getSqlSessionFactory().openSession();
User user = session.selectOne(User.class.getName() + ".load", 11);
System.out.println(user);
session.close();
}
@Test
public void testUpdate()
{
SqlSession session = MyBatisUtil.getSqlSessionFactory().openSession();
User user = session.selectOne(User.class.getName() + ".load", 11);
System.out.println(user);
user.setPassword("mybatis");
user.setNickname("orm");
user.setEmail("mybatis@orm.org");
session.update(User.class.getName() + ".update", user);
session.commit();
System.out.println(user);
session.close();
}
@Test
public void testDelete()
{
SqlSession session = MyBatisUtil.getSqlSessionFactory().openSession();
User user = session.selectOne(User.class.getName() + ".load", 11);
System.out.println(user);
session.delete(User.class.getName() + ".delete", user);
session.commit();
session.close();
}
@Test
public void testList()
{
SqlSession session = MyBatisUtil.getSqlSessionFactory().openSession();
List<User> users = session.selectList(User.class.getName() + ".list",
null);
Assert.assertEquals(10, users.size());
session.close();
}
@Test
public void testLoadByUsername()
{
SqlSession session = MyBatisUtil.getSqlSessionFactory().openSession();
User user = session.selectOne(User.class.getName()
+ ".load_by_username", "Hibernate");
System.out.println(user);
session.close();
}
}

 TestMyBatisByMapper.java

package org.fool.mybatis.test;
import java.util.List;
import org.apache.ibatis.session.SqlSession;
import org.fool.mybatis.mapper.UserMapper;
import org.fool.mybatis.model.User;
import org.fool.mybatis.util.MyBatisUtil;
import org.junit.Assert;
import org.junit.Test;
public class TestMyBatisByMapper
{
@Test
public void testAdd()
{
SqlSession session = MyBatisUtil.getSqlSessionFactory().openSession();
User user = new User();
user.setUsername("Hibernate");
user.setPassword("123456");
user.setNickname("Little Hi");
user.setEmail("hibernate@orm.org");
session.getMapper(UserMapper.class).add(user);
session.commit();
session.close();
}
@Test
public void testLoad()
{
SqlSession session = MyBatisUtil.getSqlSessionFactory().openSession();
User user = session.getMapper(UserMapper.class).load(11);
System.out.println(user);
session.close();
}
@Test
public void testUpdate()
{
SqlSession session = MyBatisUtil.getSqlSessionFactory().openSession();
User user = session.getMapper(UserMapper.class).load(11);
System.out.println(user);
user.setPassword("mybatis");
user.setNickname("orm");
user.setEmail("mybatis@orm.org");
session.getMapper(UserMapper.class).update(user);
session.commit();
System.out.println(user);
session.close();
}
@Test
public void testDelete()
{
SqlSession session = MyBatisUtil.getSqlSessionFactory().openSession();
session.getMapper(UserMapper.class).delete(11);
session.commit();
session.close();
}
@Test
public void testList()
{
SqlSession session = MyBatisUtil.getSqlSessionFactory().openSession();
List<User> users = session.getMapper(UserMapper.class).list();
Assert.assertEquals(10, users.size());
session.close();
}
@Test
public void testLoadByUsername()
{
SqlSession session = MyBatisUtil.getSqlSessionFactory().openSession();
User user = session.getMapper(UserMapper.class).loadByUsername(
"Hibernate");
System.out.println(user);
session.close();
}
}

 

 6.Best in Practice
  创建相应的MyBatisUtil完成对Session的获取
  不使用annotation完成sql的映射
 
 
 
 

运维网声明 1、欢迎大家加入本站运维交流群:群②:261659950 群⑤:202807635 群⑦870801961 群⑧679858003
2、本站所有主题由该帖子作者发表,该帖子作者与运维网享有帖子相关版权
3、所有作品的著作权均归原作者享有,请您和我们一样尊重他人的著作权等合法权益。如果您对作品感到满意,请购买正版
4、禁止制作、复制、发布和传播具有反动、淫秽、色情、暴力、凶杀等内容的信息,一经发现立即删除。若您因此触犯法律,一切后果自负,我们对此不承担任何责任
5、所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其内容的准确性、可靠性、正当性、安全性、合法性等负责,亦不承担任何法律责任
6、所有作品仅供您个人学习、研究或欣赏,不得用于商业或者其他用途,否则,一切后果均由您自己承担,我们对此不承担任何法律责任
7、如涉及侵犯版权等问题,请您及时通知我们,我们将立即采取措施予以解决
8、联系人Email:admin@iyunv.com 网址:www.yunweiku.com

所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其承担任何法律责任,如涉及侵犯版权等问题,请您及时通知我们,我们将立即处理,联系人Email:kefu@iyunv.com,QQ:1061981298 本贴地址:https://www.yunweiku.com/thread-304561-1-1.html 上篇帖子: 【MyBatis入门】—— 第一个MyBatis应用 下篇帖子: mybatis 注解
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

扫码加入运维网微信交流群X

扫码加入运维网微信交流群

扫描二维码加入运维网微信交流群,最新一手资源尽在官方微信交流群!快快加入我们吧...

扫描微信二维码查看详情

客服E-mail:kefu@iyunv.com 客服QQ:1061981298


QQ群⑦:运维网交流群⑦ QQ群⑧:运维网交流群⑧ k8s群:运维网kubernetes交流群


提醒:禁止发布任何违反国家法律、法规的言论与图片等内容;本站内容均来自个人观点与网络等信息,非本站认同之观点.


本站大部分资源是网友从网上搜集分享而来,其版权均归原作者及其网站所有,我们尊重他人的合法权益,如有内容侵犯您的合法权益,请及时与我们联系进行核实删除!



合作伙伴: 青云cloud

快速回复 返回顶部 返回列表