環境：

• Java 版本：OpenJDK 11
• 資料庫：MySQL 8.0.23
• 構建工具：Maven 3.6.3
• 需求：開發 Web API

**Dependenies:

• devtools 2.6.3
• lombok 1.18.22
• mysql-connector-java 8.0.28
• spring-boot-starter-web 2.6.3
• spring-boot-starter-jdbc 2.6.3

實體類別

@Getter
@Setter
@ToString
public class AuthorityEntity extends Base{
	
	private int id;
	private String name;
}

繼承類別

@Getter
@Setter
public class Base {
	
	private String crUser;
	private LocalDateTime crDateTime;
    private String upUser;
    private LocalDateTime upDateTime;
    
}

持久層

public interface AuthorityDao {
    public int updateAuthority(AuthorityEntity authority);
}

實作代碼

@Repository
public class AuthorityImp implements AuthorityDao {
    
    @Autowired
	private JdbcTemplate jdbcTemplate;

	@Autowired
	private JdbcTemplate jdbcNameTemplate;

    public int updateAuthority(AuthorityEntity authority) {
		String sql = " UPDATE deploy_authority "
					+ " SET NAME = :name, UPDATE_TIME = :upDateTime ,UPDATE_USER = :upUser"
					+ " WHERE ID = :id ";

		SqlParameterSource paramSource = new BeanPropertySqlParameterSource(authority);
		
		return jdbcNameTemplate.update(sql, paramSource);
	}

測試代碼

@SpringBootTest
class AuthorityDaoTest {

	@Autowired
	AuthorityDao authorityDao;
    
    @Test
	public void updateAuthority() {
		try {

			AuthorityEntity authority = new AuthorityEntity();
			authority.setId(1);
			authority.setName("newname");
			authority.setUpDateTime(LocalDateTime.now());
			authority.setUpUser("upuser");
			Integer result = authorityDao.updateAuthority(authority);
			System.out.println("更新成功:id為" + result);
		} catch (Exception e) {
			System.out.println("更新失敗");
			System.out.println(e);
		}
	}

}

代碼有些雜，首次po這類問題，有需要改進地方請見諒。

在做Junit5測試時，會通過CRUD測試，但Insert,Update資料時卻會報錯
org.springframework.dao.TransientDataAccessResourceException:PreparedStatementCallback;

導致資料庫實際不會有Insert,Update的資料，檢查其他類別也是同樣結構卻不報錯。

找了一段時間實在沒辦法，來版上求助各位大神....ORZ