Ibatis基础标签

最新推荐文章于 2021-02-04 15:15:00 发布

志当存高远

最新推荐文章于 2021-02-04 15:15:00 发布

阅读量481

点赞数 1

分类专栏： Ibatis【学习之路】

本文链接：https://blog.csdn.net/haichao1989/article/details/37563313

版权

Ibatis【学习之路】专栏收录该内容

2 篇文章 0 订阅

订阅专栏

PractiseOneMain.java

package net.practise.one.main;

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 PractiseOneMain {

	/**
	 * @param args
	 * @throws IOException 
	 * @throws SQLException 
	 */
	public static void main(String[] args) throws IOException, SQLException {
		// TODO Auto-generated method stub
		Reader reader = Resources.getResourceAsReader("SqlMapConfig.xml");
		SqlMapClient client = SqlMapClientBuilder.buildSqlMapClient(reader);
		System.out.println("====================获取PRACTISEONE所有数据=========================");
		//获取PRACTISEONE所有数据
		List<PractiseOne> practiseOnes = client.queryForList("getAllPractiseOne", "");
		for (PractiseOne practiseOne : practiseOnes) {
			System.out.println( "PractiseId()="+practiseOne.getPractiseId()+
								",PractiseName()="+practiseOne.getPractiseName()+
								",PractiseCount()="+practiseOne.getPractiseCount());
		}
		System.out.println("====================获取isLessEqual数据 [小于等于]========================");
		//获取isLessEqual数据 [小于等于]
		PractiseOne one1 = new PractiseOne();
		one1.setPractiseCount(100);
		List<PractiseOne> practiseOnes1 = client.queryForList("getPractiseOneIsLessEqual", one1);
		for (PractiseOne practiseOne : practiseOnes1) {
			System.out.println( "PractiseId()="+practiseOne.getPractiseId()+
					",PractiseName()="+practiseOne.getPractiseName()+
					",PractiseCount()="+practiseOne.getPractiseCount());
		}
		System.out.println("=====================获取isLessThan数据 [小于]=========================");
		//获取isLessThan数据 [小于]
		PractiseOne one2 = new PractiseOne();
		one2.setPractiseCount(100);
		List<PractiseOne> practiseOnes2 = client.queryForList("getPractiseOneIsLessThan", one2);
		for (PractiseOne practiseOne : practiseOnes2) {
			System.out.println( "PractiseId()="+practiseOne.getPractiseId()+
					",PractiseName()="+practiseOne.getPractiseName()+
					",PractiseCount()="+practiseOne.getPractiseCount());
		}
		System.out.println("=====================获取isGreaterEqual数据 [大于等于]========================");
		//获取isGreaterEqual数据 [大于等于]
		PractiseOne one3 = new PractiseOne();
		one3.setPractiseCount(200);
		List<PractiseOne> practiseOnes3 = client.queryForList("getPractiseOneIsGreaterEqual", one3);
		for (PractiseOne practiseOne : practiseOnes3) {
			System.out.println( "PractiseId()="+practiseOne.getPractiseId()+
					",PractiseName()="+practiseOne.getPractiseName()+
					",PractiseCount()="+practiseOne.getPractiseCount());
		}
		System.out.println("=====================获取isGreaterThan数据 [大于]========================");
		//获取isGreaterThan数据 [大于]
		PractiseOne one4 = new PractiseOne();
		one4.setPractiseCount(300);
		List<PractiseOne> practiseOnes4 = client.queryForList("getPractiseOneIsGreaterThan", one4);
		for (PractiseOne practiseOne : practiseOnes4) {
			System.out.println( "PractiseId()="+practiseOne.getPractiseId()+
					",PractiseName()="+practiseOne.getPractiseName()+
					",PractiseCount()="+practiseOne.getPractiseCount());
		}
		System.out.println("=====================获取isEmpty数据 [可以为空\"\",null]========================");
		//获取isEmpty数据 [可以为空 "",null]
		PractiseOne one5 = new PractiseOne();
		one5.setPractiseName("");
		List<PractiseOne> practiseOnes5 = client.queryForList("getPractiseOneIsEmpty", one5);
		for (PractiseOne practiseOne : practiseOnes5) {
			System.out.println( "PractiseId()="+practiseOne.getPractiseId()+
					",PractiseName()="+practiseOne.getPractiseName()+
					",PractiseCount()="+practiseOne.getPractiseCount());
		}
		PractiseOne one6 = new PractiseOne();
		one6.setPractiseName(null);
		List<PractiseOne> practiseOnes6 = client.queryForList("getPractiseOneIsEmpty", one6);
		for (PractiseOne practiseOne : practiseOnes6) {
			System.out.println( "PractiseId()="+practiseOne.getPractiseId()+
					",PractiseName()="+practiseOne.getPractiseName()+
					",PractiseCount()="+practiseOne.getPractiseCount());
		}
		System.out.println("======================获取isNotEmpty数据 [不可以为空\"\",null]=======================");
		//获取isNotEmpty数据 [不可以为空 "",null]
		PractiseOne one7 = new PractiseOne();
		one7.setPractiseName("PRACTISENAMEONE");
		List<PractiseOne> practiseOnes7 = client.queryForList("getPractiseOneIsNotEmpty", one7);
		for (PractiseOne practiseOne : practiseOnes7) {
			System.out.println( "PractiseId()="+practiseOne.getPractiseId()+
					",PractiseName()="+practiseOne.getPractiseName()+
					",PractiseCount()="+practiseOne.getPractiseCount());
		}
		System.out.println("======================获取isEqual数据 [判断是否相等]========================");
		//获取isEqual数据 [判断是否相等]
		PractiseOne one8 = new PractiseOne();
		one8.setPractiseName("PRACTISENAMEONE");
		List<PractiseOne> practiseOnes8 = client.queryForList("getPractiseOneIsEqual", one8);
		for (PractiseOne practiseOne : practiseOnes8) {
			System.out.println( "PractiseId()="+practiseOne.getPractiseId()+
					",PractiseName()="+practiseOne.getPractiseName()+
					",PractiseCount()="+practiseOne.getPractiseCount());
		}
		System.out.println("======================获取isNotEqual数据 [判断是否不相等]=======================");
		//获取isNotEqual数据 [判断是否不相等]
		PractiseOne one9 = new PractiseOne();
		one9.setPractiseName("PRACTISENAMETWO");
		List<PractiseOne> practiseOnes9 = client.queryForList("getPractiseOneIsNotEqual", one9);
		for (PractiseOne practiseOne : practiseOnes9) {
			System.out.println( "PractiseId()="+practiseOne.getPractiseId()+
					",PractiseName()="+practiseOne.getPractiseName()+
					",PractiseCount()="+practiseOne.getPractiseCount());
		}
		System.out.println("======================获取isNull数据 [判断是否为空]=======================");
		//获取isNull数据 [判断是否为空]
		PractiseOne one10 = new PractiseOne();
		one10.setPractiseName(null);
		List<PractiseOne> practiseOnes10 = client.queryForList("getPractiseOneIsNull", one10);
		for (PractiseOne practiseOne : practiseOnes10) {
			System.out.println( "PractiseId()="+practiseOne.getPractiseId()+
					",PractiseName()="+practiseOne.getPractiseName()+
					",PractiseCount()="+practiseOne.getPractiseCount());
		}
		System.out.println("======================获取isNotNull数据 [判断是否不为空]=======================");
		//获取isNotNull数据 [判断是否不为空]
		PractiseOne one11 = new PractiseOne();
		one11.setPractiseName("PRACTISENAMETWO");
		List<PractiseOne> practiseOnes11 = client.queryForList("getPractiseOneIsNotNull", one11);
		for (PractiseOne practiseOne : practiseOnes11) {
			System.out.println( "PractiseId()="+practiseOne.getPractiseId()+
					",PractiseName()="+practiseOne.getPractiseName()+
					",PractiseCount()="+practiseOne.getPractiseCount());
		}
		System.out.println("=====================获取isPropertyAvailable数据 [判断是否有此属性]=======================");
		//获取isPropertyAvailable数据 [判断是否有此属性]
		PractiseOne one12 = new PractiseOne();
		one12.setPractiseName("PRACTISENAMETWO");
		List<PractiseOne> practiseOnes12 = client.queryForList("getPractiseOneIsNotNull", one12);
		for (PractiseOne practiseOne : practiseOnes12) {
			System.out.println( "PractiseId()="+practiseOne.getPractiseId()+
					",PractiseName()="+practiseOne.getPractiseName()+
					",PractiseCount()="+practiseOne.getPractiseCount());
		}
		System.out.println("======================获取isNotPropertyAvailable数据 [判断是否无此属性]=======================");
		//获取isNotPropertyAvailable数据 [判断是否无此属性]
		PractiseOne one13 = new PractiseOne();
		one13.setPractiseName("PRACTISENAMETWO");
		List<PractiseOne> practiseOnes13 = client.queryForList("getPractiseOneIsNotPropertyAvailable", one13);
		for (PractiseOne practiseOne : practiseOnes13) {
			System.out.println( "PractiseId()="+practiseOne.getPractiseId()+
					",PractiseName()="+practiseOne.getPractiseName()+
					",PractiseCount()="+practiseOne.getPractiseCount());
		}
		System.out.println("======================获取isParameterPresent数据 [判断是否对象不为空]=======================");
		//获取isParameterPresent数据 [判断是否对象不为空]
		PractiseOne one14 = new PractiseOne();
		one14.setPractiseName("PRACTISENAMETWO");
		List<PractiseOne> practiseOnes14 = client.queryForList("getPractiseOneIsParameterPresent", one14);
		for (PractiseOne practiseOne : practiseOnes14) {
			System.out.println( "PractiseId()="+practiseOne.getPractiseId()+
					",PractiseName()="+practiseOne.getPractiseName()+
					",PractiseCount()="+practiseOne.getPractiseCount());
		}
		System.out.println("======================isNotParameterPresent [判断是否对象为空]=======================");
		//获取isNotParameterPresent数据 [判断是否对象不为空]
		PractiseOne one15 = new PractiseOne();
		one15.setPractiseName("PRACTISENAMETWO");
		List<PractiseOne> practiseOnes15 = client.queryForList("getPractiseOneIsNotParameterPresent", null);
		for (PractiseOne practiseOne : practiseOnes15) {
			System.out.println( "PractiseId()="+practiseOne.getPractiseId()+
					",PractiseName()="+practiseOne.getPractiseName()+
					",PractiseCount()="+practiseOne.getPractiseCount());
		}
	}

}

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>
	<settings lazyLoadingEnabled="true" enhancementEnabled="true"/>
	<transactionManager type="JDBC">
		<dataSource type="SIMPLE">
			<property name="JDBC.Driver" value="oracle.jdbc.driver.OracleDriver"/>
			<property name="JDBC.ConnectionURL" value="jdbc:oracle:thin:@localhost:1521:benjipractise"/>
			<property name="JDBC.Username" value="benjipractise"/>
			<property name="JDBC.Password" value="benjipractise"/>
		</dataSource>
	</transactionManager>
	
	<sqlMap resource="SqlMapPractiseOne.xml"/>
