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

该问题已被官方收录

切记不要删除mysql中的mysql.sock文件

0

1

数据库 linux命令

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

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

该问题已被官方收录

Mybatis执行删除和插入数据时报错 integer?

1

mybatis

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

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

该问题已被官方收录

构建spirng mybatis 测试时报错

0

1

junit

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

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

class="cursor-pointer"> 源码

<dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.11</version>
            <scope>test</scope>
        </dependency>

该问题已被官方收录

测试mybatis时报jdk版本不支持的错

1

mybatis

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

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

该问题已被官方收录

本地MySQL报10061错误，服务器报2002错误

0

1

数据库

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

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

该问题已被官方收录

IDEA操作数据库查找中文字段模糊查询不成功

0

1

mybatis

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

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

class="cursor-pointer"> 源码

<?xml version="1.0" encoding="utf-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<!-- 配置命名空间，namespace的名字需要对应相应的接口名-->
<mapper namespace="com.dao.StudentMapper">
    <select id="selectStudentById" parameterType="long" resultType="com.pojo.Student">
        SELECT * FROM  student where  id =#{id}
    </select>

    <select id="selectStudentByName" parameterType="String" resultType="com.pojo.Student">
        SELECT * FROM  student where  name like CONCAT('%', #{name}, '%')
    </select>

    <insert id="insertStudent" parameterType="com.pojo.Student" keyProperty="id" useGeneratedKeys="true" >
        INSERT INTO student (age,sex,school,name,create_at,update_at) values
         (#{age} ,#{sex}, #{school} , #{name},#{create_at},#{update_at})
    </insert>

    <delete id="deleteStudentById" parameterType="long">
        delete from student where id=#{id}
    </delete>

    <update id="updateStudentById" parameterType="com.pojo.Student" >
        UPDATE student set age=#{age},sex=#{sex} ,school=#{school},name=#{name} ,update_at=#{update_at} where id=#{id}
    </update>

    <select id="selectStudent" resultType="com.pojo.Student">
        select * from student
    </select>
</mapper>

该问题已被官方收录

double精度缺失

1

spring

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

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

该问题已被官方收录

为什么以前能测试成功现在不能了？

1

JDBC

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

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

import jdbctemplate.Haiqing;
import jdbctemplate.HaiqingDao;
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;

@ContextConfiguration(locations = "classpath:applicationContext.xml")
@RunWith(SpringJUnit4ClassRunner.class)
public class HaiqingDaoTest {
    @Autowired
    private HaiqingDao haiqingDao;
    @Test
    public void testAdd(){
        Haiqing haiqing=new Haiqing();
        haiqing.setId(9);
        haiqing.setName("tangqirong");
        haiqing.setAge(50);
        haiqing.setSex("men");
        int result =haiqingDao.add(haiqing);
        System.out.println(result);
    }
    @Test
    public void testUpdate(){
        Haiqing haiqing=new Haiqing();
        haiqing.setId(2);
        haiqing.setName("tangqirong");
        haiqing.setAge(51);
        haiqing.setSex("men");
        int result =haiqingDao.update(haiqing);
        System.out.println(result);
    }
    @Test
    public void testGetAll(){
        List<Haiqing> haiqings=haiqingDao.getAll();
        for(Haiqing item: haiqings){
            System.out.println(item);
        }
    }
    @Test
    public void testCount(){
        int count=haiqingDao.count();
        System.out.println(count);
    }
    @Test
    public void testDelete(){
        int id =2;
        int result=haiqingDao.delete(id);
        System.out.println(result);
    }

}

该问题已被官方收录

服务器数据库显示问题

1

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

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

该问题已被官方收录

使用mysql输入多表查询时报错

1

数据库

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

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