Hi friends,
Im getting following error when I ran my
jsp code in
tomcat.
"oracle.jdbc.driver.OracleDriver cannot be resolved to a type"
I have added ojdbc14.jar in my lib folder. Give me some suggestions to overcome this.
This is my JSP code.
<%@page import ="java.sql.*"%>
<%!
String username;
String password;
String tableName = "BUYSM_USERS";
Connection connection;
ResultSet rs;
%>
<%
username = request.getParameter("username");
password = request.getParameter("password");
if(username!="" && password!="")
{
try{
//register Driver
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
//get Connection
connection = DriverManager.getConnection("jdbc: oracle:thin:@url: DB","user","pwd");
String query = "Select username,password from "+tableName+" where username = ? and password = ?";
PreparedStatement stmt = connection.prepareStatement(query);
stmt.setString(1,username);
stmt.setString(2,password);
rs = stmt.executeQuery();
boolean flag = false;
while(rs.next() && !flag){
if(username.equals(rs.getString(1)) && password.equals(rs.getString(2))){
flag = true;
}
}
if(flag)
//upload page
out.println(username+","+password);
else
//same page
out.println("not found");
}catch(Exception e){
}
}
else
out.println("Enter username & password");
%>
Thanks in advance..