SSM整合与测试

sai_zuoJing

已于 2022-11-01 16:55:46 修改

阅读量210

点赞数 1

文章标签： mybatis java sql spring mvc

于 2022-11-01 16:34:26 首次发布

本文链接：https://blog.csdn.net/qq_45462169/article/details/127636306

版权

测试

此文章测试的项目

1.mybatis的测试

首先要有一个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;

public class UserUtil {
    private static SqlSessionFactory sqlSessionFactory;

    static {
        try {
            //获取sqlSessionFactory对象
            String resource = "mybatis-config.xml";
            InputStream inputStream = Resources.getResourceAsStream(resource);
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
    //SqlSession 完全包括了面向数据库执行SQL命令所需要的所有方法,我们就可以从中获取SqlSession的实例了
    public static SqlSession getSqlSession(){
        return sqlSessionFactory.openSession();

    }
}

有了sqlSessionFactory,在执行测试

import com.sai.dao.UserMapper;
import com.sai.pojo.User;
import com.sai.utils.UserUtil;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import java.util.List;

public class MybatisTest {
    @Test
    public void selectAllUsers(){
        SqlSession sqlSession = UserUtil.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        List<User> userList = mapper.selectAllUsers();
        for (User user : userList) {
            System.out.println(user);
        }
        sqlSession.close();
    }

    @Test
    public void selectUserByID(){
        SqlSession sqlSession = UserUtil.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        System.out.println(mapper.selectUserByID(2));
        sqlSession.close();
    }

    @Test
    public void addUser(){
        SqlSession sqlSession = UserUtil.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);

        mapper.addUser(new User(5,"王五"));

        sqlSession.commit();
        sqlSession.close();
    }

    @Test
    public void deleteUserByID(){
        SqlSession sqlSession = UserUtil.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);

        mapper.deleteUserByID(4);

        sqlSession.commit();
        sqlSession.close();
    }

    @Test
    public void updateUser(){
        SqlSession sqlSession = UserUtil.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);

        mapper.updateUser(new User(1,"佐井"));

        sqlSession.commit();
        sqlSession.close();
    }
}

在这里插入图片描述

(图是我根据自己的理解画的,肯定不对,希望有人可以发表见解!!!)

补充:resultType和parameterType的区别:
1、使用resultType：主要针对于从数据库中提取相应的数据出来;resultType是sql语句查询结果集的封装类型，也就是说把sql查询的结果封装在bean里返回回去，是存数据用的。
2、使用parameterType：主要针对于将信息存入到数据库中;paramType是从传过来的Bean中取数据放进例如insert语句的values中当实参用，是取数据用的。

2.spring的测试

将MyBatis与Spring进行整合,主要解决的问题就是将 SqlSessionFactory对象交由Spring来管理。
所以,该整合,只需要将SqlSessionFactory的对象生成器SqlSessionFactoryBean注册在Spring容器中,再将其注入给Dao的实现类即可完成整合。

//测试类
import com.sai.dao.UserMapper;
import com.sai.pojo.User;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import java.util.List;

public class SpringTest {
    @Test
    public void selectAllUsers(){
        ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
        UserMapper userMapper = context.getBean("userMapper", UserMapper.class);
        List<User> userList = userMapper.selectAllUsers();
        for (User user : userList) {
            System.out.println(user);
        }
    }

    @Test
    public void selectUserByID(){
        ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
        UserMapper userMapper = context.getBean("userMapper", UserMapper.class);
        System.out.println(userMapper.selectUserByID(1));
    }

    @Test
    public void addUser(){
        ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
        UserMapper userMapper = context.getBean("userMapper", UserMapper.class);
        userMapper.addUser(new User(5,"王五"));
    }

    @Test
    public void deleteUserByID(){
        ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
        UserMapper userMapper = (UserMapper) context.getBean("userMapper");
        userMapper.deleteUserByID(5);
    }

    @Test
    public void updateUser(){
        ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
        UserMapper userMapper = context.getBean("userMapper", UserMapper.class);
        userMapper.updateUser(new User(1,"サイ"));
    }
}

spring-dao.xml:
1.关联数据库文件
2.数据库连接池
3.配置SqlSessionFactory对象
4.配置扫描Dao接口包,动态实现Dao接口注入到spring容器中

spring-service.xml:
1.扫描service相关的bean
2.BookServiceImpl注入到IOC容器中
3.配置事务管理器

在这里插入图片描述

(图是我根据自己的理解画的,肯定不对,希望有人可以发表见解)

出现的问题:
最不理解的就是name:userMapper是UserServiceImpl;而ref:userMapper是Usermapper.

我在网上找出的回答是:
这里的name和ref虽然是同名的但是name是指UserServiceImpl类中的参数,UserServiceImpl类中有一个private UserMapper userMapper;
而ref是当前xml文件中叫做userMapper的这个bean,把它当作参数传进UserServiceImpl中.

3.springMVC测试

在这里插入图片描述

controller与service产生连接;
在index.jsp页面中使用a标签跳转到controller;
再由controller return到allUser.jsp中;

<!--    输出所有user-->
<c:forEach var="user" items="${requestScope.get('userList')}">
</c:forEach>

测试:
拿修改user举个例子
UserController
1.allUser.jsp
<a href="/user/toUpdateUser?ID=${user.getID()}">更新</a>
2.toUpdateUser
userService.selectUserByID(ID);用ID拿到user,把这个user传递到前端页面;跳入toUpdateUser页面
3.updateUser.jsp
<input type="hidden" name="ID" value="${selectUserByID.getID()}">得到ID
将修改后的Name提交到updateUser中
4.updateUser
获取修改后的user,将user return给allUser.jsp

报错:

A ResourcePool could not acquire a resource from its primary factory or source.
还有一个说电脑用户名字的问题

解决办法:
我把database.properties中的driver;url;username;password换了一个名字就好了...