Ibatis初步小结

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>
  <transactionManager type="JDBC">
    <dataSource type="SIMPLE">
      <property name="JDBC.Driver" value="com.mysql.jdbc.Driver"/>
      <property name="JDBC.ConnectionURL" value="jdbc:mysql://localhost/sample"/>
      <property name="JDBC.Username" value="root"/>
      <property name="JDBC.Password" value="root"/>
    </dataSource>
  </transactionManager>

  <sqlMap resource="com/cs/User.xml"/>
</sqlMapConfig>

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">
  <typeAlias alias="User" type="com.cs.User"/>

  <resultMap id="UserResult" class="User">
    <result property="id" column="id"/>
    <result property="name" column="name"/>
    <result property="sex" column="sex"/>
    <result property="address" column="address"/>
  </resultMap>

  <!-- Select with no parameters using the result map for Account class. -->
  <select id="selectAllUser" resultMap="UserResult">
    select * from t_user
  </select>
  
  <select id="selectUserById" resultClass="User" parameterClass="int">
  	select * from t_user where id = #id#
  </select>
  
  <insert id="inserUser" parameterClass="User">
  	<selectKey resultClass="int" keyProperty="id">
  		select LAST_INSERT_ID() as value
  	</selectKey>
  	insert into t_user(id, name, sex, address) 
                   values (#id#, #name#, #sex#, #address#)
  </insert>
  
  <update id="modifyUser" parameterClass="User">
  	update t_user set name=#name#, sex=#sex#, address=#address#
                      where id=#id#
  </update>
  
  <delete id="deleteUser" parameterClass="int">
  	delete from t_user where id = #id#
  </delete>
  
  <select id="selectUserByName" parameterClass="String" resultMap="UserResult">
  	select * from t_user where name = '$name$'
  </select>
</sqlMap>

IUserDao.java

package com.cs;

import java.util.List;

public interface IUserDao {
	public List selectAllUser();
	
	public User selectUserById(int id);
	
	public void addUser(User user);
	
	public void delUser(int id);
	
	public void modifyUser(User user);
	
	public List selectUserByName(String name);
}

UserDaoImpl.java

package com.cs;

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;

public class UserDaoImpl implements IUserDao {
	private static SqlMapClient sqlmapper = null;
	static {
		try {
			Reader reader = Resources.getResourceAsReader("com/cs/SqlMapConfig.xml");
			sqlmapper = SqlMapClientBuilder.buildSqlMapClient(reader);
		} catch (IOException e) {
			e.printStackTrace();
		}
		
	}
	
	public void addUser(User user) {
		try {
			sqlmapper.insert("inserUser", user);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	public void delUser(int id) {
		try {
			sqlmapper.delete("deleteUser", 12);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	public void modifyUser(User user) {
		try {
			sqlmapper.update("modifyUser", user);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	public List selectAllUser() {
		List list = null;
		try {
			list = sqlmapper.queryForList("selectAllUser");
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return list;
	}

	public User selectUserById(int id) {
		User user = null;
		try {
			user = (User)sqlmapper.queryForObject("selectUserById",id);
		} catch (SQLException e) {
			e.printStackTrace();
		}	
		return user;
	}
	
	public List selectUserByName(String name) {
		List list = null;
		try {
			list = sqlmapper.queryForList("selectUserByName", name);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return list;
	}

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		IUserDao userdao = new UserDaoImpl();
		
//      添加USER		
//		User user = new User();
//		user.setId(100);
//		user.setName("cs");
//		user.setSex(1);
//		user.setAddress(2);
//		userdao.addUser(user);
//		
//		List list = userdao.selectAllUser();
//		for(int i=0;i<list.size();i++) {
//			System.out.println(list.get(i));
//		}

//		修改USER
//		User user = new User();
//		user.setId(100);
//		user.setName("cs");
//		user.setSex(2);
//		user.setAddress(1);
//		userdao.modifyUser(user);

//		删除USER
//		userdao.delUser(12);
		
//		模糊查询
//		List list = userdao.selectUserByName("zk");
		
//		查询所有USER
		List list = userdao.selectAllUser();
		for(int i=0;i<list.size();i++) {
			System.out.println(list.get(i));
		}
				
//	    根据ID查询
//		User user = userdao.selectUserById(1);
//		System.out.println(user);
	}
}