項目的目錄結構：
很簡單。Account是要組裝的Domain對象，AccountDAO是測試類，
mapper/Account.xml保存了兩條Account的查詢語句，而mybatis.cfg.xml
是數據庫連接的配置。
package com.cdai.orm.mybatis;
public class Account {
private long id;
private long balance;
public Account() {
}
public long getId() {
return id;
}
public void setId(long id) {
this.id = id;
}
public long getBalance() {
return balance;
}
public void setBalance(long balance) {
this.balance = balance;
}
@Override
public String toString() {
return "Account [id=" + id + ", balance=" + balance + "]";
}
}
<?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>
<typeAliases>
<typeAlias alias="Account" type="com.cdai.orm.mybatis.Account" />
</typeAliases>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
<property name="url" value="jdbc:sqlserver://192.168.1.102:1433;databaseName=Bank" />
<property name="username" value="sa" />
<property name="password" value="1qaz2wsx" />
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="mapper/Account.xml" />
</mappers>
</configuration>
<?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="Account">
<select id="selectAccount" parameterType="int" resultType="Account">
<![CDATA[
SELECT col_id AS id, col_balance AS balance
FROM tb_account
]]>
</select>
<select id="selectAccountById" parameterType="int" resultType="Account">
<![CDATA[
SELECT col_id AS id, col_balance AS balance FROM tb_account WHERE col_id = #{id}
]]>
</select>
</mapper>
package com.cdai.orm.mybatis;
import java.io.IOException;
import java.io.Reader;
import java.util.List;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
public class AccountDAO {
@SuppressWarnings("unchecked")
public static void main(String[] args) {
String resource = "mybatis.cfg.xml";
try {
Reader reader = Resources.getResourceAsReader(resource);
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
SqlSession session = sessionFactory.openSession();
List<Account> accounts = (List<Account>) session.selectList("selectAccount");
for (Account account : accounts) {
System.out.println(account);
}
Account account = (Account) session.selectOne("selectAccountById", 2);
System.out.println(account);
session.close();
}
catch (IOException e) {
e.printStackTrace();
}
}
}
更多文章、技術交流、商務合作、聯系博主
微信掃碼或搜索：z360901061
微信掃一掃加我為好友
QQ號聯系： 360901061
您的支持是博主寫作最大的動力，如果您喜歡我的文章，感覺我的文章對您有幫助，請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧，狠狠點擊下面給點支持吧，站長非常感激您！手機微信長按不能支付解決辦法：請將微信支付二維碼保存到相冊，切換到微信，然后點擊微信右上角掃一掃功能，選擇支付二維碼完成支付。
【本文對您有幫助就好】元
