Ibatis的使用-I

首先,先介绍一下关于Ibatis的使用,代码结构如下:

 

user.sql如下:

create table users
(
    id int primary key auto_increment,
    username varchar(20),
    password varchar(10)
);

 

IbatisFactory.java如下:

package com.dao; import java.io.Reader; import com.ibatis.common.resources.Resources; import com.ibatis.sqlmap.client.SqlMapClient; import com.ibatis.sqlmap.client.SqlMapClientBuilder; public class IbatisFactory { private static final SqlMapClient sqlMap; private static final String resource = "./SqlMapConfig.xml"; static { try { Reader reader = Resources.getResourceAsReader(resource); sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader); } catch(Exception e) { e.printStackTrace(); throw new RuntimeException("Error initializing MyAppSqlConfig class. Cause:"+ e); } } public static SqlMapClient getSqlMap() { return sqlMap; } }
User.java如下:

package com.entity; public class User { private int id; private String username; private String password; /** * @return the id */ public int getId() { return id; } /** * @param id * the id to set */ public void setId(int id) { this.id = id; } /** * @return the password */ public String getPassword() { return password; } /** * @param password * the password to set */ public void setPassword(String password) { this.password = password; } /** * @return the username */ public String getUsername() { return username; } /** * @param username * the username to set */ public void setUsername(String username) { this.username = username; } }

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"> <!-- Use type aliases to avoid typing the full classname every time. --> <typeAlias alias="User" type="com.entity.User"/> <!-- Result maps describe the mapping between the columns returned from a query, and the class properties. A result map isn't necessary if the columns (or aliases) match to the properties exactly. --> <resultMap id="UserResult" class="User"> <result property="id" column="id"/> <result property="username" column="username"/> <result property="password" column="password"/> </resultMap> <!-- Select with no parameters using the result map for Account class. --> <select id="selectAllFromUser" resultMap="UserResult"> select * from users </select> <!-- A simpler select example without the result map. Note the aliases to match the properties of the target result class. --> <select id="selectUserById" parameterClass="int" resultClass="User"> select id as id, username as username, password as password from users where id = #id# </select> <!-- Insert example, using the Account parameter class --> <insert id="insertUser" parameterClass="User"> <!-- 配置mysql主键自动增长,可以省略 <selectKey keyProperty="id" resultClass="int"> SELECT LAST_INSERT_ID() as value </selectKey> --> <!-- 配置Oracle主键自动增长 <selectKey resultClass="int" keyProperty="id" type="pre"> <!--[CDATA[SELECT STOCKIDSEQUENCE.NEXTVAL AS ID FROM DUAL]]> </selectKey>--> <!-- 配置MSServer主键自动增长 <selectKey resultClass="int" keyProperty="id"> <![CDATA[SELECT SCOPE_IDENTITY() AS ID ]]> </selectKey>--> <![CDATA[ insert into users ( username, password ) values ( #username#,#password# ) ]]--> </insert> <!-- Update example, using the Account parameter class --> <update id="updateUserByName" parameterClass="User"> update users set password = #password# where username=#username# </update> <!-- Delete example, using an integer as the parameter class --> <delete id="deleteUserByName" parameterClass="String"> delete from users where username=#username# </delete> </sqlMap>

 

配置SqlMapConfig.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"> <sqlMapConfig> <settings cacheModelsEnabled="true" enhancementEnabled="true" lazyLoadingEnabled="true" maxRequests="32" maxSessions="10" maxTransactions="5" useStatementNamespaces="false" /> <!-- Configure a built-in transaction manager. If you're using an app server, you probably want to use its transaction manager and a managed datasource --> <transactionManager type="JDBC" commitRequired="false"> <dataSource type="SIMPLE"> <property name="JDBC.Driver" value="com.mysql.jdbc.Driver"/> <property name="JDBC.ConnectionURL" value="jdbc:mysql://localhost/test"/> <property name="JDBC.Username" value="root"/> <property name="JDBC.Password" value="root"/> </dataSource> </transactionManager> <!-- List the SQL Map XML files. They can be loaded from the classpath, as they are here (com.domain.data...) --> <sqlMap resource="com/entity/User.xml"/> <!-- List more here... <sqlMap resource="com/mydomain/data/Order.xml"/> <sqlMap resource="com/mydomain/data/Documents.xml"/> --> </sqlMapConfig>

 

最后,我们使用Main调用一下:

package com.test; import java.sql.SQLException; import com.dao.IbatisFactory; import com.entity.User; import com.ibatis.sqlmap.client.SqlMapClient; public class IbatisTest { public static void main(String[] args) { User u1 = new User(); u1.setUsername("aa"); u1.setPassword("1111"); SqlMapClient sqlMap = IbatisFactory.getSqlMap(); try { sqlMap.startTransaction(); sqlMap.insert("insertUser", u1); sqlMap.commitTransaction(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }

 

 

 

接下来可看此文章:http://www.cnblogs.com/JavaVillage/archive/2008/12/03/1346685.html