JDBC中PreparedStatement的使用

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);
}
}
}