</sqlMap>
<?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="Account"> <!-- no mapping --> <select id="queryUser" resultClass="com.xixi.ibatis.User" parameterClass="string"> SELECT * FROM tb_user WHERE name = #name# </select> <!-- 内联映射 MAP类 --> <select id="queryUser01" resultClass="hashmap" parameterClass="int"> SELECT name, password FROM tb_user WHERE id = #id# </select> <!-- 内联映射 实体类 --> <select id="queryUser02" parameterClass="string" resultClass="com.xixi.ibatis.User"> SELECT Id id, name name, password password FROM tb_user WHERE name like '%$name$%' </select> <!-- 显示映射 实体类 --> <resultMap class="com.xixi.ibatis.User" id="UserResult"> <result property="id" column="Id"/> <result property="name" column="name"/> <result property="password" column="password"/> </resultMap> <select id="queryUser03" resultMap="UserResult" parameterClass="int"> SELECT * FROM tb_user WHERE id = #id# </select> <!-- 显示映射 Map --> <resultMap class="hashmap" id="mapResult"> <result property="id" column="Id"/> <result property="name" column="name"/> <result property="password" column="password"/> </resultMap> <select id="queryMap02" parameterClass="int" resultMap="mapResult"> SELECT * FROM tb_user WHERE id = #id# </select> <!-- XML --> <select id="queryXML" parameterClass="int" resultClass="xml"> SELECT * FROM tb_user WHERE id = #id# </select> <!-- 自动映射 --> <insert id="insertUser01" parameterClass="com.xixi.ibatis.User"> INSERT INTO tb_user ( name, password )VALUES( #name:VARCHAR#, #password:VARCHAR# ) </insert> <!-- 内联映射 --> <insert id="insertUser02" parameterClass="com.xixi.ibatis.User"> INSERT INTO tb_user ( name, password )VALUES( #name:VARCHAR#, #password:VARCHAR# ) </insert> <!-- 外联映射 --> <parameterMap class="com.xixi.ibatis.User" id="usermap"> <parameter property="name" jdbcType="VARCHAR"/> <parameter property="password" jdbcType="VARCHAR"/> </parameterMap> <insert id="insertUser03" parameterMap="usermap"> INSERT INTO tb_user( name, password )VALUES( ?,? ) </insert> <insert id="insertUser04" parameterClass="com.xixi.ibatis.User"> INSERT INTO tb_user( id, name, password )VALUES( #id#, #name#, #password# ) <!-- 这是Mysql的用法 --> <selectKey keyProperty="id" resultClass="int"> SELECT LAST_INSERT_ID() </selectKey> </insert><!-- 调用存储过程 --> <parameterMap class="java.util.Map" id="pro"> <parameter property="name" jdbcType="VARCHAR" javaType="string" mode="IN"/> </parameterMap> <procedure id="p1" parameterMap="pro"> {call first(?)} </procedure></sqlMap>
Java代码
- public void testSelect(){
- Reader reader = null ;
- try {
- reader = Resources.getResourceAsReader("SqlMapConfig.xml");
- SqlMapClient sqlmap = SqlMapClientBuilder.buildSqlMapClient(reader);
-
- List<User> list = sqlmap.queryForList("queryUser", "xixi");
-
- System.out.println(list.get(0).getName());
- } catch (IOException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- }
- public void testSelect02(){
- Reader reader = null ;
- try {
- reader = Resources.getResourceAsReader("SqlMapConfig.xml");
- SqlMapClient sqlmap = SqlMapClientBuilder.buildSqlMapClient(reader);
- List<User> list = sqlmap.queryForList("queryUser02", "x");
-
- for (User user : list) {
- System.out.println(user.getName());
- }
- } catch (IOException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- }
-
- public void testSelect03(){
- Reader reader = null ;
- try {
- reader = Resources.getResourceAsReader("SqlMapConfig.xml");
- SqlMapClient sqlmap = SqlMapClientBuilder.buildSqlMapClient(reader);
-
- User user = (User)sqlmap.queryForObject("queryUser03", 1);
-
- System.out.println(user.getName()+"----"+user.getPassword());
- } catch (IOException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- }
-
- public void testSelect04(){
- Reader reader = null ;
- try {
- reader = Resources.getResourceAsReader("SqlMapConfig.xml");
- SqlMapClient sqlmap = SqlMapClientBuilder.buildSqlMapClient(reader);
-
- Map user = (Map)sqlmap.queryForObject("queryMap02", 2);
-
- System.out.println(user.get("id")+"-------"+user.get("name"));
- } catch (IOException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- }
-
- public void testSelect05(){
- Reader reader = null ;
- try {
- reader = Resources.getResourceAsReader("SqlMapConfig.xml");
- SqlMapClient sqlmap = SqlMapClientBuilder.buildSqlMapClient(reader);
-
- Object user = sqlmap.queryForObject("queryXML", 2);
-
- System.out.println(user);
- } catch (IOException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- }
-
- public void testInsert(){
- Reader reader = null;
- try {
- reader = Resources.getResourceAsReader("SqlMapConfig.xml");
- SqlMapClient sqlmap = SqlMapClientBuilder.buildSqlMapClient(reader);
-
- User user = new User();
- user.setName(" 张三2丰");
- user.setPassword("4569852");
-
- sqlmap.insert("insertUser01", user);
-
- } catch (IOException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- }
-
- public void testInsert02(){
- Reader reader = null;
- try {
- reader = Resources.getResourceAsReader("SqlMapConfig.xml");
- SqlMapClient sqlmap = SqlMapClientBuilder.buildSqlMapClient(reader);
-
- User user = new User();
- user.setName(" 张四丰");
- user.setPassword("4569852");
-
- sqlmap.insert("insertUser02", user);
-
- } catch (IOException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- }
-
- public void testInsert03(){
- Reader reader = null;
- try {
- reader = Resources.getResourceAsReader("SqlMapConfig.xml");
- SqlMapClient sqlmap = SqlMapClientBuilder.buildSqlMapClient(reader);
-
- User user = new User();
- user.setName(" 张无丰555");
- user.setPassword("4569852");
-
- Integer id = (Integer) sqlmap.insert("insertUser03", user);
- System.out.println(id+"-----------");
-
- } catch (IOException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- }
-
- public void testInsert04(){
- Reader reader = null;
- try {
- reader = Resources.getResourceAsReader("SqlMapConfig.xml");
- SqlMapClient sqlmap = SqlMapClientBuilder.buildSqlMapClient(reader);
-
- User user = new User();
- user.setName(" 张无丰666");
- user.setPassword("4569852");
-
- Integer id = (Integer) sqlmap.insert("insertUser04", user);
- System.out.println(id+"-----------");
-
- } catch (IOException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- }
- //调用存储过程
- public void testInsert05(){
- Reader reader = null;
- try {
- reader = Resources.getResourceAsReader("SqlMapConfig.xml");
- SqlMapClient sqlmap = SqlMapClientBuilder.buildSqlMapClient(reader);
-
- Map<String, String> m = new HashMap<String, String>();
- m.put("name", "xxxxxxxxxxxx");
-
- sqlmap.update("p1", m);
- System.out.println("-----------");
-
- } catch (IOException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- }