/** * @deprecated use getAllModules instead. Doesn't twerk. * @return */ public List<Module> getModules() { List<Module> modules = new ArrayList<Module>(); ResultSet result = db.preformQuery("Select * From module"); try { while (result.next()) { List links = new ArrayList(); links = getModuleLinks(result.getString("moduleID")); Module module = new Module( result.getString("moduleID"), result.getString("moduleName"), result.getString("moduleSummery"), result.getString("moduleDescription"), links); modules.add(module); } } catch (Exception e) { LogHandler.handler.append( LogHandler.warning.ERROR, e.toString(), "Problem with getting all modules"); } return modules; }
/** * Returns job information in the DDBB. * * @param jobId the job identification. * @return the {@link eu.aliada.ckancreation.model.Job} which contains the job information. * @since 2.0 */ public Job getJob(final int jobId) { // Get the job information from the DDBB final Job job = new Job(); job.setId(jobId); try { final Statement sta = getConnection().createStatement(); final String sql = "SELECT * FROM ckancreation_job_instances WHERE job_id=" + jobId; final ResultSet resultSet = sta.executeQuery(sql); while (resultSet.next()) { job.setStartDate(resultSet.getTimestamp("start_date")); job.setEndDate(resultSet.getTimestamp("end_date")); job.setCkanOrgURL(resultSet.getString("ckan_org_url")); job.setCkanDatasetURL(resultSet.getString("ckan_dataset_url")); // Determine job status String status = JOB_STATUS_IDLE; if (job.getStartDate() != null) { status = JOB_STATUS_RUNNING; if (job.getEndDate() != null) { status = JOB_STATUS_FINISHED; } } job.setStatus(status); } resultSet.close(); sta.close(); } catch (SQLException exception) { LOGGER.error(MessageCatalog._00024_DATA_ACCESS_FAILURE, exception); return null; } return job; }
private FileContent getFileContentWithChunkChecksums(FileChecksum fileChecksum) { try (PreparedStatement preparedStatement = getStatement("filecontent.select.all.getFileContentByChecksumWithChunkChecksums.sql")) { preparedStatement.setString(1, fileChecksum.toString()); try (ResultSet resultSet = preparedStatement.executeQuery()) { FileContent fileContent = null; while (resultSet.next()) { if (fileContent == null) { fileContent = new FileContent(); fileContent.setChecksum( FileChecksum.parseFileChecksum(resultSet.getString("checksum"))); fileContent.setSize(resultSet.getLong("size")); } // Add chunk references ChunkChecksum chunkChecksum = ChunkChecksum.parseChunkChecksum(resultSet.getString("chunk_checksum")); fileContent.addChunk(chunkChecksum); } return fileContent; } } catch (SQLException e) { throw new RuntimeException(e); } }
@Override public Client search(int id) { ResultSet resultSet = null; try { preparedStatement = connection.prepareStatement("SELECT * FROM clients"); resultSet = preparedStatement.executeQuery(); while (resultSet.next()) { if (Integer.valueOf(resultSet.getString("id_client")) == id) { return new Client( resultSet.getString("name"), resultSet.getString("login"), resultSet.getString("phone"), resultSet.getString("email"), resultSet.getString("password")); } } } catch (SQLException e) { e.printStackTrace(); } return null; }
/** * @param user * @param rst * @throws SQLException */ public DataModel loadUserVO(UserData user, ResultSet rst) throws TMException, SQLException { if (!rst.next()) { return null; } if (user == null) { user = new UserData(); } try { user.setId(rst.getLong(ID)); } catch (FixedValueException e) { // TODO Auto-generated catch block logger.error(e.getMessage(), e); } user.setUserName(rst.getString(USER_NAME)); user.setPassword(rst.getString(PASSWORD)); user.setFirstName(rst.getString(FIRST_NAME)); user.setMiddleName(rst.getString(MIDDLE_NAME)); user.setLastName(rst.getString(LAST_NAME)); user.setUserName(rst.getString(EMAIL_ID)); user.setDob(rst.getString(DOB)); user.setSex(rst.getInt(SEX)); user.setAddressId(rst.getLong(ADDRESS_ID)); user.setMaritalStatus(rst.getString(MARITAL_STATUS)); user.setNationality(rst.getString(NATIONALITY)); user.setImage(rst.getObject(IMAGE)); user.setActive(rst.getBoolean(IS_ACTIVE)); user.setActivationKey(rst.getString(ACTIVATION_KEY)); return user; }
private Map<FileChecksum, FileContent> createFileContents(ResultSet resultSet) throws SQLException { Map<FileChecksum, FileContent> fileContents = new HashMap<FileChecksum, FileContent>(); FileChecksum currentFileChecksum = null; while (resultSet.next()) { FileChecksum fileChecksum = FileChecksum.parseFileChecksum(resultSet.getString("checksum")); FileContent fileContent = null; if (currentFileChecksum != null && currentFileChecksum.equals(fileChecksum)) { fileContent = fileContents.get(fileChecksum); } else { fileContent = new FileContent(); fileContent.setChecksum(fileChecksum); fileContent.setSize(resultSet.getLong("size")); } ChunkChecksum chunkChecksum = ChunkChecksum.parseChunkChecksum(resultSet.getString("chunk_checksum")); fileContent.addChunk(chunkChecksum); fileContents.put(fileChecksum, fileContent); currentFileChecksum = fileChecksum; } return fileContents; }
/** Web service operation */ @WebMethod(operationName = "getUserByUID") public User getUserByUID(@WebParam(name = "uid") int uid) { User result = null; try { Statement stmt = conn.createStatement(); String sql; sql = "SELECT * FROM user WHERE u_id = ?"; PreparedStatement dbStatement = conn.prepareStatement(sql); dbStatement.setInt(1, uid); ResultSet rs = dbStatement.executeQuery(); // Extract data from result set if (rs.next()) { result = new User( rs.getInt("u_id"), rs.getString("name"), rs.getString("email"), rs.getString("password")); } else { result = new User(); } rs.close(); stmt.close(); } catch (SQLException ex) { Logger.getLogger(QuestionWS.class.getName()).log(Level.SEVERE, null, ex); } return result; }
private static double getPrismPoint( String spatialcontext, String viewpoint, Database db, InputXML input, Point[] points) throws SQLException, ClientException, Exception { double prismPoint; if (input.getType().equals("PRISM")) { ResultSet result = db.getViewpoint(spatialcontext, viewpoint); if (!result.next()) { throw new ClientException( "viewpoint " + viewpoint + " in spatialcontext " + spatialcontext + " does not exist", 404); } String filename = Config.getProperty("pointcloudpath") + result.getString("filename"); Transformation trans = new Transformation(result.getString("pointcloud_trans")); trans.transform(new Transformation(result.getString("viewpoint_trans"))); Transformation inv = trans.inverse(); if (result.next()) { Config.warn( "more than one viewpoint in spatialcontext " + spatialcontext + " with name " + viewpoint + " in the database"); } PlanarPolygon tmp = new PlanarPolygon(input.getAngles(), points); tmp.transform(inv); prismPoint = PTGInteraction.getPrismaPoint(tmp, filename); tmp.transform(trans); } else { prismPoint = 0; } return prismPoint; }
void dodajpizzedozamowienia(int numer) { try { con = DriverManager.getConnection( "jdbc:derby://localhost:1527/BazaPizzerii", "pizzeria", "pizzeria"); stmt2 = con.createStatement(); res2 = stmt2.executeQuery( "select * from ZAMOWIENIE Z join SZCZ_O_PIZZY AS SP on Z.ID_ZAM=SP.ID_ZAM" + " join MENU_PIZZA AS MP on SP.ID_PIZZY=MP.ID_PIZZY where Z.id_zam=" + numer); while (res2.next()) { int idszcz = res2.getInt("id_szcz_o_pizzy"); int ilepizzy = res2.getInt("ile_sztuk_p"); String pizza = ilepizzy + ""; pizza += "x " + res2.getString("nazwa"); pizza += " " + res2.getString("rozmiar"); String ciasto = res2.getString("ciasto"); if (ciasto.contains("grube")) { pizza += " na grubym cieście"; } else if (ciasto.contains("cienkie")) { pizza += " na cienkim cieście"; } pizza += " " + dodajskladniki(idszcz, numer); model1.addElement(pizza); } lista.setModel(model1); } catch (SQLException ex) { } }
public String retornaResp(int tipo, int id) throws SQLException { if (tipo == 0) { sql = "select descricao from grupo where idgrupo = ?"; if (!FabricaConexoes.verificaConexao()) FabricaConexoes.getConexao(); stm = FabricaConexoes.returnStatement(sql); stm.setInt(1, id); rs = FabricaConexoes.returnResult(stm); rs.next(); return rs.getString("Descricao"); } else if (tipo == 1) { sql = "select nome from usuario where idusuario = ?"; if (!FabricaConexoes.verificaConexao()) FabricaConexoes.getConexao(); stm = FabricaConexoes.returnStatement(sql); stm.setInt(1, id); rs = FabricaConexoes.returnResult(stm); rs.next(); return rs.getString("nome"); } else if (tipo == 2) { return "Destinado"; } else { return ""; } }
public List<Employee> getEmployee() { connect(); List<Employee> eList = new ArrayList<Employee>(); try { String sql = "SELECT * FROM employee"; // SQL文を指定 // クエリーを実行して結果セットを取得 ResultSet rs = stmt.executeQuery(sql); // 検索された行数分ループ while (rs.next()) { Employee emp = new Employee(); emp.setId(rs.getInt("id")); // classを取得 emp.setName(rs.getString("name")); // nameを取得 emp.setAge(rs.getInt("age")); // clubを取得 emp.setAddress(rs.getString("address")); // addressを取得 eList.add(emp); } close(); } catch (SQLException e) { // TODO 自動生成された catch ブロック e.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } return eList; }
public synchronized PlayerInventoryAccount getSellerAccount(ItemForSale ifs) { try { PreparedStatement getSellerAccount = this.con.prepareStatement( "SELECT id,uuid,username FROM " + this.TBL_ACCOUNTS + " WHERE id=(SELECT seller_id FROM " + this.TBL_ITEMS + " WHERE id=? LIMIT 1) LIMIT 1;"); getSellerAccount.setInt(1, ifs.getDbID()); ResultSet result = getSellerAccount.executeQuery(); if (result.next()) { String username = result.getString("username"); int dbID = result.getInt("id"); UUID uuid = UUID.fromString(result.getString("uuid")); return new PlayerInventoryAccount(dbID, uuid, username); } } catch (SQLException ex) { Logger.getLogger(InventoryManager.class.getName()).log(Level.SEVERE, null, ex); } return null; }
public void readDataBase(Connection connect) throws Exception { try { // Statements allow to issue SQL queries to the database statement = connect.createStatement(); // Result set get the result of the SQL query rs = statement.executeQuery( "SELECT id, name, address, port, icon, realmflags, timezone, allowedSecurityLevel, population FROM realmlist WHERE (realmflags & 1) = 0 ORDER BY name"); realms.clear(); while (rs.next()) { Realm list = new Realm(); list.setId(rs.getInt("id")); list.setName(rs.getString("Name")); list.setAddress(rs.getString("address")); list.setPort(rs.getShort("port")); list.setIcon(rs.getShort("icon")); list.setRealmflags(rs.getShort("realmflags")); list.setTimezone(rs.getShort("timezone")); list.setAllowedSecurityLevel(rs.getShort("allowedSecurityLevel")); list.setPopulation(rs.getFloat("population")); realms.add(list); } } catch (Exception e) { throw e; } finally { close(); } }
/** * Gets comments by module list id * * @param moduleListId * @return List DataModel.Comment */ public List<Comment> getCommentsByModuleListId(String moduleListId) { List<Comment> comments = new ArrayList<Comment>(); ResultSet result = db.preformQuery("SELECT * FROM Comments WHERE ModuleListID ='" + moduleListId + "'"); try { while (result.next()) { Comment entry = new Comment( result.getInt("commentID"), result.getString("commentType"), result.getString("moduleListID"), result.getString("userID"), result.getString("commentDate"), result.getString("commentText")); comments.add(entry); } } catch (Exception e) { LogHandler.handler.append( LogHandler.warning.ERROR, "Problem with select from getCommentsByModuleListId user", e); } return comments; }
/** * Gets messages from a user. * * @param user * @return List DataModel.Messages */ public List<Messages> getMessagesFromUser(String user) { List<Messages> messages = new ArrayList<Messages>(); ResultSet result = db.preformQuery("SELECT * FROM Messages WHERE userIDFrom='" + user + "'"); try { while (result.next()) { Messages entry = new Messages( result.getString("messageID"), result.getString("messageDate"), result.getString("userIDfrom"), result.getString("UserIDTo"), result.getString("headLine"), result.getString("content")); messages.add(entry); } } catch (Exception e) { LogHandler.handler.append( LogHandler.warning.ERROR, "Problem with select from messages TO user", e); } return messages; }
/** * Gets all the files that is delivered to the module. Module-id refers to a delivered task * * @param moduleId * @return List DataModel.ModuleFile */ public List<ModuleFile> getModuleFiles(String moduleId) { ResultSet result = db.preformQuery( "SELECT * FROM " + Tables.MODULEDATEDELIVERY_TABLE + " WHERE moduleListID='" + moduleId + "';"); List<ModuleFile> files = new ArrayList<ModuleFile>(); try { while (result.next()) { ModuleFile file = new ModuleFile(); file.setModuleFileId(result.getString("moduleFileID")); file.setModuleListId(result.getString("moduleListID")); file.setFile(result.getString("moduleFile")); files.add(file); } } catch (Exception e) { LogHandler.handler.append( LogHandler.warning.ERROR, "Problem with getting module files for " + moduleId, e); } return files; }
/** * Gets the number of links from the specified ALIADA dataset to the specified target dataset. * * @param datasetId The dataset Identifier in the internal DB. * @param targetDataset The target dataset name. * @return the number of links. * @since 2.0 */ public int getNumLinksToExtDataset(final int datasetId, final String targetDataset) { int numLinks = 0; try { final Statement sta = getConnection().createStatement(); String sql = "SELECT job.input_graph, subjob.num_links FROM subset, linksdiscovery_job_instances job," + " linksdiscovery_subjob_instances subjob WHERE subset.datasetId=" + datasetId + " AND job.input_graph=subset.graph_uri AND subjob.job_id=job.job_id" + " AND subjob.name='" + targetDataset + // Order the results to group together the links for the same graph // so that we only use the first row of them, as it is the latest linking // performed against that graph "' ORDER BY job.input_graph DESC, subjob.end_date DESC"; ResultSet resultSet = sta.executeQuery(sql); String prevGraph = ""; while (resultSet.next()) { if (!prevGraph.equals(resultSet.getString("input_graph"))) { // Get only the latest number of links found. numLinks = numLinks + resultSet.getInt("num_links"); prevGraph = resultSet.getString("input_graph"); } } resultSet.close(); sta.close(); } catch (SQLException exception) { LOGGER.error(MessageCatalog._00024_DATA_ACCESS_FAILURE, exception); } return numLinks; }
@Override public Article mapRow(ResultSet rs, int rowNum) throws SQLException { Article a = new Article(); a.setId(rs.getInt("id")); a.setTitle(rs.getString("title")); Blob blob = rs.getBlob("content"); int len = (int) blob.length(); byte[] data = blob.getBytes(0, len); String content = new String(data); a.setContent(content); a.setCtime(rs.getTimestamp("ctime")); a.setUptime(rs.getTimestamp("uptime")); a.setTags(rs.getString("tags")); a.setCategory(rs.getString("category")); a.setAuthorId(rs.getInt("authorId")); a.setEditorId(rs.getInt("editorId")); a.setMediaId(rs.getInt("mediaId")); a.setPics(rs.getString("pics")); a.setExtra(rs.getString("extra")); return a; }
public void datatable() { String KJ = jTextField1.getText(); DefaultTableModel tbl = new DefaultTableModel(); tbl.addColumn("No. Plat Polisi"); tbl.addColumn("Jam Masuk"); tbl.addColumn("Jam Kelaur"); tbl.addColumn("Biaya"); tbl.addColumn("ID Petugas"); tbl.addColumn("Kode Kendaraan"); jTable1.setModel(tbl); try { Statement statement = (Statement) conek.GetConnection().createStatement(); ResultSet res = statement.executeQuery("select * from kkeluar where nplat LIKE'" + KJ + "%'"); while (res.next()) { tbl.addRow( new Object[] { res.getString("nplat"), res.getString("jmask"), res.getString("jkluar"), res.getString("biaya"), res.getString("idpetugas"), res.getString("kodejenis") }); jTable1.setModel(tbl); } } catch (Exception e) { JOptionPane.showMessageDialog(rootPane, "Salah"); } }
public static List<Message> getMessagesByUser(User user) { List<Message> messages = new ArrayList<Message>(); ResultSet resultSet; Message message; String text, hash; int id; boolean valid = true; String sql = "SELECT * FROM mail WHERE userid = " + user.getId() + " ;"; try { resultSet = getStatement().executeQuery(sql); while (resultSet.next()) { id = resultSet.getInt("mailid"); text = resultSet.getString("message"); hash = resultSet.getString("hash"); message = Message.create(id, text, text.length(), hash, valid); messages.add(message); } getStatement().close(); } catch (SQLException e) { e.printStackTrace(); // To change body of catch statement use File | Settings | File // Templates. } return messages; }
private static Point[] anglesToFeature( String spatialcontext, String viewpoint, Angle[] angles, Database db) throws ClientException, SQLException, Exception { ResultSet result = db.getViewpoint(spatialcontext, viewpoint); if (!result.next()) { throw new ClientException( "viewpoint " + viewpoint + " in spatialcontext " + spatialcontext + " does not exist", 404); } String filename = Config.getProperty("pointcloudpath") + result.getString("filename"); Transformation ptrans = new Transformation(result.getString("pointcloud_trans")); Transformation vtrans = new Transformation(result.getString("viewpoint_trans")); if (result.next()) { Config.warn( "more than one viewpoint in spatialcontext " + spatialcontext + " with name " + viewpoint + " in the database"); } Point[] points = null; try (Pointcloud pc = new Pointcloud(filename, ptrans)) { points = pc.getPoints(angles); pc.close(); } catch (Exception e) { throw e; } for (Point point : points) { point.transform(vtrans); } return points; }
public UserProfile mapRow(ResultSet rs, int numRow) throws SQLException { UserProfile userProfile = new UserProfile(); userProfile.setUserProfileId(rs.getString("USER_PROFILE_ID")); userProfile.setUserName(rs.getString("NAME")); userProfile.setEmail(rs.getString("EMAIL")); return userProfile; }
private static ElementBean getTrl(String sql) { PreparedStatement pstmt = DB.prepareStatement(sql, null); ElementBean retElementBean = null; try { ResultSet rs = pstmt.executeQuery(); if (rs.next()) { retElementBean = new ElementBean(); retElementBean.setColumnName(rs.getString(1)); retElementBean.setName(rs.getString(2)); retElementBean.setPrintName(rs.getString(3)); retElementBean.setDescription(rs.getString(4)); retElementBean.setHelp(rs.getString(5)); } else { return null; } rs.close(); } catch (Exception ex) { log.severe("Could retrieve element translation with sql: " + sql); } finally { try { pstmt.close(); } catch (Exception ex) { } } return retElementBean; }
public JobIniciado retornaUltimoLote(Connection conn, String job, int operacao) throws SQLException { String sql = " select job, operacao, tripulacao,recurso, max(data_fim) \n" + "from joblote where job = ? and operacao = ? \n" + "group by job, operacao, tripulacao, recurso "; PreparedStatement stmt = null; ResultSet rs = null; JobIniciado iniciado = null; stmt = conn.prepareStatement(sql); stmt.setString(1, job.trim().replace(".", "")); stmt.setInt(2, operacao); rs = stmt.executeQuery(); if (rs.next()) { iniciado = new JobIniciado(); iniciado.setJob(rs.getString(1)); iniciado.setOperacao(rs.getInt(2)); iniciado.setTripulacao(rs.getDouble(3)); iniciado.setRecurso(rs.getString(4)); Timestamp data = rs.getTimestamp(5); iniciado.setData(Validacoes.getDataHoraString(data)); } return iniciado; }
@Override public void columnsForTables(Table table, DatabaseMetaData dbmd) { try { rs = dbmd.getColumns(null, "%", table.getName(), null); ResultSet priamryKeyRs = dbmd.getPrimaryKeys(null, null, table.getName()); String priamryKey = null; while (priamryKeyRs.next()) { priamryKey = priamryKeyRs.getString("COLUMN_NAME"); } while (rs.next()) { Column column = new Column(); String name = rs.getString("COLUMN_NAME"); column.setName(name); column.setType(rs.getString("TYPE_NAME")); int columnSize = rs.getInt("COLUMN_SIZE"); int nullable = rs.getInt("nullable"); column.setNullable(nullable == 1); column.setDataSize(columnSize); if (column.getName().equals(priamryKey)) { column.setPrimaryKey(true); } table.addColumn(column); } } catch (SQLException e) { e.printStackTrace(); } }
private HashMap<String, String> getLoginInfo( String url, String db, String userName, String password) throws SQLException { Connection con = null; String driver = "com.mysql.jdbc.Driver"; HashMap<String, String> info = new HashMap<String, String>(); try { Class.forName(driver); con = DriverManager.getConnection(url + db, userName, password); String selectStatement = "SELECT userId,userName FROM Users"; Statement st = con.createStatement(); ResultSet linksRecords = st.executeQuery(selectStatement); while (linksRecords.next()) { info.put(linksRecords.getString("userId"), linksRecords.getString("userName")); } linksRecords.close(); } catch (SQLException s) { // System.out.println("SQL statement is not executed!\n"+s.getMessage()); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { try { con.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return info; }
public void updateScore(List<Player> players) { try { if (connection == null || players.size() <= 0) { return; } List<String> playersName = new ArrayList<String>(); for (Player player : players) { playersName.add("'" + player.getName() + "'"); } String arrs = join(playersName, ","); String strSql = "SELECT * FROM player WHERE name IN (" + arrs + ")"; cacheScores.clear(); Map<String, Object> map; Statement sql = connection.createStatement(); ResultSet result = sql.executeQuery(strSql); while (result.next()) { map = new HashMap<String, Object>(); map.put("kills", result.getInt("kills")); map.put("deaths", result.getInt("deaths")); map.put("mobs", result.getInt("mobs")); map.put("prefix", result.getString("prefix")); cacheScores.put(result.getString("name"), map); } result.close(); sql.close(); } catch (Exception e) { e.printStackTrace(); } }
@Override public List<User> getAll() throws DAOException { String ALL_USERS = "SELECT * FROM users;"; List<User> users = new ArrayList<>(); Connection connection = null; try { connection = ConnectionHolder.getConnection(); Statement statement = connection.createStatement(); ResultSet rs = statement.executeQuery(ALL_USERS); while (rs.next()) { int k = 1; int id = rs.getInt(k++); String firstName = rs.getString(k++); String lastName = rs.getString(k++); String email = rs.getString(k++); String password = rs.getString(k++); User user = new User(firstName, lastName, email, password, " "); user.setId(id); users.add(user); } } catch (SQLException ex) { log.error("SQLException during answer delete query", ex); throw new DAOException(ex); } return users; }
public static UserLoginResponse userLogIn(final UserLoginRequest userInfo) throws SQLException, IOException, PropertyVetoException, ClassNotFoundException { final String query = Query.SELECT_USER_DETAILS.toString(); final Connection conn = DataSource.getInstance().getConnection(); final PreparedStatement stmt = conn.prepareStatement(query); stmt.setString(1, userInfo.getUserId()); ResultSet rs = stmt.executeQuery(); if (!rs.next()) { conn.close(); throw new SQLException("User ID " + userInfo.getUserId() + " does not exist."); } else { if (!rs.getString("password").equals(userInfo.getPassword())) { conn.close(); throw new SQLException("Authentication problem."); } UserLoginResponse resp = new UserLoginResponse( "200", "Login Success.", userInfo.getUserId(), rs.getString("name"), rs.getString("password"), rs.getString("clickDelayInSeconds"), rs.getString("uploadIntervalInSeconds")); conn.close(); return resp; } }
/** * Gets links to one module * * @param moduleID * @return List DataModel.ModuleResourceLinks */ public List<ModuleResorceLinks> getModuleLinks(String moduleID) { List<ModuleResorceLinks> links = new ArrayList<ModuleResorceLinks>(); ResultSet result = db.preformQuery("SELECT * FROM ModuleResorceLinks WHERE moduleID = '" + moduleID + "';"); try { while (result.next()) { ModuleResorceLinks link = new ModuleResorceLinks( result.getInt("moduleLinkID"), result.getString("moduleID"), result.getString("linkName"), result.getString("link"), result.getString("linkTags")); links.add(link); } } catch (Exception e) { LogHandler.handler.append( LogHandler.warning.ERROR, e.toString(), "Problem with getting ModuleResorceLinks for " + moduleID); } return links; }