02——mybatis简单使用

MyBatis的简单使用

Sql

/*

Navicat MySQL Data Transfer


Source Server        : Linux_mysql

Source Server Version : 50622

Source Host          : 192.168.188.130:3306

Source Database      : db_mybatis

Target Server Type    : MYSQL

Target Server Version : 50622

File Encoding        : 65001

Date: 2019-01-06 18:21:07

*/

SET FOREIGN_KEY_CHECKS=0;


-- ----------------------------

-- Table structure for t_student

-- ----------------------------

DROP TABLE IF EXISTS `t_student`;

CREATE TABLE `t_student` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `name` varchar(20) DEFAULT NULL,

  `age` int(11) DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

项目结构



mybatis-config.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="jdbc.properties"/><!-- 属性文件引入 -->

<typeAliases><!-- 实体类关联别名 -->

<typeAlias alias="Student" type="model.Student"/><!-- 设置别名 -->

</typeAliases>

<environments default="development"> <!-- 环境集(默认: 开发者模式) -->

<environment id="development"><!-- 环境(编号: 随便取) -->

<transactionManager type="JDBC" /><!-- 事务管理器 -->

<dataSource type="POOLED"><!-- 数据源(如何连接数据库) -->

<property name="driver" value="${jdbc.driverClassName}" />

<property name="url" value="${jdbc.url}" />

<property name="username" value="${jdbc.username}" />

<property name="password" value="${jdbc.password}" />

</dataSource>

</environment>

</environments>

<mappers><!-- 映射配置 -->

<mapper resource="mappers/StudentMapper.xml" />

</mappers>

</configuration>






jdbc.properties

jdbc.driverClassName=com.mysql.jdbc.Driver

jdbc.url=jdbc:mysql://192.168.188.130:3306/db_mybatis?characterEncoding=UTF-8

jdbc.username=root

jdbc.password=root




StudentMapper.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="mappers.StudentMapper">

<!--

#{}: 防注入  ${}：直接拼接，没有双引号

parameterType ：参数类型

useGeneratedKeys ：是否自动生成主键 keyProperty ：主键是哪个属性

-->


<!-- insert -->

<insert id="add" parameterType="Student" useGeneratedKeys="true" keyProperty="id" >

insert into t_student values(null,#{name},#{age})

</insert>

<!-- update -->

<update id="update" parameterType="Student">

update t_student set name = #{name},age = #{age} where id = #{id} and name != #{name}

</update>


<!-- delete -->

<delete id="delete" parameterType = "Integer">

delete from t_student where id = #{id}

</delete>

<delete id="deletes" parameterType = "list">

delete from t_student where id in

<foreach collection="list" item="id" index="index"

open="(" separator="," close=")" >

#{id}

</foreach>

</delete>

<!-- selectAll -->

<select id="selectAll" resultType="model.Student">

select * from t_student

</select>

<!-- selectById -->

<select id="selectById" parameterType="Integer" resultType="model.Student">

select * from t_student where id=#{id}

</select>

<!-- selectWeNa -->

<select id="selectWeNa" parameterType="Student" resultType="model.Student">

select * from t_student where name like #{name} and age=#{age}

</select>

<!-- selectFy -->

<select id="selectFy" parameterType="map" resultType="model.Student">

select * from t_student order by id desc limit #{first},#{end}

</select>

</mapper>




SqlSessionFactoryUtil.java

package util;


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;


public class SqlSessionFactoryUtil {


private static SqlSessionFactory sqlSessionFactory;

public static SqlSessionFactory getSqlSessionFactory(){

if(sqlSessionFactory==null){

    InputStream inputStream=null;

try{

    inputStream=Resources.getResourceAsStream("mybatis-config.xml");

    sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream);

}catch(Exception e){

    e.printStackTrace();

}

}

return sqlSessionFactory;

}

public static SqlSession openSession(){

        return getSqlSessionFactory().openSession();

}

}



StudentMapper.java

package mappers;


import java.util.ArrayList;

import java.util.HashMap;

import java.util.List;


import model.Student;


