9
Hi, I have been trying to connect my JSP file to my Oracle database but the server does not seem to like it and won't connect, I have the following code:
<%@ page language="java" contentType="te xt/html" errorPage="erro rpage.jsp" import="java.sq l.*" %>
<html><head><ti tle>Login</title></head>
<body>
<% //1. load the SQL JDBC driver
Class.forName(" oracle.jdbc.dri ver.OracleDrive r");
// 2. Open a connection to the database
Connection Conn = DriverManager.g etConnection("j dbc:oracle:thin :");
// 3. create a statement object for sending sql queries
Statement Stmt = Conn.createStat ement();
// 4. place the query results in a ResultSet object
ResultSet RS = Stmt.executeQue ry
("SELECT message
FROM manstaffdb
WHERE name = '" + request.getPara meter("name") + "'
AND password= PASSWORD('" + request.getPara meter("password ")+"')");
// 5. assign ResultSet's column 1 to a String variable
String message = null;
while(RS.next() ) { message = RS.getString(1) ; }
// 6. Clean up all objects
RS.close(); Stmt.close(); Conn.close();
%>
<% if(message != null){
session.setAttr ibute("welcome" , message); %>
<h4>Your login has succeeded. Thank you.</h4>
<% } else { %>
<h4>Your login has failed, please try again.</h4>
<% } %>
<a href="<%= response.encode URL("db-login.jsp") %>">
Continue...</a>
</body></html>
Can anyone see where I'm going wrong??
Thank you!
