java class path
HejsaJeg har lavet en database hvor jeg har tilføjet et userid og et password som kolonner. Jeg har lavet en JSP side og en java class som tjekker om user og password eksisterer i databasen. Hver gang jeg gøre min JSP side får jeg denne fejl:
HTTP Status 404 - /ConnectionLoginForms/Validation.java
type Status report
message /ConnectionLoginForms/Validation.java
description The requested resource is not available.
Min kode ser således ud:
<body>
<br><br><br>
<center>
<h1>Please enter username and password</h1>
<form name="frm" action="Validation.java" method="post">
<input type="text" name="user">
<input type ="password" name="pass">
<input type="submit" value="Check">
</form>
</center>
</body>
______
Min java class:
package jsp;
import java.io.*;
//import java.util.*;
import java.sql.*;
import javax.servlet.http.*;
import javax.servlet.*;
public class Validation extends HttpServlet {
private ServletConfig config;
public void init (ServletConfig config)
throws ServletException{
this.config = config;
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException,IOException {
PrintWriter out = response.getWriter();
String connectionURL = "jdbc:mysql://localhost/dblogin";
Connection connection = null;
ResultSet rs;
String userid = new String("");
String password = new String("");
response.setContentType("text/html");
try {
// Load the database driver
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection(connectionURL, "root", "");
//Add the data into the database
String sql = "SELECT userid, password FROM login";
Statement s = connection.createStatement();
s.executeQuery(sql);
rs = s.getResultSet();
while(rs.next()) {
userid = rs.getString("userid");
password = rs.getString("password");
}
rs.close();
s.close();
} catch(Exception e) {
System.out.println("Exception is: " + e);
}
if(userid.equals(request.getParameter("userid")) && password.equals(request.getParameter("password"))) {
out.println("The user is valid");
}
else {
out.println("You are not valid");
}
}
}
Sådan som jeg forstår det er det min action den er gal med?
<form name="frm" action="Validation.java" method="post">
Jeg har prøvet med nogle forskellige ting, men får samme fejl:
<form name="frm" action="src/jsp/Validation.java" method="post">
<form name="frm" action="/ConnectionLoginForms/Validation.java" method="post">
Er der en som kan se hvor min fejl er?
mvh Mads