
Hi.. Good Morning Please say me whts wrong in this application
import javax.servlet.*; import javax.servlet.http.*; import java.sql.*; import java.io.*;
public class DBServlet extends HttpServlet { public void doGet(HttpServletRequest req,HttpServletResponse res) { try { // Getting query String qry; qry = req.getParameter("query"); System.out.println(qry);
// DB accessing
/*Class.forName("oracle.jdbc.driver.OracleDriver");
System.out.println("driver");
Connection con;
con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:satya","scott","tiger");
System.out.println(con);
Statement st;
st = con.createStatement();
ResultSet rs;
rs = st.executeQuery(qry);*/
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection ("jdbc:mysql://localhost:3306/test","root","");
Statement st= con.createStatement();
ResultSet rs = st.executeQuery(qry);
// Sending table
PrintWriter pw;
pw = res.getWriter();
/*pw.println("<html>");
pw.println("<body>");
pw.println("<table border=0 width=100%>");
pw.println("<tr>");
pw.println("<th> firstname </th>");
pw.println("<th> lastname </th>");
pw.println("<th> age </th>");
pw.println("</tr>");
while(rs.next()) {
pw.println("<tr>");
pw.println("<td>" + rs.getString(1) + "</td>");
pw.println("<td>" + rs.getString(2) + "</td>");
pw.println("<td>" + rs.getInt(3) + "</td>");
pw.println("</tr>");
} //while*/
rs.close();
st.close();
con.close();
pw.println("</table> </body> </html>");
} //try
catch(Exception e) {
e.printStackTrace();
}
} // doGet()
} // class
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.