本文共 2944 字,大约阅读时间需要 9 分钟。
接口定义:
package cn.et.lession02.xml;public interface UserInfoMapper { public UserInfo selectUserInfo(String id);}mybatis.xml内容
UserInfoMapper.xml内容
main方法
package cn.et.lession02.xml;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;public class TestHelloWorld { public static void main(String[] args) throws Exception { // 指定核心配置文件的位置 String resource = "cn/et/lession02/xml/mybatis.xml"; // 读取配置文件 InputStream inputStream = Resources.getResourceAsStream(resource); // SqlSessionFactoryBuilder构建工厂类 SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream); // 工厂类获取SqlSession实例 SqlSession session = sqlSessionFactory.openSession(); //通过session获取UserInfoMapper.xml连接的接口 UserInfoMapper user = (UserInfoMapper) session.getMapper(UserInfoMapper.class); //通过接口的传递参数进入UserInfoMapper.xml里的sql进行查询,查询的结果返回给接口的方法 UserInfo userInfo = user.selectUserInfo("1"); //输出 System.out.println(userInfo); }}
接口定义
package cn.et.lession02.annotion;import org.apache.ibatis.annotations.Param;import org.apache.ibatis.annotations.Select;public interface UserInfoMapper { @Select(" select * from UserInfo where uid = #{uid}") public UserInfo selectUserInfo(@Param("uid")String uid);}mybatis.xml内容
main方法
package cn.et.lession02.annotion;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;public class TestHelloWorld { public static void main(String[] args) throws Exception { // 指定核心配置文件的位置 String resource = "cn/et/lession02/annotion/mybatis.xml"; // 读取配置文件 InputStream inputStream = Resources.getResourceAsStream(resource); // SqlSessionFactoryBuilder构建工厂类 SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream); // 工厂类获取SqlSession实例 SqlSession session = sqlSessionFactory.openSession(); //通过session获取UserInfoMapper.xml连接的接口 UserInfoMapper user = (UserInfoMapper) session.getMapper(UserInfoMapper.class); //通过接口的传递参数进入UserInfoMapper.xml里的sql进行查询,查询的结果返回给接口的方法 UserInfo userInfo = user.selectUserInfo("2"); //输出 System.out.println(userInfo); }}
转载地址:http://ynzsi.baihongyu.com/