java连接oracle之查询

class QueryByTerms{int index = 1;//参数的位置public ResultSet toChoose(Connection con, int chose, String var){String sql = null;switch(chose){case 1:sql = "select * from worker_main where worker_id = ?";break;case 2:sql = "select * from worker_main where name = ?";break;}return queryByTerms(con, sql, index, var);}private static ResultSet queryByTerms(Connection con, String sql, int index, String var)//调用时候进行参数的合理化判断{PreparedStatement pre = null;ResultSet result = null;try {pre = con.prepareStatement(sql);pre.setString(index, var);result = pre.executeQuery();}catch (SQLException e){e.printStackTrace();}System.out.println(sql);System.out.println(var);return result;//返回结果进行选择输出}};