Maven+MyBatis 基础程序创建<1>

1 创建maven项目


点击Finish创建完成
2 在pom.xml中导入中央仓库的包来支持MyBatis

<dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.4.5</version>
    </dependency>

    <dependency>
        <groupId>ant</groupId>
        <artifactId>ant</artifactId>
        <version>1.7.0</version>
    </dependency>


    <dependency>
        <groupId>cglib</groupId>
        <artifactId>cglib</artifactId>
        <version>3.2.5</version>
    </dependency>

    <dependency>
        <groupId>commons-logging</groupId>
        <artifactId>commons-logging</artifactId>
        <version>1.2</version>
    </dependency>

    <dependency>
        <groupId>org.javassist</groupId>
        <artifactId>javassist</artifactId>
        <version>3.22.0-GA</version>
    </dependency>


    <dependency>
        <groupId>log4j</groupId>
        <artifactId>log4j</artifactId>
        <version>1.2.17</version>
    </dependency>
    <dependency>
        <groupId>org.apache.logging.log4j</groupId>
        <artifactId>log4j-api</artifactId>
        <version>2.9.1</version>
    </dependency>
    <dependency>
        <groupId>org.apache.logging.log4j</groupId>
        <artifactId>log4j-core</artifactId>
        <version>2.9.1</version>
    </dependency>

    <dependency>
        <groupId>ognl</groupId>
        <artifactId>ognl</artifactId>
        <version>3.2.4</version>
    </dependency>

    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-api</artifactId>
        <version>1.7.25</version>
    </dependency>

    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-log4j12</artifactId>
        <version>1.7.25</version>
        <scope>test</scope>
    </dependency>

这里用的是MySql，所以还要导入MySql的包

    <dependency>
      <groupId>Mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.38</version>
    </dependency>

3 在Java Resources文件夹下的resources包中创建配置文件(.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"><!-- 注意这儿为 config.dtd -->
<configuration>  
  <environments default="development">  
    <environment id="development">  
      <transactionManager type="JDBC"/> 
        <dataSource type="POOLED">   
          <property name="driver" value="com.mysql.jdbc.Driver"/>
          <!-- mysql的驱动 --> 
          <property name="url" value="jdbc:mysql://localhost:3308/employee?useUnicode=true&amp;characterEncoding=utf-8"/> 
          <!-- 3308是端口号,employee是表名(其他不需要改动) -->
          <property name="username" value="root"/>   
          <!-- 数据库用户root -->  
          <property name="password" value="hanyao19950611"/>  
          <!-- 数据库用户的密码 -->
        </dataSource>  
    </environment> 
  </environments> 
</configuration>

4 开始对数据库进行操作
4.1 创建表的类映射(在entity包中创建User类)

package entity;

public class User {
    private int id;
    private String name;
    private int age;
    private int sex;
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public int getAge() {
        return age;
    }
    public void setAge(int age) {
        this.age = age;
    }
    public int getSex() {
        return sex;
    }
    public void setSex(int sex) {
        this.sex = sex;
    }
    public int getDid() {
        return did;
    }
    public void setDid(int did) {
        this.did = did;
    }
    private int did;
}

4.2 同样在entity包中在创建User.xml

<?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="User">
<!-- 这里的namespace可以随便定义，就是标识当前文件的存在 -->
    <insert id = "insertUser" parameterType = "entity.User">
    <!-- <insert>标签作用：插入数据；id标识当前标签；parameterType是接受参数的参数类型(User类必须写全路径名) -->
        insert into user (name,age,sex,did) values (#{name},#{age},#{sex},#{did})
        <!-- #{name}对应User类的name属性(必须一一对应不然系统不认) -->
    </insert>
    <delete id = "deleteUser" parameterType = "int">
        delete from user where id = #{id}
    </delete>
</mapper>

4.3 在Config.xml中写入以下代码

<mappers>   
    <mapper resource="entity/User.xml"/> 
    <!-- 这里的路径分隔符要用"/"，同样路径要写全 -->
  </mappers> 

5 执行
(这里创建了一个Main文件直接在main方法中操作)

package main;

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 entity.User;//这里导入我写的entity包下的User类

public class Main {

    public static void main(String[] args) {
        String path = "Config.xml";
        //这里的配置文件不需要写路径
        //(但是如果没有把配置文件放在resources包中或者在里面创建了文件夹的话，就需要写路径了)
        try {
            InputStream stream = Resources.getResourceAsStream(path);   
            SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
            SqlSessionFactory fac = builder.build(stream);
            SqlSession session = fac.openSession();
            //以上是固定格式

            User user = new User();
            user.setName("韩耀");
            user.setAge(18);
            user.setSex(0);
            user.setDid(1);
            //创建User对象

            session.insert("User.insertUser", user);
            //执行插入操作
            //参数一:namespace.insertid
            //参数二:被操作的参数
            session.delete("User.deleteUser", 13);
            session.commit();
            //提交(如果没有这句话则之前的数据库操作不会执行)
            session.close();
            //关闭session
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

}

至此就完成了简单的数据库操作啦