2019-05-20 Mybits

作者: 北街九条狗 | 来源:发表于2019-05-20 12:56 被阅读0次

2019-05-20 Mybits
Mybits
❄️恍如遇见
mybits 根据指定日期查询当天周月数据条件过滤
2019-05-21
spring中mybits
53.Maximum Subarray
骨盆旋移ASAP功能康复认证作业
sm框架，利用page，实现传参数并分页
ORM框架MyBatis与Hibernate对比

Mybits
需要在maven库中下载4个依赖

并且指定文件位置

<build>
    <resource>
        <!--指定xml文件位置，必不可少-->
        <directory>src/main/java</directory>
        <includes>
          <include>**/*.xml</include>
        </includes>
        <filtering>false</filtering>
      </resource>
</build>

    <dependencies>
        <!--数据库架包-->
        <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.39</version>
        </dependency>
        <!--打印日志架包-->
        <!-- https://mvnrepository.com/artifact/log4j/log4j -->
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.12</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/commons-logging/commons-logging -->
        <dependency>
            <groupId>commons-logging</groupId>
            <artifactId>commons-logging</artifactId>
            <version>1.2</version>
        </dependency>
        <!--mybatis架包-->
        <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.6</version>
        </dependency>
    </dependencies>

在resources中要有3个配置文件
db.properties

# 右键，属性--》utf-8
# 数据库配置文件 name = value的形式配置
jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/java2demo?useUnicode=true&characterEncoding=utf8
jdbc.user=root
jdbc.password=root

log4j.properties

# Global logging configuration
#在开发环境日志级别要设置为DEBUG、生产环境要设置为INFO或者ERROR
log4j.rootLogger=DEBUG, stdout
# 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

SqlMapConfig.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>
    <!--数据库配置文件-->
    <properties resource="db.properties"></properties>
    <!--配置别名-->
    <typeAliases>
        <!--    包的类型别名，配置完后，该包下所有类的别名都默认是自己的类名-->
        <package name="com.neuedu.pojo"/>
        <!--        自定义别名-->
        <!--        <typeAlias type="com.neuedu.pojo.Emp" alias="ABC"></typeAlias-->
    </typeAliases>
    <!--    配置环境-->
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driverClassName}"/>
                <property name="url" value="${jdbc.url}"/>
                <property name="username" value="${jdbc.user}"/>
                <property name="password" value="${jdbc.password}"/>
            </dataSource>
        </environment>
    </environments>
    <!--    mapper映射器,配置持久层，mybatis会到该包下找对应的xml文件实现映射-->
    <mappers>
        <package name="com.neuedu.mapper"/>
    </mappers>
</configuration>

查询类.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="com.neuedu.mapper.UserinfoMapper">
    <!--
        如果行参是基本数据类型 字符串
        #{任意名称 value} 相当于问号
       ￥{任意名称 value}相当于直接拼上
       parameterType 传参类型
       resultType 返回值类型
    -->
    <select id="getUserfiByid" parameterType="int" resultType="Userinfo">
        select id,name,age,birthday from Userinfo where id=#{value}
    </select>
</mapper>

test测试类

package com.neuedu.main;

import com.neuedu.mapper.UserinfoMapper;
import com.neuedu.pojo.Userinfo;
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;

public class Test {
    public static void main(String[] args) {
//        调用mapper,完成数据库操作，在控制台打印
//        1.根据id查询用户
//        1.1 构建session工厂
        InputStream inputStream=null;
        SqlSessionFactory sqlSessionFactory=null;
        SqlSession sqlSession=null;
        try {
            inputStream= Resources.getResourceAsStream("SqlMapConfig.xml");
            sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream);
//            1.2 创建sqlSession对象--代理对象
            sqlSession=sqlSessionFactory.openSession();
//            1.3 通过代理要对应的mapper对象
            UserinfoMapper userinfoMapper= sqlSession.getMapper(UserinfoMapper.class);
//            1.4 调用xml文件
            Userinfo userinfo=userinfoMapper.getUserfiByid(1);
            System.out.println(userinfo.getUid());
            System.out.println(userinfo.getName());
            System.out.println(userinfo.getAge());
            System.out.println(userinfo.getBirthday());

        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}

增删改查

test

package com.neuedu.main;

import com.neuedu.mapper.UserinfoMapper;
import com.neuedu.pojo.Userinfo;
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;
import java.util.Date;
import java.util.List;
import java.util.Map;


public class Test {
    public static void main(String[] args) {
        // 调用mapper,完成数据库操作，在控制台打印
        // 1.根据id查询某个用户
        InputStream inputStream = null;
        SqlSessionFactory sqlSessionFactory = null;
        SqlSession sqlSession = null;
        try {
            // 1.1构建session工厂 -- 工厂生成对象
            inputStream = Resources.getResourceAsStream("SqlMapConfig.xml");
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
            // 1.2创建sqlSession对象 -- 代理对象
            sqlSession = sqlSessionFactory.openSession();
            // 1.3通过代理要对应的mapper对象
            UserinfoMapper userinfoMapper = sqlSession.getMapper(UserinfoMapper.class);
            // 1.4调用方法得到返回值
//            Userinfo userinfo = userinfoMapper.getUserinfoById(2);
//            System.out.println(userinfo.getId());
//            System.out.println(userinfo.getName());
//            System.out.println(userinfo.getAge());
//            System.out.println(userinfo.getBirthday());

//            Map<String, Object> map = userinfoMapper.getUserinfoById2(1);
//            System.out.println(map);
//            for(Map.Entry<String,Object> entry : map.entrySet()){
//                System.out.println(entry.getKey()+","+entry.getValue());
//            }

//            List<Userinfo> list = userinfoMapper.getUserinfoListByName("mike");
//            for (Userinfo userinfo : list) {
////                System.out.println(userinfo.getId());
////                System.out.println(userinfo.getName());
////                System.out.println(userinfo.getAge());
////                System.out.println(userinfo.getBirthday());
////                System.out.println("===================================");
////            }

//            List<Map<String, Object>> list = userinfoMapper.getUserinfoListByName2("mike");
//            for(Map<String, Object> map : list){
//                for(Map.Entry<String, Object> entry : map.entrySet()){
//                    System.out.println(entry.getKey()+","+entry.getValue());
//                }
//                System.out.println("===================================");
//            }

//            Userinfo userinfo = new Userinfo();
//            userinfo.setAge(32);
//            userinfo.setName("mike");
//
//            Userinfo userinfo1 = userinfoMapper.getUserinfoByNameAndAge(userinfo);
//            System.out.println(userinfo1.getId()+","+userinfo1.getName());
//            System.out.println(userinfo1.getAge()+","+userinfo1.getBirthday());


            // 2.添加用户
//            Userinfo userinfo = new Userinfo();
//            userinfo.setAge(99);
//            userinfo.setName("lilei");
//            userinfo.setBirthday(new Date());
//
//            int num = userinfoMapper.insertUserinfo(userinfo);
//            System.out.println(num);
//            // 增删改需要提交
//            sqlSession.commit();

            // 3.修改用户
//            Userinfo userinfo = new Userinfo();
//            userinfo.setId(2);
//            userinfo.setName("duke");
//            userinfoMapper.updateUserinfoById(userinfo);
//            sqlSession.commit();

            // 4.根据id删除用户
//            userinfoMapper.delUserinfoById(4);
//            sqlSession.commit();

//            动态sql
            Userinfo userinfo = new Userinfo();
            userinfo.setName("dlq");
            userinfo.setId(8);
            userinfo.setAge(42);
            // {name=leo,age=12,birthday=null,id=0}
//            List<Userinfo> list = userinfoMapper.getUserinfoNoGD(userinfo);
//            for(Userinfo userinfo1 : list){
//                System.out.println(userinfo1.getId()+","+userinfo1.getName());
//                System.out.println(userinfo1.getAge()+","+userinfo1.getBirthday());
//                System.out.println("=====================================");
//            }
            userinfoMapper.updateUserinfoNoGD(userinfo);
            sqlSession.commit();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}

接口

package com.neuedu.mapper;

import com.neuedu.pojo.Userinfo;

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

public interface UserinfoMapper{

//     根据id查询某个用户
    Userinfo getUserinfoById(int id);
    Map<String,Object> getUserinfoById2(int id);
    // 根据姓名查询用户
    List<Userinfo> getUserinfoListByName(String name);
    List<Map<String,Object>> getUserinfoListByName2(String name);
    // 根据名字和年龄查询用户
    Userinfo getUserinfoByNameAndAge(Userinfo userinfo);
    // 添加用户
    int insertUserinfo(Userinfo userinfo);
    // 修改用户
    int updateUserinfoById(Userinfo userinfo);
    // 根据id删除
    int delUserinfoById(Integer id);
    // 动态SQL
    List<Userinfo> getUserinfoNoGD(Userinfo userinfo);
    // 修改
    int updateUserinfoNoGD(Userinfo userinfo);
}

实现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="com.neuedu.mapper.UserinfoMapper">
    <!--
        如果形参是基本数据类型，字符串
        #{任意名称value}
        ${任意名称value}
    -->
    <select id="getUserinfoById" parameterType="int" resultType="Userinfo">
        select id,name,age,birthday from userinfo where id = #{value}
    </select>
    <select id="getUserinfoById2" parameterType="int" resultType="map">
        select id,name,age,birthday from userinfo where id = #{value}
    </select>
    <!--
        返回值如果是List或Set
            写泛型类型
        返回值如果是Map<String,Object> List<Map<String,Object>>
            写map,Map
    -->
    <select id="getUserinfoListByName" parameterType="String" resultType="Userinfo">
        select id,name,age,birthday from userinfo where name = #{value}
    </select>
    <select id="getUserinfoListByName2" parameterType="String" resultType="map">
        select id,name,age,birthday from userinfo where name = #{value}
    </select>
    <!--
        如果形参是对象
        通过 #{属性名} 获取属性
    -->
    <select id="getUserinfoByNameAndAge" parameterType="Userinfo" resultType="Userinfo">
        select id,name,age,birthday from userinfo where name = #{name} and age = #{age}
    </select>
    <!--
        使用insert完成插入
        增删改不写返回值
    -->
    <insert id="insertUserinfo" parameterType="Userinfo">
        insert into userinfo(name,age,birthday)
        values (#{name},#{age},#{birthday})
    </insert>
    <!--
        使用update完成修改
    -->
    <update id="updateUserinfoById" parameterType="Userinfo">
        update userinfo
        set name = #{name}
        where id = #{id}
    </update>
    <!--
        使用delete完成修改
    -->
    <delete id="delUserinfoById" parameterType="Integer">
        delete from userinfo
        where id = #{value}
    </delete>
    <!--动态SQL-->
    <select id="getUserinfoNoGD" parameterType="Userinfo" resultType="Userinfo">
        select * from userinfo
        <where>
            <if test="name != null and name != ''">
                and name = #{name}
            </if>
            <if test="age != null and age != '' and age != 0">
                and age = #{age}
            </if>
        </where>
    </select>
    <update id="updateUserinfoNoGD"  parameterType="Userinfo">
        update userinfo
        <set>
           name = #{name}
           <if test="age != null and age != '' and age != 0">
                ,age = #{age}
           </if>
         </set>
        where id = #{id}
    </update>
</mapper>

数据插入时返回主键值

    <insert id="addUser" parameterType="User" >
        <!-- 返回新插入记录的主键值 -->
        <selectKey keyProperty="id" order="AFTER" resultType="int">
            select LAST_INSERT_ID()
        </selectKey>
        insert into user(username, birthday, sex, address)
        values(#{username}, #{birthday}, #{sex}, #{address})
    </insert>

2019-05-20 Mybits
Mybits需要在maven库中下载4个依赖并且指定文件位置在resources中要有3个配置文件db.pro...
Mybits
前言 MyBatis 是一款优秀的持久层框架，它支持定制化 SQL、存储过程以及高级映射。MyBatis 避免了几...
❄️恍如遇见
2019-05-20
mybits 根据指定日期查询当天周月数据条件过滤
mybits 根据指定日期查询当天周月数据条件过滤
2019-05-21
2019-05-20 2019-05-20 姓名：周国挺公司：宁波华光《六项精进》第403期 15期感谢二组...
spring中mybits
1.MyBatis入参处理  传递多个参数（ MyBatis会自动封装在Map集合中）  传递单个参数的形式...
53.Maximum Subarray
53.Maximum Subarray 2019-05-20 Given an integer array nu...
骨盆旋移ASAP功能康复认证作业
骨盆旋移2019-05-20 骨盆旋移2019-05-21
sm框架，利用page，实现传参数并分页
今日工作，用springMVC和mybits解决分页并传递其他参数问题 1.展示列表时，正常使用 rd.succe...
ORM框架MyBatis与Hibernate对比
1.开发速度对比 Hibernate的学习成本要比MyBatis高，MyBits框架相对容易上手。比较二者的开发速...