mybatis mysql 删除表_Mybatis对MySQL数据库的增删改查

首先，需要注意的是 环境：先装JDK，再装maven(注意顺序)

用idea创建的maven项目结构如下(箭头顺序对应下文)：

父工程pom.xml文件用来配置依赖，如下所示

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">

4.0.0

com.Juff

Mybatis-Study

pom

1.0-SNAPSHOT

mybatis-01

mysql

mysql-connector-java

5.1.46

org.mybatis

mybatis

3.5.2

junit

junit

4.12

src/main/resources

**/*.properties

**/*.xml

true

src/main/java

**/*.properties

**/*.xml

true

子工程pom.xml的配置如下：

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">

Mybatis-Study

com.Juff

1.0-SNAPSHOT

4.0.0

mybatis-01

src/main/resources

**/*.properties

**/*.xml

true

src/main/java

**/*.properties

**/*.xml

true

接下来是mybatis-config.xml,用来配置连接数据库的相关信息

/p>

PUBLIC "-//mybatis.org//DTD Config 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-config.dtd">

value="jdbc:mysql://localhost:3306/mybatis?useSSL=false&useUnicode=true&characterEncoding=UTF-8"/>

创建pojo层

User.java

package com.Juff.pojo;

//POJO(Plain Ordinary Java Object)简单的Java对象，实际就是普通JavaBeans

//0 其中有一些属性及其getter setter方法的类,没有业务逻辑

//有一个简单的运算属性也是可以的,但不允许有业务方法，也不能携带有connection之类的方法

//POJO实质上可以理解为简单的实体类，顾名思义POJO类的作用是方便程序员使用数据库中的数据表

//可以很方便的将POJO类当做对象来进行使用，当然也是可以方便的调用其get,set方法

public class User {

private int id;

private String name;

private String pwd;

public User() {

}

public User(int id, String name, String pwd) {

this.id = id;

this.name = name;

this.pwd = pwd;

}

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 String getPwd() {

return pwd;

}

public void setPwd(String pwd) {

this.pwd = pwd;

}

@Override

public String toString() {

return "User{" +

"id=" + id +

", name='" + name + '\'' +

", pwd='" + pwd + '\'' +

'}';

}

}

创建dao层

UserMapper.java(相当于UserDao.java,名字不一样而已)

package com.Juff.dao;

import com.Juff.pojo.User;

import java.util.List;

import java.util.Map;

//DAO (DataAccessobjects 数据存取对象)是指位于业务逻辑和持久化数据之间实现对持久化数据的访问。

//通俗来讲，就是将数据库操作都封装起来.对外提供相应的接口

public interface UserMapper {

List getUserLike(String value);

//查询全部用户

List getUserList();

//根据id查询用户

User getUserById(int id);

User getUserById2(Map map);

//插入用户

int addUser(User uer);

//万能Map

int addUser2(Map map);

//修改用户

int updateUser(User uer);

//s删除用户

int deleteUser(int id);

}

UserMapper.xml(用来实现UserMapper.java的具体业务方法)

/p>

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

-- select * from mybatis.user where name like #{value} 这里需要注意，sql连注释都会运行的，注释没用！！！

select * from mybatis.user where name like "%"#{value}"%"

-- SQL语句

select * from mybatis.user

select * from mybatis.user where id=#{id};

select * from mybatis.user where id=#{helloId};

insert into mybatis.user(id ,name,pwd) values (#{id},#{name},#{pwd});

insert into mybatis.user(id,name,pwd) values (#{userId},#{userName},#{password});

update mybatis.user set name =#{name},pwd=#{pwd} where id=#{id};

delete from mybatis.user where id=#{id};

创建utils层

MybatisUtils.java

package com.Juff.utils;

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;

//sqlSessionFactory --> sqlSession

//MybatisUtils,封装SQLSession的创建和关闭

public class MybatisUtils {

private static SqlSessionFactory sqlSessionFactory;

static {

try {

//使用Mybatis第一步：获取sqlSessionFactory对象

String resource = "mybatis-config.xml";

InputStream inputStream = Resources.getResourceAsStream(resource);

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

} catch (IOException e) {

e.printStackTrace();

}

}

//既然有了 SqlSessionFactory，顾名思义，我们就可以从中获得 SqlSession 的实例了

// SqlSession 完全包含了面向数据库执行 SQL 命令所需的所有方法

public static SqlSession getSqlSession() {

return sqlSessionFactory.openSession();

}

}

最后测试

UserMapperTest.java

package com.Juff.dao;

import com.Juff.pojo.User;

import com.Juff.utils.MybatisUtils;

import org.apache.ibatis.session.SqlSession;

import org.junit.Test;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

public class UserMapperTest {

@Test

public void test() {

SqlSession sqlSession = MybatisUtils.getSqlSession();

try {

// 方式一:推荐

UserMapper userDao = sqlSession.getMapper(UserMapper.class);

List userList = userDao.getUserList();

// 方式二:以前的做法

// List userList=sqlSession.selectList("com.Juff.dao.UserDao.getUserList");

for (User user : userList) {

System.out.println(user);

}

} catch (Exception e) {

e.printStackTrace();

} finally {

sqlSession.close();

}

}

@Test

public void getUserLike() {

SqlSession sqlSession = MybatisUtils.getSqlSession();

UserMapper mapper = sqlSession.getMapper(UserMapper.class);

// List userList = mapper.getUserLike("%俊%");

List userList = mapper.getUserLike("俊");

for (User user : userList) {

System.out.println(user);

}

sqlSession.close();

}

@Test

public void getUserById() {

SqlSession sqlSession = MybatisUtils.getSqlSession();

UserMapper mapper = sqlSession.getMapper(UserMapper.class);

User user = mapper.getUserById(1);

System.out.println(user);

sqlSession.close();

}

@Test

public void getUserById2() {

SqlSession sqlSession = MybatisUtils.getSqlSession();

UserMapper mapper = sqlSession.getMapper(UserMapper.class);

Map map = new HashMap();

map.put("helloId", 1);

System.out.println(mapper.getUserById2(map));

sqlSession.close();

}

@Test

public void addUser() {

SqlSession sqlSession = MybatisUtils.getSqlSession();

UserMapper mapper = sqlSession.getMapper(UserMapper.class);

int res = mapper.addUser(new User(4, "God", "10096"));

if (res > 0) {

System.out.println("insert success!");

}

//增删改需要提交事务

sqlSession.commit();

sqlSession.close();

}

@Test

public void addUser2() {

SqlSession sqlSession = MybatisUtils.getSqlSession();

UserMapper mapper = sqlSession.getMapper(UserMapper.class);

Map map = new HashMap();

map.put("userId", 5);

map.put("userName", "Hello");

map.put("password", "2222333");

mapper.addUser2(map);

//增删改需要提交事务

sqlSession.commit();

System.out.println("insert success");

sqlSession.close();

}

@Test

public void updateUser() {

SqlSession sqlSession = MybatisUtils.getSqlSession();

UserMapper mapper = sqlSession.getMapper(UserMapper.class);

mapper.updateUser(new User(4, "God", "233233"));

//增删改需要提交事务

sqlSession.commit();

sqlSession.close();

}

@Test

public void deleteUser() {

SqlSession sqlSession = MybatisUtils.getSqlSession();

UserMapper mapper = sqlSession.getMapper(UserMapper.class);

mapper.deleteUser(4);

//增删改需要提交事务

sqlSession.commit();

sqlSession.close();

}

}

以上5大步即可完成一个Mybatis的增删改查，如若需要视频，这便是——>：入口(亲测有效)