使用IDEA、Mybatis配置的sql数据库的增删改查以及登录（再次优化后）

最新推荐文章于 2023-06-19 23:41:59 发布

原创最新推荐文章于 2023-06-19 23:41:59 发布 · 376 阅读

0 ·

CC 4.0 BY-SA版权

数据库同时被 3 个专栏收录

40 篇文章

订阅专栏

IDEA

39 篇文章

订阅专栏

Mybatis

17 篇文章

订阅专栏

本文详细介绍了一个基于MyBatis框架的实战项目，包括pom.xml配置、MyBatis.xml配置、log4j.properties日志配置、db.properties数据库配置、App.java主类、MybatisUtil.java工具类、IUserService.java接口、UserServiceImpl.java实现类、UserMapper.xml映射文件、UserMapper.java接口和User.java实体类。项目涵盖了MyBatis的基本使用，如CRUD操作、参数传递、结果映射等。

pom.xml：

<?xml version="1.0" encoding="UTF-8"?>

<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>text</groupId>
  <artifactId>Mybatis</artifactId>
  <version>1.0.0</version>
  <packaging>jar</packaging>

  <dependencies>
    <!--mybatis依赖-->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.4.6</version>
    </dependency>

    <!--链接mysql的驱动-->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.38</version>
    </dependency>

    <!--junit单元测试-->
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.12</version>
    </dependency>

    <!--lombok-->
    <dependency>
      <groupId>org.projectlombok</groupId>
      <artifactId>lombok</artifactId>
      <version>1.16.20</version>
      <scope>provided</scope>
    </dependency>

    <!--log4j日志-->
    <dependency>
      <groupId>log4j</groupId>
      <artifactId>log4j</artifactId>
      <version>1.2.17</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>

  </dependencies>

  <build>
    <!--加载资源文件-->
    <plugins>
      <plugin>
        <groupId>org.apache.maven.plugins</groupId>
        <artifactId>maven-resources-plugin</artifactId>
        <version>2.6</version>
      </plugin>
    </plugins>
    <resources>
      <resource>
        <directory>src/main/resources/</directory>
        <includes>
          <include>**/*.properties</include>
          <include>**/*.xml</include>
        </includes>
      </resource>
      <resource>
        <directory>src/main/java/</directory>
        <includes>
          <include>**/*.properties</include>
          <include>**/*.xml</include>
        </includes>
      </resource>
    </resources>

  </build>

</project>

Mybatis.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>
    <!--属性配置
        resource：从classes文件夹开始寻找文件
    -->
    <properties resource="db.properties"/>
    <!--配置别名-->
    <typeAliases>
        <!--配置单个对象的别名-->
        <!--<typeAlias type="text.Mybatis.bean.User" alias="User"/>-->
        <!--
            配置包，整个包下面的类都会被注册别名
            默认情况下，别名为简单类名，且大小写不敏感
        -->
        <package name="text.Mybatis.bean"/>
    </typeAliases>
    <!--配置环境
        defauilt：mybatis启动时使用的哪个环境
    -->
    <environments default="development">
        <environment id="development">
            <!--事务管理器
                使用mysql的事务管理器来管理事务
            -->
            <transactionManager type="JDBC"/>
            <!--数据源-->
            <dataSource type="POOLED">
                <property name="driver" value="${driver}"/>
                <property name="url" value="${url}"/>
                <property name="username" value="${username}"/>
                <property name="password" value="${password}"/>
            </dataSource>
        </environment>
    </environments>
    <!--关联映射文件-->
    <mappers>
        <!--resource从classes文件夹中寻找文件-->
        <mapper resource="text/Mybatis/mapper/UserMapper.xml"></mapper>
    </mappers>
</configuration>

log4j.properties：

# Global logging configuration
log4j.rootLogger=ERROR, stdout
# MyBatis logging configuration...
log4j.logger.org.mybatis.example.BlogMapper=TRACE
# Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

db.properties：

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/mybatis
username=root
password=123

App.java：

import text.Mybatis.Service.IUserService;
import text.Mybatis.Service.impl.UserServiceImpl;
import text.Mybatis.bean.User;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Test;
import org.apache.ibatis.io.Resources;