public interface StudentMapper {


public int add(Student student);

public int update(Student student);

public int delete(Integer id);

public int deletes(ArrayList<Integer> ids);

public List<Student> selectAll();

public List<Student> selectById(Integer id);

public List<Student> selectWeNa(Student student);

public List<Student> selectFy(HashMap<String, Integer> map);

}



Student.java

package model;


public class Student {


private Integer id;

private String name;

private Integer age;

public Student() {

super();

}

public Student(Integer id) {

super();

this.id = id;

}

public Student(String name, Integer age) {

super();

this.name = name;

this.age = age;

}



public Integer getId() {

return id;

}

public void setId(Integer id) {

this.id = id;

}

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;

}


@Override

public String toString() {

return "Student [id=" + id + ", name=" + name + ", age=" + age + "]";

}

}




StudentTest.java

package service;


import java.util.ArrayList;

//底层的

import java.util.HashMap;

//外部的

import org.apache.ibatis.session.SqlSession;


import mappers.StudentMapper;

import model.Student;

import util.SqlSessionFactoryUtil;


public class StudentTest {


public static void main(String[] args) {

SqlSession sqlSession = SqlSessionFactoryUtil.openSession();

StudentMapper studentMapper = sqlSession.getMapper(StudentMapper.class);


// 查询所有

// for (Student s : studentMapper.selectAll()) {

// System.out.println(s);

// }


// ID查询

// for (Student s : studentMapper.selectById(1)) {

// System.out.println(s);

// }


// 条件查询

// for (Student s : studentMapper.selectWeNa(new Student("张%", 10))) {

// System.out.println(s);

// }

// 分页查询

// HashMap<String, Integer> map = new HashMap<String, Integer>();

// map.put("first", 0);

// map.put("end", 3);

// for (Student s : studentMapper.selectFy(map)) {

// System.out.println(s);

// }


// 添加

// Student student = new Student("李六", 11);

// int result = studentMapper.add(student);

// System.out.println("相应行数："+result);

// System.out.println("id："+student.getId());

// 修改

// Student student = new Student("admin",16);

// student.setId(1);

// int i = studentMapper.update(student);

// System.out.println("成功修改 "+i+" 条数据");

// 删除

// int i = studentMapper.delete(13);

// System.out.println(i==0?"删除失败":"删除成功");

// 批量删除（in）

// ArrayList<Integer> ids = new ArrayList<Integer>();

// ids.add(9);

// ids.add(10);

// ids.add(11);

// int i = studentMapper.deletes(ids);

// System.out.println("删除了 "+i+" 条数据");


sqlSession.commit();

}


}


最后编辑于 ：
©著作权归作者所有,转载或内容合作请联系作者
【社区内容提示】社区部分内容疑似由AI辅助生成，浏览时请结合常识与多方信息审慎甄别。
平台声明：文章内容（如有图片或视频亦包括在内）由作者上传并发布，文章内容仅代表作者本人观点，简书系信息发布平台，仅提供信息存储服务。

相关阅读更多精彩内容

  • （05）Mybatis入门及实践
    1 Mybatis入门 1.1 单独使用jdbc编程问题总结 1.1.1 jdbc程序 上边使...
    哇哈哈E阅读 8,614评论 0赞 38
  • Mybatis
    1、Mybatis支持普通SQL查询、存储一级高级映射的优秀持久层框架 2、Mybatis可以使用简单的XML或注...
    JHMichael阅读 2,795评论 0赞 1
  • 从现在开始，到哪里结束？
    狮子想找一个动物接替他做“万兽之王”。于是，他宣布：“从现在开始，你们轮流当‘万兽之王’，每个动物当一个星期。谁做...
    伴农微言阅读 3,541评论 0赞 0
  • 我，还欠你一声晚安
    墨色的夜空，星星点点，走在下班的路上，突然想起了远方的你，早已忘记浑身的疲惫。突然想去江滩走走，心之所...
    卿颐阅读 2,939评论 1赞 6
  • 2018.12.19
    现在终于明白为什么这么多年没啥成长，原因就是自己没有恒心和耐心
    草帽小子呀阅读 1,342评论 0赞 0

友情链接更多精彩内容