Results 1 to 4 of 4
Thread: java.SQLException
LinkBack URL
About LinkBacks- 12-08-2011, 07:18 AM #1
Member
- Join Date
- Dec 2011
- Posts
- 6
- Rep Power
- 0
java.SQLException
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.ResultSet;
import java.sql.Statement;
import org.omg.IOP.ServiceContext;
public class EmpServlet extends HttpServlet
{
public void doPost(HttpServletRequest req, HttpServletResponse res)throws ServletException,IOException
{
String name=req.getParameter("username");
String pwd=req.getParameter("password");
name=name.toLowerCase();
String s1=null;
String s2=null;
String s3=null;
String s4=null;
String s5=null;
res.setContentType("text/html");
PrintWriter out=res.getWriter();
out.println(name);
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDrive");
Connection con= DriverManager.getConnection("jdbc:odbc:employee"," system","sanjay16");
Statement stmt=con.createStatement();
ResultSet rs1=stmt.executeQuery("select empid from employee where empname="+name);
while(rs1.next())
{
s5=rs1.getString(1);
}
ResultSet rs=stmt.executeQuery("select * from employee where empid="+s5);
while(rs.next())
{
s1=rs.getString(1);
s2=rs.getString(2);
s3=rs.getString(3);
s4=rs.getString(4);
}
HttpSession session=req.getSession();
session.setAttribute("employeeid",s5);
if(s2.equals(name)&&pwd.equals(s3))
{
out.println("Welcome "+name+"\n");
out.println("<html><body background=bcg.jpg>"+"<h1>Your Profile</h1>");
out.println("Name is :"+s2+"<br></br>");
out.println("Employee id is :"+s1+"<br></br>");
out.println("Password is :"+s3+"<br></br>");
out.println("Sallery is :"+s4+"<br></br>");
out.println("<center>");
out.println("<form method=post action=LeaveHistoryServlet>");
out.println("<input type=submit value=LeaveHistory >"+"<br></br>");
out.println("</form");
out.println("</center>");
out.println("</html>"+"</body>");
}
else
{
out.println("<html><head></head><body background=bcg.jpg><h2>Sorry,Username or password is wrong</h2></body></html>");
}
out.close();
rs.close();
stmt.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
This is my code, from the html code i am entering username and password as naveen,1111 respectively.
I am using type1 driver and Apachi tomcat server.
It is giving java.sql.SQLException that ORA-0094 'NAVEEN' invalid identifier.
And even after printing 'name' value it is printing small case 'naveen' only.
Can anyone please help me?
- 12-08-2011, 11:12 AM #2
Member
- Join Date
- Sep 2011
- Location
- Athens Greece
- Posts
- 29
- Rep Power
- 0
Re: java.SQLException
I think the problem is in this line:
try it like this:Java Code:ResultSet rs1=stmt.executeQuery("select empid from employee where empname="+name);
Java Code:ResultSet rs1=stmt.executeQuery("select empid from employee where empname=' "+name+" ' ");
- 12-08-2011, 01:15 PM #3
Moderator
- Join Date
- Apr 2009
- Posts
- 10,484
- Rep Power
- 16
Re: java.SQLException
Better yet, use a PreparedStatement, and setString(1,name).
- 12-08-2011, 01:51 PM #4
Member
- Join Date
- Apr 2011
- Posts
- 69
- Rep Power
- 0
Re: java.SQLException
Both are correct, you need a quote to surround a string value in SQL. Prepared statements allow you to not worry about that stuff though :)
Reply With QuoteSimilar Threads
-
java.sql.SQLException: Closed Connection
By sunjavaboy in forum JDBCReplies: 4Last Post: 03-21-2012, 01:38 PM -
java.sql.SQLException:
By nandhinianand in forum New To JavaReplies: 2Last Post: 09-28-2011, 07:15 AM -
java.sql.sqlException
By harsimran05 in forum JDBCReplies: 1Last Post: 09-06-2011, 12:14 PM -
java.sql.SQLException: System or internal error java.io.IOException: Stream closed
By ashok bhagat in forum Advanced JavaReplies: 0Last Post: 01-21-2011, 12:43 PM -
java.sql.SQLException: Exhausted Resultset
By boy22 in forum JDBCReplies: 2Last Post: 06-07-2010, 08:45 AM
Bookmarks