JDBC中PreparedStatement的

import org.junit.Test;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.PreparedStatement;
import com.mysql.jdbc.ResultSet;
public class TestPreparedStatement {
       /**
        * 使用preparedStatement
        *1、获取连接connection
        *2、准备sql语句
        *3、类preparedStatement，调用cnn的cnn.prepareStatement(sql)语句
        *4、执行preparedStatement
        *1)excuteQury执行查询的方法
        *2)excuteupdate执行更新方法
        * */
       @Test
       public void Test() {
              Connection cnn = null;
              PreparedStatement pst = null;
              ResultSet rs = null;
              try{
                     cnn = (Connection)JDBCTools.getConnection();
                     System.out.println(cnn);
                     String sql = "select * from examstudent";
                     pst = (PreparedStatement) cnn.prepareStatement(sql);
                     rs = (ResultSet) pst.executeQuery();
                    while(rs.next()){
                            int id = rs.getInt(1);
                            int type = rs.getInt(2);
                            String idcard = rs.getString(3);
                           String examCard = rs.getString(4);
                            System.out.println("id="+id+","
                                    +"type="+type+","+"idcard="+idcard+","+"examCard="+examCard);
                     }
              }catch (Exception e) {
                     e.printStackTrace();
              }finally{
                     JDBCTools.release(rs,pst, cnn);
             }
       }
}