not able to retrieve data from database through servlet
Hi friends,
I am trying to open a excel sheet through servlet. In this servlet i am retriving data from mssql database.I am not getting any error but no data is retrived
i m also pasting the code here
// Decompiled by Jad v1.5.8f. Copyright 2001 Pavel Kouznetsov.
// Jad home page: http://www.kpdus.com/jad.html
// Decompiler options: packimports(3)
// Source File Name:EmployeeData.java
import java.io.*;
import java.sql.*;
import javax.sql.*;
import javax.servlet.ServletException;
import javax.servlet.http.*;
publicclass EmployeeDataextends HttpServlet
{
public EmployeeData()
{
}
publicvoid service(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
throws ServletException, IOException
{
httpservletresponse.setContentType("text/html");
httpservletresponse.setHeader("Content-Type","application/excel");
httpservletresponse.setHeader("Content-Disposition","filename=reports.xls");
PrintWriter printwriter = httpservletresponse.getWriter();
try
{
javax.servlet.http.HttpSession httpsession = httpservletrequest.getSession(true);
int i = 0;
/*Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
Connection connection = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:3413;DatabaseName=newreportsodbc", "reportuser", "cisco");*/
String url="jdbc:odbc:newreportsodbc";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
Connection connection = DriverManager.getConnection("jdbc:odbc:newreportsodbc","reportuser","cisco");
Statement statement = connection.createStatement();
printwriter.println("<b><center><u> Search Results </u></center></b>");
printwriter.print("<table><tr><th color=brown background-color=#fff000> No. </th>");
printwriter.print("<th> DateTime</th></tr></table>");
ResultSet resultset = statement.executeQuery("SELECT * FROM t_Call_Type_Half_Hour");
boolean flag;
for(flag =false; resultset.next(); flag =true)
{
i++;
SerialNo = resultset.getString(2);
printwriter.print((new StringBuilder()).append("<table><tr><td> ").append(i).append("</td>").toString());
printwriter.print((new StringBuilder()).append("<td> ").append(SerialNo).append("</td></tr></table>").toString());
}
if(!flag)
printwriter.println("<h1> No records selected </h1>");
}
catch(Exception exception)
{
System.out.println((new StringBuilder()).append("SQLException: ").append(exception).toString());
}
}
static String empid1;
static String empid;
static String SerialNo;
static String designation;
}
thanks in advance. i just feel there is something to be done with connection string.
