步骤1:配置数据源,事务,运行环境 .xml映射文件
步骤2:创建sqlsessionfactory 对象
步骤3:创建sqlsession对象操作数据库库(增删改查)
步骤4,根据数据参数操作数据库获得输出结果
配置文件SqlMySqlConfig.xml如下
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://www.mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<properties resource=" jdbc.properties"/>
< typeAliases> //定义别名方便的映射文件中使用,两种别名的使用方式如下
<package name="springmybatis.shop.common"/>
<!-- <typeAlias type="itat.shop.model.User" alias="User"/> -->
</typeAliases>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC">
<property name="..." value="..."/>
</transactionManager>
<dataSource type="POOLED">
<property name="driver" value="${driver}"/>
<property name="url" value="${url}"/>
<property name="username" value="${username}"/>
<property name="password" value="${password}"/>
</dataSource>
</environment>
</environments>
< mappers > //告诉mybatis去
<mapper resource ="springmybatis/shop/common/User.xml"/>
</mappers>
</configuration>
jdbc.properties文件内容
username=root
password=123456
url=jdbc:mysql://10.20.0.20:3306/yiibai
driver=com.mysql.jdbc.Driver
实例:
public class test{
private SqlSessionFactory sqlSessionFactory;
@Before
public void setUp() throws Exception{
String resource = "SqlMySqlConfig.xml";
InputStream input = Resources.getResourceAsStream(resource);
sqlSessionFactory = new SqlSessionFactoryBuilder().build(input);
}
@Test
public void selectById() throws Exception{
SqlSession sqlsession = sqlSessionFactory.openSession();
User user=sqlsession.selectOne(User.class.getName()+".selectById",10);
System.out.println(user);
sqlsession.close();
}
}