</sqlMapConfig>

SqlMapPractiseOne.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>
	
	<select id="getAllPractiseOne" resultClass="net.practise.one.main.PractiseOne">
		SELECT * FROM PRACTISE_ONE
	</select>
	
	<select id="getPractiseOneIsLessEqual" parameterClass="net.practise.one.main.PractiseOne"
		resultClass="net.practise.one.main.PractiseOne">
		SELECT * FROM PRACTISE_ONE
		<dynamic prepend="WHERE">
			<isLessEqual property="practiseCount" compareValue="100">
				PRACTISECOUNT = #practiseCount#
			</isLessEqual>
		</dynamic>
	</select>
	
	<select id="getPractiseOneIsLessThan" parameterClass="net.practise.one.main.PractiseOne"
		resultClass="net.practise.one.main.PractiseOne">
		SELECT * FROM PRACTISE_ONE
		<dynamic prepend="WHERE">
			<isLessThan property="practiseCount" compareValue="200">
				PRACTISECOUNT = #practiseCount#
			</isLessThan>
		</dynamic>
	</select>
	
	<select id="getPractiseOneIsGreaterEqual" parameterClass="net.practise.one.main.PractiseOne"
		resultClass="net.practise.one.main.PractiseOne">
		SELECT * FROM PRACTISE_ONE
		<dynamic prepend="WHERE">
			<isGreaterEqual property="practiseCount" compareValue="200">
				PRACTISECOUNT = #practiseCount#
			</isGreaterEqual>
		</dynamic>
	</select>
	
	<select id="getPractiseOneIsGreaterThan" parameterClass="net.practise.one.main.PractiseOne"
		resultClass="net.practise.one.main.PractiseOne">
		SELECT * FROM PRACTISE_ONE
		<dynamic prepend="WHERE">
			<isGreaterThan property="practiseCount" compareValue="200">
				PRACTISECOUNT = #practiseCount#
			</isGreaterThan>
		</dynamic>
	</select>
	
	<select id="getPractiseOneIsEmpty" parameterClass="net.practise.one.main.PractiseOne"
		resultClass="net.practise.one.main.PractiseOne">
		SELECT * FROM PRACTISE_ONE
		<dynamic prepend="WHERE">
			<isEmpty property="practiseName">
				PRACTISENAME = 'PRACTISENAMETWO'
			</isEmpty>
		</dynamic>
	</select>
	
	<select id="getPractiseOneIsNotEmpty" parameterClass="net.practise.one.main.PractiseOne"
		resultClass="net.practise.one.main.PractiseOne">
		SELECT * FROM PRACTISE_ONE
		<dynamic prepend="WHERE">
			<isNotEmpty property="practiseName">
				PRACTISENAME = #practiseName#
			</isNotEmpty>
		</dynamic>
	</select>
	
	<select id="getPractiseOneIsEqual" parameterClass="net.practise.one.main.PractiseOne"
		resultClass="net.practise.one.main.PractiseOne">
		SELECT * FROM PRACTISE_ONE
		<dynamic prepend="WHERE">
			<isEqual property="practiseName" compareValue="PRACTISENAMEONE">
				PRACTISENAME = #practiseName#
			</isEqual>
		</dynamic>
	</select>
	
	<select id="getPractiseOneIsNotEqual" parameterClass="net.practise.one.main.PractiseOne"
		resultClass="net.practise.one.main.PractiseOne">
		SELECT * FROM PRACTISE_ONE
		<dynamic prepend="WHERE">
			<isNotEqual property="practiseName" compareValue="PRACTISENAMEONE">
				PRACTISENAME = #practiseName#
			</isNotEqual>
		</dynamic>
	</select>
	
	<select id="getPractiseOneIsNull" parameterClass="net.practise.one.main.PractiseOne"
		resultClass="net.practise.one.main.PractiseOne">
		SELECT * FROM PRACTISE_ONE
		<dynamic prepend="WHERE">
			<isNull property="practiseName">
				PRACTISENAME = 'PRACTISENAMEONE'
			</isNull>
		</dynamic>
	</select>
	
	<select id="getPractiseOneIsNotNull" parameterClass="net.practise.one.main.PractiseOne"
		resultClass="net.practise.one.main.PractiseOne">
		SELECT * FROM PRACTISE_ONE
		<dynamic prepend="WHERE">
			<isNotNull property="practiseName">
				PRACTISENAME = #practiseName#
			</isNotNull>
		</dynamic>
	</select>
	
	<select id="getPractiseOneIsPropertyAvailable" parameterClass="net.practise.one.main.PractiseOne"
		resultClass="net.practise.one.main.PractiseOne">
		SELECT * FROM PRACTISE_ONE
		<dynamic prepend="WHERE">
			<isPropertyAvailable property="practiseName">
				PRACTISENAME = #practiseName#
			</isPropertyAvailable>
		</dynamic>
	</select>
	
	<select id="getPractiseOneIsNotPropertyAvailable" parameterClass="net.practise.one.main.PractiseOne"
		resultClass="net.practise.one.main.PractiseOne">
		SELECT * FROM PRACTISE_ONE
		<dynamic prepend="WHERE">
			<isNotPropertyAvailable property="practiseName1">
				PRACTISENAME = 'PRACTISENAMEONE'
			</isNotPropertyAvailable>
		</dynamic>
	</select>
	
	<select id="getPractiseOneIsParameterPresent" parameterClass="net.practise.one.main.PractiseOne"
		resultClass="net.practise.one.main.PractiseOne">
		SELECT * FROM PRACTISE_ONE
		<isParameterPresent prepend="WHERE">
			PRACTISENAME = #practiseName#
		</isParameterPresent>
	</select>
	
	<select id="getPractiseOneIsNotParameterPresent" parameterClass="net.practise.one.main.PractiseOne"
		resultClass="net.practise.one.main.PractiseOne">
		SELECT * FROM PRACTISE_ONE
		<isNotParameterPresent prepend="WHERE">
			PRACTISENAME = 'PRACTISENAMEONE'
		</isNotParameterPresent>
	</select>
