1.批量 *** 作: *** 作表里面多条记录
2.JdbcTemplate实现批量添加 *** 作
batchUpdate(String sql, List
有两个参数:
第一个参数:sql语句
第二个参数:List集合,添加多条记录数据
3.JdbcTemplate实现批量修改 *** 作
4.JdbcTemplate实现批量删除 *** 作
1.对应数据库创建实体类
package com.atguigu.spring5.entity;
public class Book {
private String userid;
private String username;
private String ustatus;
public String getUserid() {
return userid;
}
public void setUserid(String userid) {
this.userid = userid;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getUstatus() {
return ustatus;
}
public void setUstatus(String ustatus) {
this.ustatus = ustatus;
}
@Override
public String toString() {
return "Book{" +
"userid='" + userid + '\'' +
", username='" + username + '\'' +
", ustatus='" + ustatus + '\'' +
'}';
}
}
2.xml配置文件
3.编写service和dao
(1)在service,dao进行数据库各种 *** 作
package com.atguigu.spring5.service;
import com.atguigu.spring5.dao.BookDao;
import com.atguigu.spring5.entity.Book;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
@Service
public class BookService {
//注入dao
@Autowired
private BookDao bookDao;
//添加的方法
public void addBook(Book book){
bookDao.add(book);
}
//修改的方法
public void updateBook(Book book){
bookDao.updateBook(book);
}
//删除的方法
public void deleteBook(String id){
bookDao.deleteBook(id);
}
//查询表中的记录数
public int findCount() {
return bookDao.selectConent();
}
//查询返回对象
public Book findOne(String id) {
return bookDao.findBookInfo(id);
}
//查询返回集合
public List findAll(){
return bookDao.findAllBook();
}
//批量添加
public void batchAdd(List
package com.atguigu.spring5.dao;
import com.atguigu.spring5.entity.Book;
import org.springframework.stereotype.Repository;
import java.util.List;
public interface BookDao {
//添加的方法
void add(Book book);
//修改的方法
void updateBook(Book book);
//删除的方法
void deleteBook(String id);
//查询表中的记录数
int selectConent();
//查询返回对象
Book findBookInfo(String id);
List findAllBook();
//批量添加
void batchAddBook(List batchArgs);
//批量修改
void batchUpdate(List batchArgs);
//批量删除
void batchDelete(List batchArgs);
}
(2)调用JdbcTemplate对象里面的方法实现相应 *** 作
package com.atguigu.spring5.dao;
import com.atguigu.spring5.entity.Book;
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.Arrays;
import java.util.List;
@Repository
public class BookDaoImpl implements BookDao {
//注入JdbcTemplate
@Autowired
private JdbcTemplate jdbcTemplate;
//添加的方法
@Override
public void add(Book book) {
//1.创建sql语句
String sql = "insert into t_book values(?,?,?)";
//2.调用方法实现
Object[] args ={book.getUserid(), book.getUsername(), book.getUstatus()};
//实现数据库的增加
int update = jdbcTemplate.update(sql,args);
System.out.println(update);
}
//修改
@Override
public void updateBook(Book book) {
String sql = "update t_book set username=?,ustatus=? where user_id=?";
Object[] args ={ book.getUsername(), book.getUstatus(),book.getUserid()};
int update = jdbcTemplate.update(sql,args);
System.out.println(update);
}
//删除
@Override
public void deleteBook(String id) {
String sql = "delete from t_book where userid=?";
int update = jdbcTemplate.update(sql, id);
System.out.println(update);
}
//查询表记录数
@Override
public int selectConent() {
String sql = "select count(*) from t_book";
Integer count = jdbcTemplate.queryForObject(sql, Integer.class);
return count;
}
//查询返回对象
@Override
public Book findBookInfo(String id) {
String sql = "select * from t_book where userid=?";
//调用方法
Book book = jdbcTemplate.queryForObject(sql, new BeanPropertyRowMapper(Book.class), id);
return book;
}
//查询返回集合
@Override
public List findAllBook() {
String sql ="select * from t_book";
//调用方法
List bookList = jdbcTemplate.query(sql, new BeanPropertyRowMapper(Book.class));
return bookList;
}
//批量添加
@Override
public void batchAddBook(List batchArgs) {
String sql ="insert into t_book values(?,?,?)";
int[] ints = jdbcTemplate.batchUpdate(sql,batchArgs);
System.out.println(Arrays.toString(ints));
}
//批量修改
@Override
public void batchUpdate(List batchArgs) {
String sql = "update t_book set username=?,ustatus=? where userid=?";
int[] ints = jdbcTemplate.batchUpdate(sql, batchArgs);
System.out.println(ints);
}
//批量删除
@Override
public void batchDelete(List batchArgs) {
String sql = "delete from t_book where userid=?";
int[] ints = jdbcTemplate.batchUpdate(sql, batchArgs);
System.out.println(ints);
}
}
(3)编写测试类
package com.atguigu.spring5.test;
import com.atguigu.spring5.entity.Book;
import com.atguigu.spring5.service.BookService;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.testng.annotations.Test;
import sun.java2d.pipe.AlphaPaintPipe;
import java.util.ArrayList;
import java.util.List;
public class TestBook {
@Test
public void testDeleteBook(){
ApplicationContext context = new ClassPathXmlApplicationContext("bean1.xml");
BookService bookService = context.getBean("bookService", BookService.class);
//批量删除
List batchArgs = new ArrayList<>();
Object[] o1 ={"3"};
Object[] o2 ={"4"};
batchArgs.add(o1);
batchArgs.add(o2);
//调用方法实现批量修改
bookService.batchDelete(batchArgs);
}
@Test
public void testBatchUpdate(){
ApplicationContext context = new ClassPathXmlApplicationContext("bean1.xml");
BookService bookService = context.getBean("bookService", BookService.class);
//批量修改
List batchArgs = new ArrayList<>();
Object[] o1 ={"Mysql999","ok","3"};
Object[] o2 ={"python999","ok","4"};
Object[] o3 ={"html999","ok","5"};
batchArgs.add(o1);
batchArgs.add(o2);
batchArgs.add(o3);
//调用方法实现批量修改
bookService.batchUpdate(batchArgs);
}
@Test
public void testBatchAddBook(){
ApplicationContext context = new ClassPathXmlApplicationContext("bean1.xml");
BookService bookService = context.getBean("bookService", BookService.class);
//批量添加
List batchArgs = new ArrayList<>();
Object[] o1 ={"3","Mysql","ok"};
Object[] o2 ={"4","python","ok"};
Object[] o3 ={"5","html","ok"};
batchArgs.add(o1);
batchArgs.add(o2);
batchArgs.add(o3);
//调用批量添加
bookService.batchAdd(batchArgs);
}
@Test
public void testSelect3(){
ApplicationContext context = new ClassPathXmlApplicationContext("bean1.xml");
BookService bookService = context.getBean("bookService", BookService.class);
//查询返回集合
List all = bookService.findAll();
System.out.println(all);
}
@Test
public void testSelect2(){
ApplicationContext context = new ClassPathXmlApplicationContext("bean1.xml");
BookService bookService = context.getBean("bookService", BookService.class);
//查询返回对象
Book book = bookService.findOne("2");
System.out.println(book);
}
@Test
public void testSelect(){
ApplicationContext context = new ClassPathXmlApplicationContext("bean1.xml");
BookService bookService = context.getBean("bookService", BookService.class);
//查询
int count = bookService.findCount();
System.out.println(count);
}
@Test
public void testDelete(){
ApplicationContext context = new ClassPathXmlApplicationContext("bean1.xml");
BookService bookService = context.getBean("bookService", BookService.class);
//删除
Book book = new Book();
bookService.deleteBook("1");
}
@Test
public void testUpdate(){
ApplicationContext context = new ClassPathXmlApplicationContext("bean1.xml");
BookService bookService = context.getBean("bookService", BookService.class);
//修改
Book book = new Book();
book.setUserid("1");
book.setUsername("javaup");
book.setUstatus("Abc");
bookService.updateBook(book);
}
@Test
public void testAdd(){
ApplicationContext context = new ClassPathXmlApplicationContext("bean1.xml");
BookService bookService = context.getBean("bookService", BookService.class);
//添加
Book book = new Book();
book.setUserid("1");
book.setUsername("java");
book.setUstatus("A");
bookService.addBook(book);
}
}
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)