在Eclipse中使用Mybatis

来源：互联网发布：济宁网络问政平台登录编辑：程序博客网时间：2024/04/25 20:39

1.新建一个Maven项目，在依赖关系中加入以下依赖关系：

<dependency>      <groupId>org.mybatis</groupId>      <artifactId>mybatis</artifactId>      <version>3.4.4</version>    </dependency>    <dependency>        <groupId>mysql</groupId>        <artifactId>mysql-connector-java</artifactId>        <version>6.0.5</version>    </dependency>

2.新建xml配置文件

<?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>  <environments default="development">    <environment id="development">      <transactionManager type="JDBC"/>      <dataSource type="POOLED">        <property name="driver" value="com.mysql.jdbc.Driver"/>        <property name="url" value="jdbc:mysql://127.0.0.1:3306/vd01"/>        <property name="username" value="videowsdemo"/>        <property name="password" value="videowsdemo"/>      </dataSource>    </environment>  </environments>  <mappers>    <mapper resource=""/>  </mappers></configuration>

3.bean和数据库的映射文件

<?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.lxl.app.config.UserInfoMapper">    <select id="GetUserInfoByID" parameterType="int" resultType="com.lxl.app.beans.UserInfo">        select * from `user_info` where account_id = #{id}    <lect></mapper>

4.测试

public static void main( String[] args ) throws Exception    {        //构建SqlSessionFactory        String resource = "com/lxl/app/config/config.xml";        InputStream inputStream = Resources.getResourceAsStream(resource);        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);        SqlSession ss = sqlSessionFactory.openSession();        try{            UserInfo ui = ss.selectOne("com.lxl.app.config.UserInfoMapper.GetUserInfoByID",2);            if(ui != null){                System.out.println("nickname:"+ui.getNickname());                System.out.println("email:"+ui.getEmail());            }        }finally{            ss.close();        }    }

0 0