通过调用数据库工具类和PrepareStatement来对数据库实现更新操作
PrepareStatement用来接收sql预编译语句
PrepareStatement ps=conn.PrepareStatement(sql);
五大步骤
1.获取数据库连接
2.预编译sql语句 并获取PrepareStatement的对象
PrepareStatement用来接收sql预编译语句
PrepareStatement ps=conn.PrepareStatement(sql);
3.填充占位符
4.执行操作
5.关闭操作
package com.jdbc3.selectTest;
import java.lang.reflect.Field;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.util.Scanner;
import org.junit.Test;
import com.jdbc3.util.JDBCUtiles;
public class PublicUpdate {
@Test
//删除操作
public void updateTest() {
Scanner scanner = new Scanner(System.in);
System.out.print("请输入要删除人的id:");
int id = scanner.nextInt();
String sql="delete from t_user where id=?";
int insertCount = update(sql,id);
if(insertCount