<%@ page language = "java" import = "java.sql.*,java.io.*,java.util.*,java.util.Date,java.text.*,java.net.*,javax.servlet.*" %><%Class.forName("org.gjt.mm.mysql.Driver").newInstance();Connection myConn = DriverManager.getConnection("jdbc:mysql:///wadia");Statement stmt = myConn.createStatement();Statement stmt_bse = myConn.createStatement();// media tickerResultSet myResultSet = stmt.executeQuery("select news_id,headlines from media_releases where archive = 0 and active = 0");if (myResultSet != null){ String source=""; while (myResultSet.next()) { int id = 0; id = myResultSet.getInt("news_id"); String headlines = myResultSet.getString("headlines"); String hdlines = myResultSet.getString("headlines"); hdlines=hdlines.replace('~','\''); String texturl = "../wadia/media/media_details.jsp?head="+id; source += hdlines + "|" + texturl + "\n " ; char buffer[] = new char[source.length()]; source.getChars(0,source.length(), buffer, 0); } //out.println(source); FileWriter f1 = new FileWriter("c:/javawebserver2.0/public_html/wadia/input.txt"); f1.write(source); f1.close(); }stmt.close(); // bse-nse tickerint x=0; try { ResultSet rs=stmt_bse.executeQuery("SELECT * from groupmaster g,bseticker b where b.comp_id = g.comp_id group by g.comp_id"); Vector v=new Vector(3); Vector v1=new Vector(3); String source=""; while (rs.next()) { v.addElement(rs.getString("comp_id")); v1.addElement(rs.getString("comp_name")); } for(int i=0;i "); Statement statement1=myConn.createStatement(); Statement statement2=myConn.createStatement(); ResultSet rs1=statement1.executeQuery("SELECT * from bseticker where comp_id = "+v.elementAt(i)+" order by id desc"); ResultSet rs2=statement2.executeQuery("SELECT * from bseticker order by date desc limit 2"); float sharepoints[]= new float[15]; String sdf1[] = new String[2]; float difference = 0; int j=0; Date date = new Date(); SimpleDateFormat sdf; sdf = new SimpleDateFormat("E MMM dd yyyy"); String sdfdate=""; while(rs1.next()) { sharepoints[j] = rs1.getFloat("shareprice"); j++; } j=0; while (rs2.next()) { date =rs2.getDate("date"); sdfdate= sdf.format(date); sdf1[j] = sdfdate; j++; } //}; String source1 = ""; if (x == 0) { //out.println("BSE Updated on " + sdf1[x] +"\n"); source1 +=("BSE Updated on " +sdf1[x] +" - " ); x++; } if (sharepoints[0] > sharepoints[1]) { difference = sharepoints[0] - sharepoints[1]; //out.println("(+" + sharepoints[0] +")"); } else if (sharepoints[0] "); rs1.close(); } rs.close(); }catch (IOException ioe) { out.println(ioe.getMessage()); }catch (SQLException sqle) { out.println(sqle.getMessage()); }stmt_bse.close();myConn.close();%>

		Think Of A Purpose That Spirals Forth To Create Innovations From Within. This Visionary Zeal; Built On Trust And Knowledge, Has Empowered The Wadia Group In Various Business Enterprises For more Than A Century. It now promises much more in the New Economy ...

SiteMap |

Copyrights © 2000, Wadia Group All rights reserved.

Developed by The Farm