ResultSet 参数設放使用實例

ResultSet 参数設置使用實例

public static String[][] getFunctionUser(String functionID) {Connection con = null;Statement stmt = null;ResultSet rs = null;String[][] returnArray = null;try {con = SimpleServlet.osmCP.getConnection();stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);rs = stmt.executeQuery("select c.userFName || ' ' || c.userLName as userName , c.loginID as userid, c.email from "  + "sysUserProfile c where c.functionID = '" + functionID + "'");rs.last();returnArray = new String[rs.getRow()][3];rs.beforeFirst();while (rs.next()) {returnArray[rs.getRow() - 1][0] = rs.getString("userName");returnArray[rs.getRow() - 1][1] = rs.getString("userid");returnArray[rs.getRow() - 1][2] = rs.getString("email");}} catch (SQLException e) {try {    if(con != null)       con.rollback();} catch (SQLException ex) {    System.out.println("SQLException: " + ex.toString());}System.out.println("SQLException: " + e.toString());e.printStackTrace();} catch (Exception e) {try {    if (con != null) con.rollback();} catch (SQLException ex) {    System.out.println("SQLException: " + ex.toString());}System.out.println("SQLException: " + e.toString());e.printStackTrace();} finally {try {     if (rs != null) rs.close();     if (stmt != null) stmt.close();     if (con != null)  SimpleServlet.osmCP.free(con);} catch (Exception ex) {     ex.printStackTrace();}}return returnArray; }