IT修真院·坑乎 | Java(后端),CSS(前端),JavaScript(前端),PM(产品经理),UI(交互设计),QA(测试),Android(安卓APP),iOS(苹果APP),OP(运维),Python(后端)日常在线问答学习平台

该问题已被官方收录

使用navicat将新增数据库用户之后，程序无法连接数据库

1

数据库

class="cursor-pointer"> 详细描述

class="cursor-pointer"> 错误截图

该问题已被官方收录

已经有了slf4j-api-1.6.1.jar包仍然输出时报错

0

1

log4j

class="cursor-pointer"> 详细描述

class="cursor-pointer"> 错误截图

该问题已被官方收录

如何排除第三方使用的jar包冲突？

0

1

maven

class="cursor-pointer"> 详细描述

class="cursor-pointer"> 错误截图

该问题已被官方收录

jar包不能在本地或者远程读取

1

class="cursor-pointer"> 详细描述

class="cursor-pointer"> 错误截图

该问题已被官方收录

Mybatis配置DataSource的properties外部载入失败

0

1

mybatis

class="cursor-pointer"> 详细描述

class="cursor-pointer"> 错误截图

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
            http://www.springframework.org/schema/context  http://www.springframework.org/schema/context/spring-context.xsd">

<context:component-scan base-package="finalDemo.test,finalDemo.DAO"/>

<!--    <!– 引用外部properties配置Spring自带连接 –>
   <!–引入PropertyPlaceholderConfigurer外部jdbc配置properties文件 –>
        <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="locations" value="classpath*:jdbcDataSource.properties"/>
      </bean>

<!–加载DriverManagerDataSource外部jdbc配置文件–>
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="${driverClass}"/>
        <property name="url" value="${jdbcUrl}"/>
        <property name="password" value="${password}"/>
        <property name="username" value="${user}"/>
    </bean>-->

<context:property-placeholder location="classpath:jdbc.properties" />
    
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="close">
        
        <property name = "url" value = "${Druid.url}" />
        <property name = "username" value = "${jdbc.username}" />
        <property name = "password" value = "${jdbc.password}" />
        <property name = "driverClassName" value = "${jdbc.driverClassName}" />
        <property name = "filters" value = "${jdbc.filters}" />
        
        <property name = "maxActive" value = "${jdbc.maxActive}" />
        
        <property name = "initialSize" value = "${jdbc.initialSize}" />
        
        <property name = "maxWait" value = "${jdbc.maxWait}" />
        
        <property name = "minIdle" value = "${jdbc.minIdle}" />
        
        <property name = "timeBetweenEvictionRunsMillis" value ="${jdbc.timeBetweenEvictionRunsMillis}" />
        
        <property name = "minEvictableIdleTimeMillis" value ="${jdbc.minEvictableIdleTimeMillis}" />
        
        <property name = "validationQuery" value = "${jdbc.validationQuery}" />
        
        <property name = "testWhileIdle" value = "${jdbc.testWhileIdle}" />
        
        <property name = "testOnBorrow" value = "${jdbc.testOnBorrow}" />
        
        <property name = "testOnReturn" value = "${jdbc.testOnReturn}" />
        
        <property name = "removeAbandoned" value = "${jdbc.removeAbandoned}" />
        
        <property name = "removeAbandonedTimeout" value ="${jdbc.removeAbandonedTimeout}" />
        
        <property name = "logAbandoned" value = "${jdbc.logAbandoned}" />

</bean>

<bean id="jdbcConn" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource"/>
    </bean>

该问题已被官方收录

设置外键后，联表查询失败

1

数据库

class="cursor-pointer"> 详细描述

class="cursor-pointer"> 源码

SELECT e.employee_id, e.employee_name, d.dept_name FROM EmployeeTB AS e, DeptTB AS d WHERE e.dept_id=d.dept_id;

该问题已被官方收录

MySQL 日志配置

1

class="cursor-pointer"> 详细描述

class="cursor-pointer"> 错误截图

该问题已被官方收录

Spring和Mybatis整合错误

0

1

spring mybatis

class="cursor-pointer"> 详细描述

pom：
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         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">
    <modelVersion>4.0.0</modelVersion>

