spring boot mybatis如何捕获连接数据库失败的异常?

 

问题描述:

使用mybatis查询数据时,想捕获数据库连接失败的异常。

以下是想通过NetException来捕获数据库连接失败的异常,但是报错。

图片描述

请问该怎么处理,才能准确的捕获到连接失败的异常?

        try {
            int userId = 1;
            User user = userMapper.findById(userId);
        } catch (NetException e) {
            // TODO: handle exception
            logger.info("xxxxxxxxxxxxxxxxxxxxxxx");
            System.out.println(e.getStackTrace());
            logger.info("xxxxxxxxxxxxxxxxxxxxxxx");
        }
public interface UserMapper {
    @Select("SELECT * FROM SYSTEM_USER WHERE id=#{id}")
    @Results({ @Result(property = "credentialsSalt", column = "credentials_salt"),
            @Result(property = "createTime", column = "create_time") })
    User findById(int id);

    @Select("SELECT * FROM user WHERE username=#{username}")
    @Results({ @Result(property = "credentialsSalt", column = "credentials_salt"),
            @Result(property = "createTime", column = "create_time") })
    User queryByUsername(String username);
}

 

第 1 个答案:

        try {
            int userId = 1;
            User user = userMapper.findById(userId);
        } catch (Exception e) {
            if (e instanceof NetException) {
                // TODO: handle exception
                logger.info("xxxxxxxxxxxxxxxxxxxxxxx");
                System.out.println(e.getStackTrace());
                logger.info("xxxxxxxxxxxxxxxxxxxxxxx");
            } else {
                // TODO: handle exception
                logger.info("xxxxxxxxxxxxxxxxxxxxxxx");
                System.out.println(e.getStackTrace());
                logger.info("xxxxxxxxxxxxxxxxxxxxxxx");
            }
        }

仅供参考。


一个网上听课系统,每隔一段时间需要答题,然后才能继续听(如图)。想问如何实现自动点击这个“提交”按钮?JS可以实现吗?还是只能模拟点击?