</sqlMap>

PractiseOne.java

package net.practise.one.main;

public class PractiseOne {
	private Integer practiseId;
	private String practiseName;
	private Integer practiseCount;
	public Integer getPractiseId() {
		return practiseId;
	}
	public void setPractiseId(Integer practiseId) {
		this.practiseId = practiseId;
	}
	public String getPractiseName() {
		return practiseName;
	}
	public void setPractiseName(String practiseName) {
		this.practiseName = practiseName;
	}
	public Integer getPractiseCount() {
		return practiseCount;
	}
	public void setPractiseCount(Integer practiseCount) {
		this.practiseCount = practiseCount;
	}
	
}

后台输出内容：

=========================获取PRACTISEONE所有数据==============================
PractiseId()=1,PractiseName()=PRACTISENAMEONE,PractiseCount()=100
PractiseId()=2,PractiseName()=PRACTISENAMETWO,PractiseCount()=200
PractiseId()=3,PractiseName()=PRACTISENAMETRHEE,PractiseCount()=300
==========================获取isLessEqual数据 [小于等于]=============================
PractiseId()=1,PractiseName()=PRACTISENAMEONE,PractiseCount()=100
==========================获取isLessThan数据 [小于]=============================
PractiseId()=1,PractiseName()=PRACTISENAMEONE,PractiseCount()=100
==========================获取isGreaterEqual数据 [大于等于]=============================
PractiseId()=2,PractiseName()=PRACTISENAMETWO,PractiseCount()=200
==========================获取isGreaterThan数据 [大于]=============================
PractiseId()=3,PractiseName()=PRACTISENAMETRHEE,PractiseCount()=300
==========================获取isEmpty数据 [可以为空"",null]=============================
PractiseId()=2,PractiseName()=PRACTISENAMETWO,PractiseCount()=200
PractiseId()=2,PractiseName()=PRACTISENAMETWO,PractiseCount()=200
===========================获取isNotEmpty数据 [不可以为空"",null]============================
PractiseId()=1,PractiseName()=PRACTISENAMEONE,PractiseCount()=100
===========================获取isEqual数据 [判断是否相等]============================
PractiseId()=1,PractiseName()=PRACTISENAMEONE,PractiseCount()=100
===========================获取isNotEqual数据 [判断是否不相等]============================
PractiseId()=2,PractiseName()=PRACTISENAMETWO,PractiseCount()=200
===========================获取isNull数据 [判断是否为空]============================
PractiseId()=1,PractiseName()=PRACTISENAMEONE,PractiseCount()=100
===========================获取isNotNull数据 [判断是否不为空]============================
PractiseId()=2,PractiseName()=PRACTISENAMETWO,PractiseCount()=200
===========================获取isPropertyAvailable数据 [判断是否有此属性]============================
PractiseId()=2,PractiseName()=PRACTISENAMETWO,PractiseCount()=200
===========================获取isNotPropertyAvailable数据 [判断是否无此属性]============================
PractiseId()=1,PractiseName()=PRACTISENAMEONE,PractiseCount()=100
===========================获取isParameterPresent数据 [判断是否对象不为空]============================
PractiseId()=2,PractiseName()=PRACTISENAMETWO,PractiseCount()=200
===========================isNotParameterPresent [判断是否对象为空]============================
PractiseId()=1,PractiseName()=PRACTISENAMEONE,PractiseCount()=100