WELCOME TO SLASI.COM

<%-- /*************************************************************************************** * @author - Aruni N Perera * @version - 1.0 * Date Written - started on 23/12/2004 * Last Modified Date - * Purpose of this file - Display News Details * **************************************************************************************/ --%> <%@ page import="java.sql.*,java.util.*,oracle.jdbc.driver.*,oracle.jdbc.pool.*" %> <% Connection conn = null; Statement stmt = null; ResultSet results = null; boolean errFlag = false; String tmpErrorString = ""; String strErrMsg = null; //---- create connection -------- String strDBURL = (String)application.getInitParameter("URL"); String strDBUser = (String)application.getInitParameter("SlasiUser"); String strDBPassword = (String)application.getInitParameter("SlasiPwd"); try { DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); conn = DriverManager.getConnection(""+strDBURL+"",""+strDBUser+"",""+strDBPassword+""); }catch(SQLException e){ System.out.println(e.getMessage()); }catch(NullPointerException ne){ System.out.println(ne.getMessage()); } String strNewsId = null; boolean bFound = false; %> WELCOME TO SLASI.COM

careers | downloads | site map | forum | other info

<% try { String strNewsDet = "SELECT news_heading, news_content, content_type, news_id "+ "FROM news_room ORDER BY created_date DESC "; stmt = conn.createStatement(); results = stmt.executeQuery(strNewsDet); while (results.next()) { %> <% if ((results.getString("content_type")) != null) { strNewsId = results.getString("news_id"); %> <% } %> <% bFound = true; } // end while if (bFound == false) { %> <% } } catch(SQLException e) { try{ conn.close(); conn = null; }catch(SQLException se) { System.out.println("Cannot close logical connection " + se.getMessage()); } } // catch %>

	SLASI Event Calendar
	List of events related to the ICT industry in Sri Lanka.

	<%=results.getString("news_heading")%>
	<%=results.getString("news_content")%>
	download news write-up

	News details not available.