package Demo;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class Demo5 {
public static void main(String[] args) throws Exception {
Connection connection = null;
PreparedStatement statement = null;
ResultSet result = null;
try{
//1.获取连接
connection = JdbcUtil.getConnection();
/*//2.执行预编译的sql
String sql = "DELETE FROM student WHERE id = ;";
//3.执行便宜sql语句
statement = connection.prepareStatement(sql);
//4.设置参数:
//参数位置从1开始.
statement.setString(1, "mary");
statement.setString(2, "女");*/
String sql = "SELECT *FROM student;";
statement = connection.prepareStatement(sql);
result = statement.executeQuery();
while(result.next()){
System.out.println("id:"+result.getInt("id")+"姓名:"+result.getString("name")+"性别:"+result.getString("sex"));
}
/*int count = statement.executeUpdate();
System.out.println("影响了"+count+"行");*/
}catch(Exception e){
throw e;
}finally{
JdbcUtil.close(connection, statement,result);
}
}
}
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class Demo5 {
public static void main(String[] args) throws Exception {
Connection connection = null;
PreparedStatement statement = null;
ResultSet result = null;
try{
//1.获取连接
connection = JdbcUtil.getConnection();
/*//2.执行预编译的sql
String sql = "DELETE FROM student WHERE id = ;";
//3.执行便宜sql语句
statement = connection.prepareStatement(sql);
//4.设置参数:
//参数位置从1开始.
statement.setString(1, "mary");
statement.setString(2, "女");*/
String sql = "SELECT *FROM student;";
statement = connection.prepareStatement(sql);
result = statement.executeQuery();
while(result.next()){
System.out.println("id:"+result.getInt("id")+"姓名:"+result.getString("name")+"性别:"+result.getString("sex"));
}
/*int count = statement.executeUpdate();
System.out.println("影响了"+count+"行");*/
}catch(Exception e){
throw e;
}finally{
JdbcUtil.close(connection, statement,result);
}
}
}