php显示修改成功后却没有在数据库,Mybatis修改数据库显示执行成功但Mysql没有变化，重开再查也没变...

本帖最后由 ing 于 2019-3-31 16:43 编辑

捕获.PNG (93.31 KB, 下载次数: 0)

2019-3-31 15:02 上传

捕获2.PNG (112.48 KB, 下载次数: 0)

2019-3-31 15:02 上传

捕获3.PNG (119.91 KB, 下载次数: 0)

2019-3-31 15:11 上传

运行测试类

[Asm] 纯文本查看 复制代码import dao.UserMapper;

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.testng.annotations.Test;

import po.User;

import java.io.IOException;

import java.io.InputStream;

public class MybatisConnect_Tes {

@Test

public void Test() {

InputStream stream = null;

try {

stream = Resources.getResourceAsStream("dao/mybatis-config.xml");

} catch (IOException e) {

e.printStackTrace();

}

SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(stream);

SqlSession session = factory.openSession();

try {

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

User user = new User();

user.setUsername("tsassat");

user.setAddress("hhgfg");

int rows = session.insert("dao.UserMapper.insert",user);

if (rows > 0)

System.out.println("成功插入了"+rows+"条数据");

else

System.out.println("插入失败");

int row2 = mapper.deleteById(3);

if (row2 > 0)

System.out.println("成功删除了"+row2+"条数据");

else

System.out.println("删除失败");

user.setId(1);

user.setAddress("Washington");

int row3 = session.update("dao.UserMapper.updateByPrimaryKeySelective",user);

if (row3 > 0)

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

else

System.out.println("修改失败");

user = mapper.findUserById(2);

System.out.println(user.toString());

} finally {

session.close();

}

}

}

mapper接口文件

[Asm] 纯文本查看 复制代码@Mapperpublic interface UserMapper {

User findUserById(@Param("id") int id);

int deleteById(@Param("id") int id);

int insert(User user);

int updateByPrimaryKeySelective(User user);

}

mapper xml文件

[Asm] 纯文本查看 复制代码<?xml version="1.0" encoding="UTF-8" ?>

id,

username,

address

INSERT INTO tb_user (

username,

address

) VALUES (

#{username},

#{address}

)

DELETE FROM tb_user WHERE id = #{id}

UPDATE tb_user SET username = #{username},address = #{address} WHERE id = #{id}

SELECT * FROM tb_user WHERE id = #{id}

mybatis-config配置文件

[Asm] 纯文本查看 复制代码<?xml version="1.0" encoding="UTF-8" ?>

/p>

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

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

log4j

[Asm] 纯文本查看 复制代码# Global logging configurationlog4j.rootLogger=ERROR, stdout

# MyBatis logging configuration...

log4j.logger=DEBUG

# Console output...

log4j.appender.stdout=org.apache.log4j.ConsoleAppender

log4j.appender.stdout.layout=org.apache.log4j.PatternLayout

log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - [\u65E5\u5FD7\u4FE1\u606F]%m%n