Mybatis连接Oracle数据库实现分页查询和包名用别名表示

 图文详细说明看之前的文章,下面都是实现的核心代码 链接如下：

https://blog.csdn.net/aaassslll147/article/details/113063033

package com.baizhi.dao;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;

import com.baizhi.entity.Account;

public interface AccountDao {

		List<Account> queryByPage(Integer begin,Integer end);
}

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.baizhi.dao.AccountDao">
	
	
	<select id="queryByPage" resultType="Account">
		select card_id,username,password,balance,mobile,rn
		from(select a.*,rownum rn from accounts a)
		where rn &gt; =3 and rn &lt; =6
	</select>
	
</mapper>

package com.baizhi.test;

import java.io.IOException;
import java.io.InputStream;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.jupiter.api.Test;

import com.baizhi.dao.AccountDao;
import com.baizhi.entity.Account;
import com.baizhi.util.MybatisUtil;

public class TestAccountDao {
	
	@Test
	public void testQueryByPage() throws Exception {
		 /* 调用工具类获取SqlSession
		 */
		SqlSession sqlSession = MybatisUtil.opSession();
		//4.获取Dao接口实现类的对象
		AccountDao dao = sqlSession.getMapper(AccountDao.class);
		List<Account> list = dao.queryByPage(1, 2);
		for (Account account : list) {
			System.out.println(account);
		}
		//6.释放资源
		MybatisUtil.close();
	}
	
	
}

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd" >
<configuration>
	<!-- 给实体类起别名 -->
	<typeAliases>
		<!-- type属性值为实体类全限定名
		alias 属性值为别名
		 -->
		<typeAlias type="com.baizhi.entity.Account"  alias="Account"/>	
	</typeAliases>
<!-- 编写mybatis的运行环境 -->
	<environments default="oracle">
		<environment id="oracle">
		<!-- 指定事务采用JDBC的方式管理 -->
			<transactionManager type="JDBC"></transactionManager>
			<!-- 使用mybatis提供的POOLED连接池 -->
			<dataSource type="POOLED">
				<property name="driver" value="oracle.jdbc.OracleDriver"/>
				<property name="url" value="jdbc:oracle:thin:@localhost:1521:ORCL"/>
				<property name="username" value="HR"/>
				<property name="password" value="hr"/>
			</dataSource>
		</environment>
	</environments>
	
	<!-- 注册mapper文件位置 -->
	<mappers>
		<!-- 对mapper标签注册一个mapper文件的位置：路径一定严格大小写 文件用斜杠，包用点 -->
		<mapper resource="com/baizhi/dao/AccountDaoMapper.xml"></mapper>
	</mappers>
	
</configuration>

package com.baizhi.entity;

import java.io.Serializable;

public class Account implements Serializable{
	private Integer card_id;
	private String username;
	private String password;
	private Double balance;
	private String mobile;
	public Integer getCard_id() {
		return card_id;
	}
	public void setCard_id(Integer card_id) {
		this.card_id = card_id;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	public Double getBalance() {
		return balance;
	}
	public void setBalance(Double balance) {
		this.balance = balance;
	}
	public String getMobile() {
		return mobile;
	}
	public void setMobile(String mobile) {
		this.mobile = mobile;
	}
	@Override
	public String toString() {
		return "Account [card_id=" + card_id + ", username=" + username + ", password=" + password + ", balance="
				+ balance + ", mobile=" + mobile + "]";
	}
	public Account(Integer card_id, String username, String password, Double balance, String mobile) {
		super();
		this.card_id = card_id;
		this.username = username;
		this.password = password;
		this.balance = balance;
		this.mobile = mobile;
	}
	public Account() {
		super();
		// TODO Auto-generated constructor stub
	}
	
}

package com.baizhi.util;

import java.io.IOException;
import java.io.InputStream;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import com.baizhi.dao.AccountDao;
import com.baizhi.entity.Account;

public class MybatisUtil {
	public static SqlSessionFactory factory;
	//静态初始代码块，书写只需要执行一次的操作，静态代码块的代码只在类加载的时候执行一次
	static {
		InputStream in = null;
		try {
			//读取核心配置文件mybatis-config.xml
			in = Resources.getResourceAsStream("mybatis-config.xml");
			//创建SqlSessionFactory
			factory = new SqlSessionFactoryBuilder().build(in);
			
		} catch (Exception e) {
			e.printStackTrace();
			throw new RuntimeException("初始化工厂失败");
		}finally {
			try {
				in.close();
			} catch (IOException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
	
	
	//创建一个线程绑定对象
	private static ThreadLocal<SqlSession> tol=new ThreadLocal<SqlSession>();
	//返回一个SqlSession
	public static SqlSession opSession() {
		//先到当前线程取一下
		SqlSession sqlSession =tol.get();
		if(sqlSession==null) {
			//创建SqlSession
			sqlSession = factory.openSession();
			//绑定到当前线程
			tol.set(sqlSession);
		}
		return sqlSession;
	}
	
	//释放资源
	public static void close(){
		SqlSession sqlSession=tol.get();
		if(sqlSession!=null) { 
			sqlSession.close();
			tol.remove();//从当前线程移除
		}
	}
	
	//提交事务
	public static void commit() {
		SqlSession sqlSession=tol.get();
		if(sqlSession!=null) { 
			sqlSession.commit();
		}
	}
	//回滚事务
	public static void rollback() {
		SqlSession sqlSession=tol.get();
		if(sqlSession!=null) { 
			sqlSession.rollback();
		}
	}
}