向数据库添加数据时空指针异常的解决办法

最新推荐文章于 2024-01-10 17:52:05 发布

yjlchn

最新推荐文章于 2024-01-10 17:52:05 发布

阅读量2.4k

点赞数 2

分类专栏： Java笔记文章标签： java

本文链接：https://blog.csdn.net/YezhanCHN/article/details/118305138

版权

Java笔记专栏收录该内容

27 篇文章 2 订阅

订阅专栏

package com.msb.dao.impl;

import com.msb.dao.DeptDao;
import com.msb.pojo.Dept;
import com.msb.pojo.Emp;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;

import java.util.LinkedList;
import java.util.List;

/**
 * @Auther: YeZhanCHN
 * @Date: 2021/6/28 - 06 - 28 - 14:24}
 * @Description:
 * @version:1.0
 */
@Repository
public class DeptDaoImpl implements DeptDao {

    private JdbcTemplate jdbcTemplate;


    @Override
    public int[] BatchAddDept(List<Dept> deptList) {
        String sql = "insert into dept values(null,?,?)";
        List<Object[]> args = new LinkedList<>();
        for (Dept dept : deptList) {
            Object[] arg={dept.getDname(),dept.getLoc()};
            args.add(arg);
        }
        int[] ints = jdbcTemplate.batchUpdate(sql,args);
        return ints;
    }
}

java.lang.NullPointerException
	at com.msb.dao.impl.DeptDaoImpl.BatchAddDept(DeptDaoImpl.java:33)
	at com.msb.service.impl.DeptServiceImpl.batchAddDept(DeptServiceImpl.java:24)
	at com.msb.test.TestBatchAddDept.TestbatchAddDept(TestBatchAddDept.java:28)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56)
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
	at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
	at org.junit.runners.BlockJUnit4ClassRunner$1.evaluate(BlockJUnit4ClassRunner.java:100)
	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:366)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:103)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:63)
	at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329)
	at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293)
	at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:413)
	at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
	at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
	at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
	at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
	at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)




Process finished with exit code -1