Error in database fetching data servlet program

Question

1.00/5 (1 vote)

See more:

C:\J2ee\Servlet>javac RequestServlet.java
RequestServlet.java:17: error: <identifier> expected
class.forName("Oracle.jdbc.driver.OracleDriver");
^
RequestServlet.java:17: error: invalid method declaration; return type required
class.forName("Oracle.jdbc.driver.OracleDriver");
^
RequestServlet.java:17: error: illegal start of type
class.forName("Oracle.jdbc.driver.OracleDriver");
^
RequestServlet.java:24: error: <identifier> expected
out.println("
");
^
RequestServlet.java:24: error: illegal start of type
out.println("

");
^
RequestServlet.java:25: error: <identifier> expected
out.println("");
^
RequestServlet.java:25: error: illegal start of type
out.println("");
^
RequestServlet.java:26: error: illegal start of type
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:26: error: ')' expected
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:26: error: illegal start of type
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:26: error: <identifier> expected
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:26: error: ';' expected
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:26: error: illegal start of type
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:26: error: ';' expected
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:26: error: invalid method declaration; return type required
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:26: error: <identifier> expected
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:26: error: illegal start of type
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:26: error: <identifier> expected
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:27: error: ';' expected
{
^
RequestServlet.java:28: error: illegal start of type
out.println(""
);
^
RequestServlet.java:28: error: illegal start of type
out.println(""
);
^
RequestServlet.java:28: error: ')' expected
out.println(""
);
^
RequestServlet.java:28: error: ';' expected
out.println(""
);
^
RequestServlet.java:28: error: illegal start of type
out.println(""
);
^
RequestServlet.java:28: error: <identifier> expected
out.println(""
);
^
RequestServlet.java:28: error: ';' expected
out.println(""
);
^
26 errors

What I have tried:

import javax.servlet.*;
import java.io.*;
import java.sql.*;

public class RequestServlet extends HttpServlet
{

public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException
{
res.setContentType("Text/Html");
PrintWriter out=res.getWriter();
out.println("");
String name=req.getParameter("Name");
String pass=req.getParameter("Pass");
try
{
class.forName("oracle.jdbc.driver.OracleDriver");
Connection c=DriverManager.getConnection("jdbc:Oracle:thin:@localhost:1521:xe","SYSTEM","oracle123");
Statement s=c.createStatement();
int x=s.executeUpdate("insert into emp101 values('"+name+"','"+pass+"')");

ResultSet rs=s.executeQuery("select * from emp101");
ResultSetMetaData rsmd=rs.getMetaData();
out.println("

"+rsmd.getColumnName(i)+"	"+rsmd.getColumnName(i)+"	"+rsmd.getColumnName(i)+"	"+rsmd.getColumnName(i)+"	"+rsmd.getColumnName(i)+"	"+rsmd.getColumnName(i)+"	"+rsmd.getColumnName(i)+"

");
out.println("");
for(int i=1;i<=rsmd.getColumnCount();i++)
{
out.println("");
}

while(rs.next())
{
out.println("");
out.println("");
out.println("");
out.println("");
}
}

catch(Exception e)
{

}
out.println("

"+rsmd.getColumnName(i)+"
"+rs.getString(1)+"	"+rs.getString(2)+"

");
}
}

Posted 8-Sep-18 22:12pm

Member 13977881

Updated 9-Sep-18 1:31am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Answer 1 · 2018-09-09T01:32:00

Solution 1

You have spelled it class , but it should be Class with upper case C at the beginnng. See Class (Java Platform SE 7 )[^].

Posted 9-Sep-18 1:32am

Richard MacCutchan

Comments

Member 13977881 9-Sep-18 8:02am

now more error showing after changing C in upper case.

Richard MacCutchan 9-Sep-18 8:07am

Well that is sad, but no one here can guess what those more errors may be. Please edit your question, show the actual code (using <pre> tags to format it properly) and explain exactly what the errors are.

Member 13977881 9-Sep-18 8:24am

pre error:

C:\J2ee\Servlet>javac RequestServlet.java
RequestServlet.java:17: error: <identifier> expected
class.forName("Oracle.jdbc.driver.OracleDriver");
^
RequestServlet.java:17: error: invalid method declaration; return type required
class.forName("Oracle.jdbc.driver.OracleDriver");
^
RequestServlet.java:17: error: illegal start of type
class.forName("Oracle.jdbc.driver.OracleDriver");
^
RequestServlet.java:24: error: <identifier> expected
out.println("
");
^
RequestServlet.java:24: error: illegal start of type
out.println("

");
^
RequestServlet.java:25: error: <identifier> expected
out.println("");
^
RequestServlet.java:25: error: illegal start of type
out.println("");
^
RequestServlet.java:26: error: illegal start of type
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:26: error: ')' expected
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:26: error: illegal start of type
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:26: error: <identifier> expected
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:26: error: ';' expected
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:26: error: illegal start of type
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:26: error: ';' expected
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:26: error: invalid method declaration; return type required
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:26: error: <identifier> expected
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:26: error: illegal start of type
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:26: error: <identifier> expected
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:27: error: ';' expected
{
^
RequestServlet.java:28: error: illegal start of type
out.println(""
);
^
RequestServlet.java:28: error: illegal start of type
out.println(""
);
^
RequestServlet.java:28: error: ')' expected
out.println(""
);
^
RequestServlet.java:28: error: ';' expected
out.println(""
);
^
RequestServlet.java:28: error: illegal start of type
out.println(""
);
^
RequestServlet.java:28: error: <identifier> expected
out.println(""
);
^
RequestServlet.java:28: error: ';' expected
out.println(""
);
^
26 errors

post error(after changing c in upper case):
RequestServlet.java:47: class, interface, or enum expected
while(rs.next())
^
RequestServlet.java:50: class, interface, or enum expected
out.println(""+rs.getString(1)+"");
^
RequestServlet.java:51: class, interface, or enum expected
out.println(""+rs.getString(2)+"");
^
RequestServlet.java:52: class, interface, or enum expected
out.println("");
^
RequestServlet.java:53: class, interface, or enum expected
}
^
RequestServlet.java:61: class, interface, or enum expected
}
^
RequestServlet.java:64: class, interface, or enum expected
public void doGet(HttpServletRequest req, HttpServletResponse res)throw
ServletException,IOException
^
RequestServlet.java:67: class, interface, or enum expected
PrintWriter out=res.getWriter();
^
RequestServlet.java:68: class, interface, or enum expected
out.println("");
^
RequestServlet.java:69: class, interface, or enum expected
String name=req.getParameter("name");
^
RequestServlet.java:70: class, interface, or enum expected
String pass=req.getParameter("pass");

Richard MacCutchan 9-Sep-18 8:53am

Why have you added the initial code that was wrong? You have obviously got something else wrong in your source code before the line that shows the first error. So please look at your code (I cannot because you did not include it) and see where you have missed a keyword or punctuation.

Member 13977881 9-Sep-18 9:20am

problem solved.

Thank you Richard