import java.io.IOException;
import java.io.InputStream;
import java.math.BigDecimal;
import java.util.Date;
import java.util.List;

/**
 * Created by Administrator on 2019/8/28.
 */

public class App {
    @Test
    public void testSqlSessionFactory() throws Exception {

        //获取SQLSessionFactory对象
        String resource="Mybatis.xml";
        InputStream in = Resources.getResourceAsStream(resource);

        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(in);
        SqlSession session = sqlSessionFactory.openSession();

        System.out.println(sqlSessionFactory);

    }

    @Test
    public void testSave() throws Exception {
        IUserService service=new UserServiceImpl();
        User user=new User(null,"tom111",30,new Date(),new BigDecimal("1000.00"));
        service.save(user);

    }

    @Test
    public void testUpdate() throws Exception {
        IUserService service=new UserServiceImpl();
        User user=new User(2,"tom111",39,new Date(),new BigDecimal("9000.00"));
        service.update(user);

    }
    @Test
    public void testDelete() throws Exception {
        IUserService service=new UserServiceImpl();
        service.delete(2);


    }

    @Test
    public void testGet() throws Exception {
        IUserService service=new UserServiceImpl();
        User user = service.get(3);
        System.out.println(user);

    }


    @Test
    public void testList() throws Exception {
        IUserService service=new UserServiceImpl();
        List<User> list = service.list();
        System.out.println(list);

    }

    @Test
    public void testLogin() throws Exception {
        IUserService service=new UserServiceImpl();
        User user = service.login("jack", 20);
        System.out.println(user);

    }

    @Test
    public void testLogin2() throws Exception {
        IUserService service=new UserServiceImpl();
        User user = service.login2("jack", 20);
        System.out.println(user);

    }
}

MybatisUtil.java：

package text.util;

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 java.io.IOException;
import java.io.InputStream;

/**
 * Created by Administrator on 2019/8/28.
 */
public class MybatisUtil {
    public static SqlSessionFactory factory=null;
    static {
        String resource="Mybatis.xml";
        InputStream in = null;
        try {
            in = Resources.getResourceAsStream(resource);
        } catch (IOException e) {
            e.printStackTrace();
        }

        factory = new SqlSessionFactoryBuilder().build(in);
    }

    public static SqlSession getsession (){

        return factory.openSession();
    }


}

IUserService.java（接口）：

package text.Mybatis.Service;

import text.Mybatis.bean.User;

import java.util.List;

/**
 * Created by Administrator on 2019/8/29.
 */
public interface IUserService {
    void save(User user);

    void delete(Integer id);

    void update(User user);

    User get(Integer id);

    List<User> list();

    User login(String username,Integer age);

    User login2(String username,Integer age);
}

UserServiceImpl.java：

package text.Mybatis.Service.impl;

import text.Mybatis.Service.IUserService;
import text.Mybatis.bean.User;
import text.Mybatis.mapper.UserMapper;
import text.Mybatis.util.MybatisUtil;
import org.apache.ibatis.session.SqlSession;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * Created by Administrator on 2019/8/29.
 */
public class UserServiceImpl implements IUserService{
    public void save(User user) {
        SqlSession session = MybatisUtil.getsession();
//        获取Mapper接口的代理对象
        UserMapper userMapper = session.getMapper(UserMapper.class);
//        执行保存操作
        userMapper.save(user);
        session.commit();
        session.close();
    }

    public void delete(Integer id) {
        SqlSession session = MybatisUtil.getsession();
        UserMapper userMapper = session.getMapper(UserMapper.class);
        userMapper.delete(id);
        session.commit();
        session.close();

    }

    public void update(User user) {
        SqlSession session = MybatisUtil.getsession();
        UserMapper userMapper = session.getMapper(UserMapper.class);
        userMapper.update(user);
        session.commit();
        session.close();

    }

    public User get(Integer id) {
        SqlSession session = MybatisUtil.getsession();
        UserMapper userMapper = session.getMapper(UserMapper.class);
        User user = userMapper.get(id);
        session.commit();
        session.close();
        return user;
    }

