Mybatis环境

第一步：下载jar包并导入

1、mysql驱动包

2、mybatis环境包

第二步：创建MYSQL数据库

由于这是用于测试，只创建了test-usreinfo数据表

第三步：在src文件夹中创建mybatis-cfg.xml（mybatis全局配置文件）

<?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="mybatis-mysql">
		<environment id="mybatis-mysql">
			<transactionManager type="jdbc"></transactionManager>
			<dataSource type="POOLED">
				<property name="driver" value="com.mysql.jdbc.Driver" />
				<property name="url" value="jdbc:mysql://127.0.0.1:3306/test" />
				<property name="username" value="root" />
				<property name="password" value="" />
			</dataSource>
		</environment>
	</environments>
	

</configuration>

第四步：在src文件中撞见jar包

1、com.shengmu.model:数据模型包

2、com.shengmu.util：处理工具包

3、com.shengmu.DAO：数据库操作包

4、com.shengmu.test：测试包

第五步：在com.shengmu.model:数据模型包创建User.class

 1 package com.shengmu.model;
 2 
 3 public class User {
 4     
 5     private int id;
 6     private String username;
 7     private String userpaw;
 8     public int getId() {
 9         return id;
10     }
11     public void setId(int id) {
12         this.id = id;
13     }
14     public String getUsername() {
15         return username;
16     }
17     public void setUsername(String username) {
18         this.username = username;
19     }
20     public String getUserpaw() {
21         return userpaw;
22     }
23     public void setUserpaw(String userpaw) {
24         this.userpaw = userpaw;
25     }
26     
27     @Override
28     public String toString() {
29         return "User [id=" + id + ", username=" + username + ", userpaw=" + userpaw + "]";
30     }
31     
32 
33 }

第六步：创建usermapper.xml：数据操作配置文件，例如select、insert等操作。将此文件与User.class放在一起。

<?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.shengmu.model.usermapper" >
    <select id="SelectUserByUsername"  parameterType="int" resultType="com.shengmu.model.User" >
        select * from userinfo where id = #{id}
    </select>
</mappe

第七步：在mybatis-cfg.xml文件中，加入usermapper.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="mybatis-mysql">
        <environment id="mybatis-mysql">
            <transactionManager type="jdbc"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver" />
                <property name="url" value="jdbc:mysql://127.0.0.1:3306/test" />
                <property name="username" value="root" />
                <property name="password" value="" />
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="com/shengmu/model/usermapper.xml" />
    </mappers>

</configuration>

其中：<mappers> <mapper resource="com/shengmu/model/usermapper.xml" /> </mappers>是usermapper.xml在mybatis-cfg.xml配置。

第八步：在com.shengmu.test中加入测试类TestSelect.class

package com.shengmu.test;

import java.io.InputStream;

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

import com.shengmu.model.User;

public class TestSelect {
    public static void main(String[] args) {
        String resource = "mybatis-cfg.xml";
        try {
            InputStream inputStream = TestSelect.class.getClassLoader().getResourceAsStream(resource);
            SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
            SqlSession session = sessionFactory.openSession();
            String statment = "com.shengmu.model.usermapper.SelectUserByUsername";
            User user = session.selectOne(statment,1);
            
            session.commit();
            System.out.println(user.getUsername());
            session.close();
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

}

最后run as --java application.

爱程序网

Tags：[db:关键字]