Mybatis環境，mybatis環境配置

Mybatis環境，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     @Override28     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.