    public List<User> list() {
        SqlSession session = MybatisUtil.getsession();
        UserMapper userMapper = session.getMapper(UserMapper.class);
        List<User> list = userMapper.list();
        session.commit();
        session.close();
        return list;
    }
//  登录
    public User login(String username, Integer age) {
        SqlSession session = MybatisUtil.getsession();
        UserMapper userMapper = session.getMapper(UserMapper.class);
        User user=userMapper.selectUsernameAndAge(username,age);

        session.commit();
        session.close();
        return user;
    }
//  登录2
    public User login2(String username, Integer age) {
        SqlSession session = MybatisUtil.getsession();
        UserMapper userMapper = session.getMapper(UserMapper.class);
        Map map=new HashMap();
        map.put("name",username);
        map.put("age",age);

        User user=userMapper.selectUsernameAndAge2(map);

        session.commit();
        session.close();
        return user;
    }
}

UserMapper.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">
<!--
    映射文件通常和dao接口放在同一个包中
-->
<!--
    namespace的值通常为dao接口的全限定名
-->
<mapper namespace="text.Mybatis.mapper.UserMapper">
<!--
    定义一个结果映射
    id：结果映射的唯一标识
    type：封装成哪个类的对象
-->
    <resultMap id="userResultMap" type="text.Mybatis.bean.User">
        <!--<result column=”数据库中的列名” property=”想要展示的属性名”/>（可以一样）（主键可以改,以id为例）-->
        <id column="id" property="id"/>
        <result column="name" property="name"/>
        <result column="age" property="age"/>
        <result column="birthday" property="birthday"/>
        <result column="salary" property="salalry"/>
    </resultMap>
<!--
    useGeneratedKeys：要获取mysql数据库自动生成的主键，默认值为false，当赋值为true时，则代表开始获取
    keyProperty：把获取到的主键，设置给对象的哪个属性
    keyColumn：从哪个列获取到的自动生成的主键的值（可以省略）
-->

    <insert id="save" useGeneratedKeys="true" keyProperty="id" keyColumn="id">
        insert into user(name,age,birthday,salary)
        VALUES (#{name},#{age},#{birthday},#{salary})
    </insert>

    <update id="update">
        update user set
        name=#{name},
        age=#{age},
        birthday=#{birthday},
        salary=#{salary}
        WHERE
        id=#{id}
    </update>

    <delete id="delete">
        delete from user where id=#{id}
    </delete>

    <!--<select id="get" resultType="User">-->
    <!--使用结果映射，就不用resultType，而用resultMap-->
    <select id="get" parameterType="Integer" resultType="myUser">
        select * from user where id=#{id}
    </select>
    
    <select id="list" resultType="text.Mybatis.bean.User">
        select * from user
    </select>

    <select id="selectUsernameAndAge" resultType="text.Mybatis.bean.User">
        select * from user where name=#{username} and age=#{age}
    </select>

    <select id="selectUsernameAndAge2" resultType="text.Mybatis.bean.User">
        select * from user where name=#{name} and age=#{age}
    </select>

</mapper>

UserMapper.java：

package text.Mybatis.mapper;

import text.Mybatis.bean.User;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * Created by Administrator on 2019/8/29.
 */
public interface UserMapper {
    void save(User user);

    void delete(Integer id);

    void update(User user);

    User get(Integer id);

    List<User> list();
    /*
    * @Param注解的作用：
    * 把执行方法时候传递的参数，自动的封装到map中，
    * map的key为@Param注解中value的值，@Param注解括号中的值，
    * map的value为执行方法时传递的参数
    * */
    User selectUsernameAndAge(@Param("username") String username,@Param("age") Integer age);

    User selectUsernameAndAge2(Map map);
}

User.java：

package com.ujiuye.Mybatis.bean;

        import lombok.*;
        import org.apache.ibatis.type.Alias;

        import java.math.BigDecimal;
        import java.util.Date;

/**
 * Created by Administrator on 2019/8/28.
 */
@Setter@Getter@ToString
@AllArgsConstructor
@NoArgsConstructor
//可以使用注解显示的配置某个类的别名
@Alias("myUser")
public class User {
    private Integer id;
    private String name;
    private Integer age;
    private Date birthday;
    private BigDecimal salary;
}