学步园

iBatis简单使用

1.模型类

package ibatis;</p> <p>public class User {</p> <p> private int id;<br /> private String name;<br /> private String password;</p> <p> public User() {}</p> <p> public void setId(int id) {<br /> this.id = id;<br /> }</p> <p> public int getId() {<br /> return id;<br /> }</p> <p> public void setName(String name) {<br /> this.name = name;<br /> }</p> <p> public String getName() {<br /> return name;<br /> }</p> <p> public void setPassword(String password) {<br /> this.password = password;<br /> }</p> <p> public String getPassword() {<br /> return password;<br /> }</p> <p> public String toString() {<br /> return name;<br /> }</p> <p>}<br />

2.User.xml    SqlMap配置文件

<?xml version="1.0" encoding="UTF-8" ?></p> <p><!DOCTYPE sqlMap<br /> PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"<br /> "http://ibatis.apache.org/dtd/sql-map-2.dtd"></p> <p><sqlMap namespace="User"></p> <p> <!-- Use type aliases to avoid typing the full classname every time. --><br /> <typeAlias alias="User" type="ibatis.User"/></p> <p> <!-- Result maps describe the mapping between the columns returned<br /> from a query, and the class properties. A result map isn't<br /> necessary if the columns (or aliases) match to the properties<br /> exactly. --><br /> <resultMap id="UserResult" class="User"><br /> <result property="id" column="id"/><br /> <result property="name" column="name"/><br /> <result property="password" column="password"/><br /> </resultMap></p> <p> <!-- Select with no parameters using the result map for Account class. --><br /> <select id="selectAll" resultMap="UserResult"><br /> select * from `User`<br /> </select></p> <p> <!-- A simpler select example without the result map. Note the<br /> aliases to match the properties of the target result class. --><br /> <select id="selectById" parameterClass="int" resultClass="User"><br /> select<br /> id,<br /> name,<br /> password,<br /> from `User`<br /> where id = #id#<br /> </select></p> <p> <!-- Insert example, using the Account parameter class --><br /> <insert id="insert" parameterClass="User"><br /> insert into `User` (<br /> name,<br /> password )<br /> values (<br /> #name#, #password#<br /> )<br /> </insert></p> <p> <!-- Update example, using the Account parameter class --><br /> <update id="update" parameterClass="User"><br /> update `User` set<br /> name = #name#,<br /> password = #password#<br /> where<br /> id = #id#<br /> </update></p> <p> <!-- Delete example, using an integer as the parameter class --><br /> <delete id="deleteById" parameterClass="int"><br /> delete from `User` where id = #id#<br /> </delete></p> <p></sqlMap>

3.SqlMapConfig.xml文件

<?xml version="1.0" encoding="UTF-8" ?></p> <p><!DOCTYPE sqlMapConfig<br /> PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"<br /> "http://ibatis.apache.org/dtd/sql-map-config-2.dtd"></p> <p><sqlMapConfig></p> <p> <!-- Configure a built-in transaction manager. If you're using an<br /> app server, you probably want to use its transaction manager<br /> and a managed datasource --><br /> <transactionManager type="JDBC" commitRequired="false"><br /> <dataSource type="SIMPLE"><br /> <property name="JDBC.Driver" value="org.gjt.mm.mysql.Driver"/><br /> <property name="JDBC.ConnectionURL" value="jdbc:mysql://localhost:3306/test"/><br /> <property name="JDBC.Username" value="root"/><br /> <property name="JDBC.Password" value="password"/><br /> </dataSource><br /> </transactionManager></p> <p> <sqlMap resource="ibatis/User.xml"/><br /> </sqlMapConfig>

4.TestIbatis

package ibatis;</p> <p>import java.io.IOException;<br /> import java.io.Reader;<br /> import java.sql.SQLException;<br /> import java.util.List;</p> <p>import com.ibatis.common.resources.Resources;<br /> import com.ibatis.sqlmap.client.SqlMapClient;<br /> import com.ibatis.sqlmap.client.SqlMapClientBuilder;</p> <p>public class TestIbatis {</p> <p> public static void main(String[] args) throws IOException, SQLException {<br /> Reader reader = Resources.getResourceAsReader("ibatis/SqlMapConfig.xml");<br /> SqlMapClient sqlMapper = SqlMapClientBuilder.buildSqlMapClient(reader);<br /> User user = new User();<br /> user.setName("user1");<br /> user.setPassword("123456");<br /> sqlMapper.insert("insert", user);<br /> user.setName("user2");<br /> user.setId(1);<br /> sqlMapper.update("update", user);<br /> List users = sqlMapper.queryForList("selectAll");<br /> for (int i = 0; i < users.size(); i++) {<br /> System.out.println(users.get(i));<br /> }<br /> }</p> <p>}