import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
//预处理方式
public class preperSTest {
public static void main(String[] args) throws SQLException
{
delete();
}
private static void delete() throws SQLException {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
// 创建连接
conn = JdbcUtils.getConnection();
String sql = " delete from student where id = 1";
ps = conn.prepareStatement(sql);
int i = ps.executeUpdate();
System.out.println(i);
} finally {
JdbcUtils.release(rs, ps, conn);
}
}
}
删前:
删后: