• JAVA-SQL
• ::
• PreparedStatement Class
• ::
• executeQuery ( SQL )

method:executeQuery ( SQL )
return type:ResultSet
content:ใช้เลือกข้อมุลมาจากฐานข้อมูลและเก็บไว้ที่ Object ResultSet
example:Class.forName ( "sun.jdbc.odbc.JdbcOdbcDriver" );
Connection conn = DriverManager.getConnection ( "jdbc:odbc:Nutt" );
String sql = "SELECT * FROM person WHERE sex = ?";
PreparedStatement pstat = conn.preparedStatement ( sql, ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY );
pstat.setInt ( 0, 1 );
Result rs = pstat.executeQuery ( );