IAccount
public interface IAccountDAO {
/**
* 查询所有账户
* @return
*/
@Select("select * from account")
public List<Account> findAll();
/**
* 保存账户信息
* @param account
*/
@Insert("insert into account (name,money) valuse (#{name},#{money})")
public void saveAccount(Account account);
}
编写配置文件
resources目录下,
新建xml文件,
命名为:SqlMapConfig.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>
<!--配置环境-->
<environments default="mysql">
<environment id="mysql">
<transactionManager type="JDBC"></transactionManager>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/ssm"/>
<property name="username" value="root"/>
<property name="password" value="root"/>
</dataSource>
</environment>
</environments>
<!--引入映射配置文件-->
<mappers>
<package name="xyz.zhouzhousag.dao"/>
</mappers>
</configuration>
编写测试方法
public class TestSpring {
@Test
public void run2TestMybatis() throws Exception {
//1.加载配置文件
InputStream in = Resources.getResourceAsStream("SqlMapConfig.xml");
//2.创建SqlSessionFactroy对象
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in);
//3.创建SqlSession对象
SqlSession session = factory.openSession();
//4.获取代理对象
IAccountDAO dao = session.getMapper(IAccountDAO.class);
//保存数据
Account account = new Account();
account.setMoney(2122.0);
account.setName("zhouzhou");
dao.saveAccount(account);
//提交事务
session.commit();
//5.查询所有数据
List<Account> all = dao.findAll();
for (Account a:all) {
System.out.println(a);
}
//6.关闭资源
session.close();
in.close();
}
}