eclipse + maven + Mybatis 环境搭建机器

最新推荐文章于 2023-09-03 15:22:24 发布

skywalkerVVV

最新推荐文章于 2023-09-03 15:22:24 发布

阅读量1.1w

点赞数 2

分类专栏： mybatis 文章标签： eclipse mybatis maven 环境搭建

本文链接：https://blog.csdn.net/skywalkerVVV/article/details/19971929

版权

mybatis 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

开发环境:

jvm 1.7.0_17

eclipse(Juno ) + maven插件( m2e - Maven Integration for Eclipse 1.4.0.20130601-0317)

maven 3.0.4

mysql 5.0.22-win32

1，项目的目录结构

2 依赖的包(pom.xml文件)

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>MybatisLearning</groupId>
  <artifactId>MybatisLearning</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <dependencies>
   <dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.1.1</version>
  </dependency>
 
  <dependency>
   <groupId>mysql</groupId>
   <artifactId>mysql-connector-java</artifactId>
   <version>5.1.28</version>
  </dependency>
  </dependencies>
</project>

3 建立一个configuration.xml文件放在 src/main/resources目录下面

<?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>
 <typeAliases>
  <!--给实体类起一个别名 user -->
  <typeAlias type="org.junjun.mybatis.bean.User" alias="User" />
 </typeAliases>
 <!--数据源配置 使用mysql数据库 -->
 <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/mybatis" />
    <property name="username" value="root" />
    <property name="password" value="" />
   </dataSource>
  </environment>
 </environments>
 <mappers>
  <!--userMapper.xml装载进来 同等于把“dao”的实现装载进来 -->
  <mapper resource="mappers/UserMapper.xml" />
 </mappers>
</configuration>

4 新建一个pojo类 User

package org.junjun.mybatis.bean;
/**
 * 用户类
 *
 * @author db2admin
 *
 */
public class User {
 private String name;
 private Integer age;
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public Integer getAge() {
  return age;
 }
 public void setAge(Integer age) {
  this.age = age;
 }
 public User() {
 }
}

5 新建一个 UserMpapper的interface（不用实现）

package org.junjun.mybatis.dao;
import org.junjun.mybatis.bean.User;
 public interface UserMapper {
     public User findByName(String name);
     public void insertUser(User user);
 }

6新建一个UserMapping.xml 文件在 src/main/resources/mappers/目录下

<?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">
<!--这块等于dao接口的实现 namespace必须和接口的类路径一样-->
<mapper namespace="org.junjun.mybatis.dao.UserMapper">
 <!-- findByName 和  inserUser必须和接口中的方法名一样 返回一个User 就是刚才的别名 如果不弄别名要连类路径一起写-->
 <select id="findByName" parameterType="HashMap" resultType="User">
  select * from user where name=#{name}
    </select>
   
    <insert id="insertUser" parameterType="org.junjun.mybatis.bean.User">
     insert into user (name,age) value
     (
     #{name,jdbcType=VARCHAR} ,
      #{age,jdbcType=SMALLINT}
     )
    </insert>
</mapper>

7 sql.txt中的sql语句如下用来创建一个表和插入一条数据

create database mybatis

create table user
(
 name varchar(255),
 age int(11)
);
insert into user value ("andy",22)

8 在mysql中新建一个数据库 mybatis 创建表user 并插入一条数据（“andy”,22）

新建一个数据库

create database mybatis

新建一个表user

create table user

(

name varchar(255),

age int(11)

);

插入一行数据

insert into user value ("andy",22)

效果如下：(使用mysql-font)

8 写一个测试类MyBatisTest

package org.junjun.mybatis.test;
import java.io.IOException;
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 org.junjun.mybatis.bean.User;
import org.junjun.mybatis.dao.UserMapper;
/**
 * myBatis数据库测试
 *
 */
public class MyBatisTest {
 /**
  * 获得MyBatis SqlSessionFactory
  * SqlSessionFactory负责创建SqlSession，一旦创建成功，就可以用SqlSession实例来执行映射语句，commit，rollback，close等方法。
  * @return
  */
 private static SqlSessionFactory getSessionFactory() {
  SqlSessionFactory sessionFactory = null;
  String resource = "configuration.xml";
  try {
   sessionFactory = new SqlSessionFactoryBuilder().build(Resources
     .getResourceAsReader(resource));
  } catch (IOException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  return sessionFactory;
 }
 public static void main(String[] args) {
  SqlSession sqlSession = getSessionFactory().openSession();
  UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
 
  // test select
  User user = userMapper.findByName("andy");
  System.out.println(user.getName());
 
  // test insert
  User user1 = new User();
  user1.setName("xl");
  user1.setAge(22);
  userMapper.insertUser(user1);
  //it is a must or no data will be insert into server.
  sqlSession.commit();
 
 }
}