<groupId>com.mybatis</groupId>
    <artifactId>MybatisInSpring</artifactId>
    <version>1.0-SNAPSHOT</version>
    <dependencies>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>1.3.0</version>
        </dependency>
        
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.1</version>
        </dependency>
        
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.39</version>
        </dependency>
        
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>4.2.0.RELEASE</version>
        </dependency>
        
        
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-beans</artifactId>
            <version>4.2.0.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>4.2.0.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
        </dependency>
    </dependencies>

</project>

applicationContext.xml:
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
      http://www.springframework.org/schema/beans/spring-beans.xsd
      http://www.springframework.org/schema/context
      http://www.springframework.org/schema/context/spring-context.xsd">

<context:property-placeholder location="classpath:db.properties"/>
    <bean id="dataSource" class="${dataSource}">
        <property name="driverClassName" value="${driver}"/>
        <property name="url" value="${url}"/>
        <property name="username" value="${username}"/>
        <property name="password" value="${password}"/>
        
    </bean>

User:
package entity;

import java.text.SimpleDateFormat;

public class User {
    private Integer id;
    private String username;
    private String number;
    private Long create_at;
    private Long update_at;

public Integer getId() {
        return id;
    }

public void setId(Integer id) {
        this.id = id;
    }

public String getUsername() {
        return username;
    }

public void setUsername(String username) {
        this.username = username;
    }

public String getNumber() {
        return number;
    }

public void setNumber(String number) {
        this.number = number;
    }

public Long getCreate_at() {
        return create_at;
    }

public void setCreate_at(Long create_at) {
        this.create_at = create_at;
    }

public Long getUpdate_at() {
        return update_at;
    }

public void setUpdate_at(Long update_at) {
        this.update_at = update_at;
    }

public String toString() {
        SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        return "学生:id=" + id + ", name=" + username + ", number="
                + number + ", create_at:" + df.format(create_at) + ", update_at:" + df.format(update_at);
    }
}

class="cursor-pointer"> 错误截图

class="cursor-pointer"> 源码

    @Test
    public void testFindUserById1() throws Exception {
        ApplicationContext applicationContext=new ClassPathXmlApplicationContext("applicationContext.xml");
        UserMapper userMapper = (UserMapper) applicationContext.getBean("userMapper");
        User user = userMapper.findUserById(1);
        System.out.println(user);
    }

该问题已被官方收录

spring整合mybatis实现CRUD出现异常。

0

1

spring

class="cursor-pointer"> 详细描述

class="cursor-pointer"> 错误截图

该问题已被官方收录

测试类无法获得键盘输入

0

1

junit

class="cursor-pointer"> 详细描述

class="cursor-pointer"> 错误截图

class="cursor-pointer"> 源码

package com.service;

import com.pojo.Student;
import org.apache.log4j.Logger;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import java.util.List;


@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = "classpath:spring-mybatis.xml")
public class IMStudentServiceTest {
    @Autowired
    IMStudentService imStudentService;

    @Autowired
    private IFStudentService ifStudentService;

    private static Logger logger=Logger.getLogger(IMStudentService.class);
    private Student student;


    @Test
    public void  test2(){
        student=ifStudentService.findStudentById(1);
        logger.info(student);
    }
    @Test
    public void findStudentById() {
        student=imStudentService.findStudentById(1);
        logger.info(student);
    }

    @Test
    public void findStudentByName() {
        student=imStudentService.findStudentByName("一");
        Reader reader=new Reader();
        logger.info(student);
    }

    @Test
    public void inputStudent() {
        student=new Student();
        student.setName("test1");
        student.setSchool("test1");
        student.setSex("1");
        student.setAge("33");
        System.out.println(student);
        imStudentService.inputStudent(student);
    }

    @Test
    public void outputStudentById() {
        imStudentService.outputStudentById(6);
    }

    @Test
    public void replayStudent() {
        student=new Student();
        student.setName("test1");
        student.setSchool("test1");
        student.setSex("1");
        student.setAge("33");
        student.setId(19);
        student.setUpdate_at(System.currentTimeMillis());
        imStudentService.replayStudent(student);

    }

    @Test
    public void findStudent() {
        List<Student> students;
        students=imStudentService.findStudent();
        logger.info(students);
    }
}