在执行插入操作时，数据库中的location_id一直是0，运行程序也没报错
代码如下
持久层接口：
package com.bjsxt.dao;
import java.util.List;
import com.bjsxt.pojo.Departments;
public interface DepartmentsDao {
public List<Departments> selectDeptByname(String deptName);
public void insertDept(Departments dept);
}接口实现类：
package com.bjsxt.dao.impl;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import com.bjsxt.commons.JdbcUtil;
import com.bjsxt.dao.DepartmentsDao;
import com.bjsxt.pojo.Departments;
public class DepartmentsDaoImpl implements DepartmentsDao {
@Override
public void insertDept(Departments dept) {
Connection conn=null;
PreparedStatement ps = null;
try {
conn = JdbcUtil.getConnection();
conn.setAutoCommit(false);
ps = conn.prepareStatement("insert into departments values(default,?,?)");
ps.setString(1, dept.getDepartmentName());
ps.setInt(2, dept.getDepartmentId());
ps.execute();
conn.commit();
}catch(Exception e) {
e.printStackTrace();
JdbcUtil.rollback(conn);
}finally {
JdbcUtil.closeResource(ps, conn, null);
}
}
}业务层接口：
package com.bjsxt.service;
import com.bjsxt.pojo.Departments;
public interface DepartmentsService {
public void addDepartments(Departments dept);
}接口实现类
package com.bjsxt.service.impl;
import com.bjsxt.dao.DepartmentsDao;
import com.bjsxt.dao.impl.DepartmentsDaoImpl;
import com.bjsxt.pojo.Departments;
import com.bjsxt.service.DepartmentsService;
public class DepartmentsServiceImpl implements DepartmentsService {
@Override
public void addDepartments(Departments dept) {
DepartmentsDao deptDao = new DepartmentsDaoImpl();
deptDao.insertDept(dept);
}
}测试类：
package com.bjsxt.test;
import com.bjsxt.pojo.Departments;
import com.bjsxt.service.DepartmentsService;
import com.bjsxt.service.impl.DepartmentsServiceImpl;
public class Test {
public static void main(String[] args) {
Departments dept = new Departments();
dept.setDepartmentName("后勤部11");
dept.setLocationId(5);
DepartmentsService ds = new DepartmentsServiceImpl();
ds.addDepartments(dept);
}
}源码：
jdbcDemo2.zip
这段代码应该有大问题吧，代码表达的意思好像是当前链表为空的时候在空的root节点的的下一节点添加数据，此时做的不应该是将新数据添加进root节点当作链表的第一个节点吗？
我现在弄得是第二个盒子，我现在只想要绿色新品的哪，但是我弄不出来那样的效果，老师帮我看看吧
（根据我自己的学习经验。。。ego那个项目我完整写了两遍我感觉才对整个项目有了比较深的理解，springcloud我只看了的技术讲解部分，和写了一部分百战商城项目的后台代码我感觉对springcloud写的项目理解没那么深），但要是百战商城全写完像我之前写ego那样，估计至少要到12月10号甚至更久。（所以我有点纠结。。。）老师您觉得我是全写完springcloud百战商城这个项目去面试好，还是现在就去面试？
京公网安备 11011402011233号