1.先准备需要的包,需要下面这些:这里包括MyBatis的依赖包和其自己的包和连接数据库的包。注意版本。
2.其大致的执行过程:
SqlSessionFactoryBulider---->SqlSessionFactory----->SqlSession---->SqlMapper(发送sql和连接了数据库);
3.具体的编写过程:
先看大致的目录结构:
#1.先配置log4j.properties:
log4j.rootLogger=DEBUG,stdout
log4j.logger.org.mybatis=DEBUG
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p %d %c: %m%n
#2.在创建一个POJO对象(即普通java类对象):Role.java
public class Role {
private long id;
private String rolename;
private String note;
public long getId() {
return id;
}
public void setId(long id) {
this.id = id;
}
public String getRolename() {
return rolename;
}
public void setRolename(String rolename) {
this.rolename = rolename;
}
public String getNote() {
return note;
}
public void setNote(String note) {
this.note = note;
}
}
#3.先创建一个映射器的接口(这个类似于以前dao 的接口):RoleMapper.java
public interface RoleMapper {
public int insertRole(Role role);
public int deleteRole(long id);
public int updateRole(Role role);
public Role getRole(long id);
public List<Role> findRoles(String roleName);
#4.再根据上面的映射器接口创建一个映射器来具体实现功能了,这里利用XML的方法。(这个就像以前的daoImple):RoleMapper.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="com.learn.ssm.chapter3.mapper.RoleMapper">
<insert id="insertRole" parameterType="role">
insert into t_role(role_name,note) values(#{roleName},#{note})
</insert>
<delete id="deleteRole" parameterType="long">
delete from t_role where id=#{id}
</delete>
<update id="updateRole" parameterType="role">
update t_role set role_name=#{roleName},note=#{note} where id=#{id}
</update>
<select id="getRole" parameterType="long" resultType="role">
select id,role_name as roleName,note from t_role where id=#{id}
</select>
<select id="findRoles" parameterType="string" resultType="role">
select id,role_name as roleName ,note from t_role where role_name like concat('%',#{roleName},'%')
</select>
</mapper>
其中,<mapper name=映射器接口的地址
#4.完成MyBatista的配置文件: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">
</properties>
<typeAliases><!--别名-->
<typeAlias type="com.learn.ssm.chapter3.pojo.Role" alias="role"/>
</typeAliases>
<!--数据库环境-->
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"></transactionManager>
<dataSource type="POOLED">
<property name="driver" value="${database.driver}"/>
<property name="url" value="${database.url}"/>
<property name="username" value="${database.username}"/>
<property name="password" value="${database.password}"/>
</dataSource>
</environment>
</environments>
<!--映射文件-->
<mappers>
<mapper resource="com/learn/ssm/chapter3/mapper/RoleMapper.xml"/>
</mappers>
</configuration>
其中:1.typeAliases是起别名:如果有多个类,可以再写,也可以对包进行扫描:
<typeAliases>
<package name="com.learn.ssm.chapter4.pojo"/>
</typeAliases>
则其会对该包下面的所有的pojo类对象进行扫描,会将其第一个字母变成小写作为别名。比如Role会变成的role.
如果会有重名,可以使用注解的方式来避免:
在出现重名的Pojo类里用注解:
@Alias("别名”)
上面还要需要一个配置文件:jdbc.properties;
database.driver=com.mysql.jdbc.Driver
database.url=jdbc:mysql://localhost:3306/ssm
database.username=root
database.password=500188
#5.这样就可以创建SqlSessionFactory从而产生SQLSession了。
这里采用单例设计模式:
slqSessionFactoryUtils.java:
public class SqlSessionFactoryUtils {
private final static Class<SqlSessionFactoryUtils> LOCK=SqlSessionFactoryUtils.class;//取得本类对象
private static SqlSessionFactory sqlSessionFactory=null;
private SqlSessionFactoryUtils(){}//单例模式,构造方法的私有化
public static SqlSessionFactory getSqlSessionFactory(){
synchronized (LOCK){
if (sqlSessionFactory != null) {
return sqlSessionFactory;
}
String resource="mybatis-config.xml";
InputStream inputStream;
try {
inputStream=Resources.getResourceAsStream(resource);
sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream);
} catch (IOException e) {
e.printStackTrace();
return null;
}
}
return sqlSessionFactory;
}
public static SqlSession openSqlSession(){
if(sqlSessionFactory==null){
getSqlSessionFactory();
}
return sqlSessionFactory.openSession();
}
}
6.在main中测试:
public class Chapter3Main {
public static void main(String[]args){
Logger log = Logger.getLogger(String.valueOf(Chapter3Main.class));
SqlSession sqlSession=null;
try {
sqlSession=SqlSessionFactoryUtils.openSqlSession();
RoleMapper roleMapper = sqlSession.getMapper(RoleMapper.class);
Role role = roleMapper.getRole(1);
log.info(role.getRolename());
}finally {
if (sqlSession != null) {
sqlSession.close();
}
}
}
}
其流程可以归纳为:
1.配置log4j.properties.
2.创建一个pojo类;
3.创建一个映射器接口(类似以前的dao)
4.利用xml来创建一个映射器
5.配置mybatis的配置文件;
6.创建sqlSessionFactory以及获得sqlsession。(单例模式)
7.测试使用main中。