ibatis
来源:互联网 发布:知乎 污 编辑:程序博客网 时间:2024/06/10 09:19
<?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">
<typeAlias alias="user" type="test.User" />
<select id="getUser" parameterClass="java.lang.String"
resultClass="user">
select name, sex from t_user where name = #name#
</select>
<resultMap id="get-All-User" class="test.User">
<result property="id" column="id"/>
<result property="name" column="name"/>
<result property="sex" column="sex"/>
</resultMap>
<select id="getAllUser" resultMap="get-All-User">
select id,name, sex from t_user
</select>
<update id="updateUser" parameterClass="user">
UPDATE t_user SET name=#name#, sex=#sex# WHERE id = #id#
</update>
<insert id="insertUser" parameterClass="user">
INSERT INTO t_user (name, sex) VALUES (#name#, #sex# )
</insert>
<delete id="deleteUser" parameterClass="java.lang.String">
delete from t_user where id=#value#
</delete>
</sqlMap>
<!DOCTYPE sqlMap
PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap namespace="User">
<typeAlias alias="user" type="test.User" />
<select id="getUser" parameterClass="java.lang.String"
resultClass="user">
select name, sex from t_user where name = #name#
</select>
<resultMap id="get-All-User" class="test.User">
<result property="id" column="id"/>
<result property="name" column="name"/>
<result property="sex" column="sex"/>
</resultMap>
<select id="getAllUser" resultMap="get-All-User">
select id,name, sex from t_user
</select>
<update id="updateUser" parameterClass="user">
UPDATE t_user SET name=#name#, sex=#sex# WHERE id = #id#
</update>
<insert id="insertUser" parameterClass="user">
INSERT INTO t_user (name, sex) VALUES (#name#, #sex# )
</insert>
<delete id="deleteUser" parameterClass="java.lang.String">
delete from t_user where id=#value#
</delete>
</sqlMap>
package test;
import java.sql.SQLException;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Set;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;
public class Test ...{
/** *//**
* @param args
*/
public static Map getAllUsers()...{
String resource = "test/SqlMapConfig.xml";
com.ibatis.sqlmap.client.SqlMapClient sqlMap = null;
List users=null;
Map map=null;
try ...{
java.io.Reader reader = com.ibatis.common.resources.Resources
.getResourceAsReader(resource);
sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
} catch (Exception e) ...{
e.printStackTrace();
}
User user=new User();
user.setName("tengll");
User u1=null;
User u2=new User();
try ...{
sqlMap.startTransaction();
map=sqlMap.queryForMap("getAllUser", null,"id");
// System.out.println(users.size());
/**//*u1=(User) sqlMap.queryForObject("getUser", user);
//System.out.println(u1.getName()+" "+u1.getSex());
u2.setName(u1.getName());
u2.setSex(u1.getSex());*/
sqlMap.commitTransaction();
} catch (SQLException e) ...{
System.out.println(e.getMessage());
} finally ...{
try ...{
sqlMap.endTransaction();
} catch (SQLException e) ...{
e.printStackTrace();
}
}
return map;
}
public static void main(String[] args) ...{
Map users=Test.getAllUsers();
System.out.println(users.size());
Set set= users.entrySet();
Iterator it=set.iterator();
while(it.hasNext())...{
System.out.println(((User)((Map.Entry)it.next()).getValue()).getName());
}
}
}
import java.sql.SQLException;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Set;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;
public class Test ...{
/** *//**
* @param args
*/
public static Map getAllUsers()...{
String resource = "test/SqlMapConfig.xml";
com.ibatis.sqlmap.client.SqlMapClient sqlMap = null;
List users=null;
Map map=null;
try ...{
java.io.Reader reader = com.ibatis.common.resources.Resources
.getResourceAsReader(resource);
sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
} catch (Exception e) ...{
e.printStackTrace();
}
User user=new User();
user.setName("tengll");
User u1=null;
User u2=new User();
try ...{
sqlMap.startTransaction();
map=sqlMap.queryForMap("getAllUser", null,"id");
// System.out.println(users.size());
/**//*u1=(User) sqlMap.queryForObject("getUser", user);
//System.out.println(u1.getName()+" "+u1.getSex());
u2.setName(u1.getName());
u2.setSex(u1.getSex());*/
sqlMap.commitTransaction();
} catch (SQLException e) ...{
System.out.println(e.getMessage());
} finally ...{
try ...{
sqlMap.endTransaction();
} catch (SQLException e) ...{
e.printStackTrace();
}
}
return map;
}
public static void main(String[] args) ...{
Map users=Test.getAllUsers();
System.out.println(users.size());
Set set= users.entrySet();
Iterator it=set.iterator();
while(it.hasNext())...{
System.out.println(((User)((Map.Entry)it.next()).getValue()).getName());
}
}
}
- ibatis
- iBatis
- ibatis
- iBatis
- ibatis
- ibatis
- IBATIS
- ibatis
- iBATIS
- ibatis
- ibatis
- Ibatis
- iBatis
- IBATIS
- ibatis
- ibatis
- ibatis
- ibatis
- 第十二章 使用外部数据
- LumaQQ源码,注解.下载的用户看一下.
- JS 精通,需要精通哪一些(欢迎大家讨论)
- Java 编辑器使用笔记
- 在jsp中获得 Spring的上下文
- ibatis
- apache+php+tomcat的整合配置,重装系统的若干小技巧
- What is the maximum amount of memory any single process on Windows can address? Is this different than the maximum virtual memor
- 翻译的Hibernate的Session的javadoc
- IP层路由决策
- 书:"Pro JavaScript Techniques 精通JavaScript"之取得元素文本内容的通用函数
- 必须掌握的八个【cmd 命令行】
- 在Asterisk上做SIP与IAX的互通试验
- 在Asterisk上做SIP与IAX的互通试验