ibatis基础用法

diao21

于 2013-04-06 16:12:34 发布

阅读量90

点赞数

分类专栏： ibatis 文章标签： ibatis

本文链接：https://blog.csdn.net/diao21/article/details/84415889

版权

ibatis 专栏收录该内容

3 篇文章 0 订阅

订阅专栏


package com.itcast.ibatis;

public class User {

	private int id;
	private String firstname;
	private String lastname;
	private int age;

	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getFirstname() {
		return firstname;
	}
	public void setFirstname(String firstname) {
		this.firstname = firstname;
	}
	public String getLastname() {
		return lastname;
	}
	public void setLastname(String lastname) {
		this.lastname = lastname;
	}
	public int getAge() {
		return age;
	}
	public void setAge(int age) {
		this.age = age;
	}

}


<?xml version="1.0" encoding="GBK" standalone="no"?>
<!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/itcast/ibatis/SqlMap.properties"/>

    <transactionManager type="JDBC">
        <dataSource type="SIMPLE">
            <property name="JDBC.Driver"
                value="${driver}"/>
            <property name="JDBC.ConnectionURL"
                value="${url}"/>
            <property name="JDBC.Username" value="${username}"/>
            <property name="JDBC.Password" value="${password}"/>
        </dataSource>
    </transactionManager> 

    <sqlMap resource="com/itcast/ibatis/User.xml"/>

 </sqlMapConfig>


driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost/mytest
username=***
password=***


<?xml version="1.0" encoding="utf-8" standalone="no"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap>
   <typeAlias alias="User" type="com.itcast.ibatis.User"/>
   <select id="selectAllUsers" resultClass="User">
     select * from user
   </select>
   <insert id="insertUser">
      insert into user(firstname,lastname,age) values(#firstname#,#lastname#,#age#)
   </insert>
   <delete id="deleteUser" parameterClass="int">
      delete from user where id=#id#
   </delete>
   <update id="updateUser" parameterClass="User">
      update user set firstname=#firstname#,lastname=#lastname#,age=#age# where id=#id#
   </update>
   <select id="selectUserByFirstName" parameterClass="java.lang.String" resultClass="User">
      select * from user where firstname like '%$firstname$%'
   </select>
   <select id="selectUserById" parameterClass="int" resultClass="User">
	  select * from user where id=#id#
   </select>
</sqlMap>


package com.itcast.ibatis;

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.engine.builder.xml.XmlSqlMapClientBuilder;

public class TestIbatis {

	public static void main(String[] args) throws IOException, SQLException	
	{
		Reader reader = Resources.getResourceAsReader("com/itcast/ibatis/SqlMapConfig.xml");	
		XmlSqlMapClientBuilder xmlBuilder = new XmlSqlMapClientBuilder();
		SqlMapClient sqlMapClient = xmlBuilder.buildSqlMap(reader);
/*		User user = new User();
		List<User> list = sqlMapClient.queryForList("selectAllUsers",user);
		for(User u:list)
		{
			System.out.println(u.getFirstname()+"-----"+u.getLastname());
		}*/

	/*	User u=new User();
		u.setFirstname("green");
		u.setLastname("ice");
		u.setAge(26);

		sqlMapClient.insert("insertUser", u);*/

	//	sqlMapClient.delete("deleteUser", 2);	

/*		User u=new User();
		u.setId(1);
		u.setFirstname("sb");
		u.setLastname("sb");
		u.setAge(36);

		sqlMapClient.update("updateUser",u);*/



		List<User> list = sqlMapClient.queryForList("selectUserByFirstName", "s");  
		for(User u:list)
		{
			System.out.println(u.getFirstname()+"-----"+u.getLastname());
		}

	/*	User user = null;
		user = (User) sqlMapClient.queryForObject("selectUserById", 1);
		System.out.println(user.getFirstname());
		System.out.println(user.getLastname());*/

	}

}