一个简单的iBatis入门例子

 

一个简单的iBatis入门例子，用ORACLE和Java测试

 

目录结构：

 

 

1.导入iBatis和oracle驱动。

ibatis-2.3.4.726.jar

ojdbc14.jar

 

2.创建类com/you/me/User.java

 

package com.you.me; /** * author:you.me 2010-12-22 * */ public class User { private int id; private String name; private String sex; private int age; private String username; private String password; public User() { } public User(int id, String name, String sex, int age, String username, String password) { super(); this.id = id; this.name = name; this.sex = sex; this.age = age; this.username = username; this.password = password; } public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getSex() { return sex; } public void setSex(String sex) { this.sex = sex; } public int getAge() { return age; } public void setAge(int age) { this.age = age; } public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } }

 

4.数据库配置文件com/you/me/db.properties

driver=oracle.jdbc.driver.OracleDriver url=jdbc:oracle:thin:@127.0.0.1:1521:ORACLEXC user=scott password=tiger 

 

3.配置文件com/you/me/SqlMapConfig.xml

 

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN" "http://www.ibatis.com/dtd/sql-map-config-2.dtd"> <sqlMapConfig> <properties resource="com/you/me/db.properties" /> <transactionManager type="JDBC"> <dataSource type="SIMPLE"> <property name="JDBC.Driver" value="${driver}" /> <property name="JDBC.ConnectionURL" value="${url}" /> <property name="JDBC.Username" value="${user}" /> <property name="JDBC.Password" value="${password}" /> </dataSource> </transactionManager> <sqlMap resource="com/you/me/User.xml" /> </sqlMapConfig>

 

4.配置文件com/you/me/User.xml

 

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd" > <sqlMap namespace="User"> <!-- create table temp_user ( id number primary key , name varchar2(30), sex varchar2(10), age number , username varchar2(30), password varchar2(30)); insert into temp_user values(1,'张三','male',23,'zhangsan','123456'); insert into temp_user values(2,'李四','male',23,'lisi','123456'); commit; --> <select id="getUser" parameterClass="int" resultClass="com.you.me.User"> select id,name,sex,age,username,password from temp_user where id = #id# </select> <select id="getAllUser" resultClass="java.util.List"> select id,name,sex,age,username,password from temp_user </select> <insert id="insertUser" parameterClass="com.you.me.User"> insert into temp_user values(#id#,#name#,#sex#,#age#,#username#,#password#) </insert> <delete id="deleteUser" parameterClass="int"> delete from temp_user where id = #id# </delete> <update id="updateUser" parameterClass="com.you.me.User"> update temp_user set name = #name# , age = #age# , username = #username# , password = #password# where id =#id# </update> </sqlMap>

6.测试类com/you/me/Test.java

 

package com.you.me; import java.io.IOException; import java.io.Reader; import java.sql.SQLException; import java.util.List; import com.ibatis.common.resources.Resources; import com.ibatis.sqlmap.client.SqlMapClient; import com.ibatis.sqlmap.client.SqlMapClientBuilder; /** * author:you.me 2010-12-22 * */ public class Test { static SqlMapClient sqlMapClient = null; static { try { Reader reader = Resources.getResourceAsReader("com/you/me/SqlMapConfig.xml"); sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader); } catch (IOException e) { e.printStackTrace(); } } public static void main(String[] args) throws IOException, SQLException { /**查询FIND BY ID*/ // User user = (User) sqlMapClient.queryForObject("getUser",new Integer(2)); // System.out.println(user.getName()); /**查询FIND ALL*/ // List list = sqlMapClient.queryForList("getAllUser"); // System.out.println(list.size()); /**插入INSERT*/ // User user = new User(3,"王五","male",25,"wangwu","123456"); // sqlMapClient.insert("insertUser",user); /**删除DELETE*/ // sqlMapClient.delete("deleteUser",new Integer(2)); /**修改UPDATE*/ // User user = new User(3,"王老五","male",24,"wanglaowu","123456"); // sqlMapClient.update("updateUser",user); } }