import java.sql.*;
import javax.xml.parsers.*;
import javax.xml.transform.*;
import javax.xml.transform.dom.*;
import javax.xml.transform.stream.*;
import java.io.*;
import javax.servlet.ServletException;
import javax.servlet.ServletConfig;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpServletRequest;
public class MySer extends HttpServlet
{
public void init(ServletConfig config) throws ServletException
{
super.init(config);
}
public void doGet(HttpServletRequest req,HttpServletResponse res) throws ServletException,java.io.IOException
{
String xml;
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
java.io.PrintWriter out=null;
try
{
res.setContentType("text/html");
out=res.getWriter();
xml = "<chart>";
xml+= "<axis_value shadow='low' size='10' color='000000' alpha='50' steps='6' prefix='' suffix='' decimals='0' separator='' show_min='true' />";
xml+= "<axis_category shadow='low'/>";
xml+= "<chart_border color='000000' top_thickness='0' bottom_thickness='3' left_thickness='0' right_thickness='0'/>";
xml+="<chart_data>";
xml+="<row>";
xml+="<null/>";
}
catch (java.io.IOException e)
{
System.out.println(e.getMessage());
}
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch (ClassNotFoundException e)
{
System.err.println(e);
}
try
{
conn = DriverManager.getConnection("jdbc:odbc:jerry","system","systemm");
stmt = conn.createStatement();
rs= stmt.executeQuery("select * from SOFTWAREDEVELOPER");
while(rs.next()){
//String xml2 = xml;
String xml;
xml+="<string>";
xml+=rs.getInt(3);
xml+="</string>";
out.println(xml);
//out.println("<tr> <td>"+rs.getInt(1)+"</td><td>"+rs.getString(2)+"</td><td>"+rs.getInt(3)+"</td> </tr>");
}
}
catch(SQLException e)
{
System.err.println(e);
}
xml+="</row>";
xml+="</chart_data>";
xml+="<chart_grid_h alpha='20' color='000000' thickness='1' type='solid' />";
xml+="<chart_grid_v alpha='20' color='000000' thickness='1' type='dashed' />";
xml+="<chart_rect shadow='bg' x='125' y='65' width='280' height='200' positive_color='eeeeff' negative_color='ff4400' positive_alpha='90' negative_alpha='75' />";
xml+="<chart_transition type='drop' delay='0' duration='3' order='series' />";
xml+="<chart_type>stacked column</chart_type>";
Writer output1 = null;
File file1 = new File("C:\\Users\\sbabu\\Desktop\\stest.xml");
output1 = new BufferedWriter(new FileWriter(file1));
output1.write(xml);
out.println(xml);
}
}
when i'm running this servlet i'm getting the error
String xml is already defined in doGet(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse)
How i write this in one file..
Please Help me...