src\main\java\com\dev1\mapper\Account1Dao.java
package com.dev1.mapper;
import com.dev1.entity.Account;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;
import java.util.List;
@Repository
public class Account1Dao {
@Autowired
JdbcTemplate jdbcTemplate;//spring对jdbc封装成的模板，只需要开发者写sql
public void add(Account account){
System.out.println("--add--"+account);
jdbcTemplate.update("insert into account values(?,?,?);"
,account.getId(),account.getName(),account.getValue());
}
public void update(Account account){
System.out.println("--update--"+account);
jdbcTemplate.update("update account set name=?,value=? where id=?;",
account.getName(),account.getValue(),account.getId());
}
public void delete(String id){
System.out.println("--delete--"+id);
jdbcTemplate.update("delete from account where id = ?;",id);
}
//以上方法，参1，sql 参2，值
public Account findById(String id){
System.out.println("--findById--"+id);
//参1，sql
//参2，RowMapper 行的转换器
//参3，值
BeanPropertyRowMapper rowmapper = new BeanPropertyRowMapper(Account.class);
List<Account> list = jdbcTemplate.query("select * from account where id=?;",rowmapper,id);
return list.size() > 0 ? list.get(0): null;
}
public List<Account> findAll( ){
System.out.println("--findAll--");
BeanPropertyRowMapper rowmapper = new BeanPropertyRowMapper(Account.class);
List<Account> list = jdbcTemplate.query("select * from account ;",rowmapper);
return list;
}
}
src\test\java\com\dev1\mapper\Account1DaoTest.java
package com.dev1.mapper;
import com.dev1.entity.Account;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import static org.junit.jupiter.api.Assertions.*;
@SpringBootTest
class Account1DaoTest {
@Autowired
Account1Dao account1Dao;
@Test
void add() {
for (int i = 0; i < 10; i++) {
Account account = new Account("100"+i,"name"+i,100D);
account1Dao.add(account);
}
}
@Test
void update() {
Account account = new Account("1001","jack",10000D);
account1Dao.update(account);
}
@Test
void delete() {
account1Dao.delete("1001");
}
@Test
void findById() {
System.out.println(account1Dao.findById("1000"));
}
@Test
void findAll() {
System.out.println(account1Dao.findAll());
}
}
