ibatis_HelloWorld

?

1.导入ibatis-2.3.4.726.jar; mysql-connector-java-5.1.8-bin.jar两个包

2.在pojo包下建一个javabean文件User.Java：

package?pojo;

import?java.util.Date;public?class?User?{

??　　private?int?id;
??　　private?String?name;
??　　private?Date?birthday;

??　　省略get和set方法
}

3.在pojo包下建一个User.xml的映射文件

<?xml?version="1.0"?encoding="UTF-8"??>
<!DOCTYPE?sqlMap?PUBLIC?"-//ibatis.apache.org//DTD?SQL?Map?2.0//EN"
???"http://ibatis.apache.org/dtd/sql-map-2.dtd"><sqlMap??namespace="User">

命名空间以外空间引用此空间时用这个别名引用?-->????????<typeAlias?alias="user"?type="pojo.User"/>
????????????
????????????<select?id="getAllUsers"?resultClass="user">?????????????????select?*?from?user?order?by?id;????????????select>
????????????
????????????<select?id="getUser"?parameterClass="java.lang.String"?resultClass="user">?????????????????select?*?from?user?where?name=#name#;????????????select>
????????????<insert?id="addUser"?parameterClass="user">
?????????????????insert?into?user(id,?name,birthday)?values(#id#,?#name#,?#birthday#);????????????<delete?id="delUser"?parameterClass="java.lang.Integer">
?????????????????delete?from?user?where?id=#id#;????????????<update?id="updateUser"?parameterClass="user">
?????????????????update?user?set?name=#name#,?birthday=#birthday#?where?id?=?#id#

1. src下配置好一个SqlMapConfig.xml文件,主要是负责jdbc的Connection，和与映射相联系(也可以通过.properties文件.xml文件的关系进行配置)

<?xml?version="1.0"?encoding="UTF-8"?>
<!DOCTYPE?sqlMapConfig?PUBLIC?"-//ibatis.apache.org//DTD?SQL?Map?Config?2.0//EN""http://ibatis.apache.org/dtd/sql-map-config-2.dtd">

1. 在test包里建一个UserDaoTest.java进行测试

省略导包。。。。。。和捕捉异常。。。。

public?class?UserDaoTest?{
　　public?static?void?main(String[]?args)?{
????　　//查找根据name来查找
???　　?List?list?=?null;
????　　SqlMapClient?sqlMap?=?null;
????　　User?user?=?new?User();
????　　user.setName("小强");
????　　Reader?reader?=?Resources.getResourceAsReader("SqlMapConfig.xml");
????　　sqlMap?=?SqlMapClientBuilder.buildSqlMapClient(reader);
????　　reader.close();
????　　list?=?sqlMap.queryForList("getUser","小强");
????　　for(int?i=0;i<list.size();i++){
????????　　User?us?=?(User)list.get(i);
????????　　System.out.println("name:"+us.getName()+"--"+"birthday:"+us.getBirthday());
????　　}
?　}
}

?

?