sample.jsp
- Κώδικας: Επιλογή όλων
<!DOCTYPE html>
<!--<%@include file="./assets/lib/header.jsp"%>-->
<html>
<head>
<title>login sample</title>
</head>
<body>
<h1>LOGIN</h1>
<form method="post" action="elegxoslogin.jsp">
<label>Username</label><br>
<input type="text" name="username"><br>
<label>Password</label><br>
<input type="password" name="password"><br>
<input type="submit" value="Είσοδος"><br>
</form>
</body>
</html>
<!--<%@include file="./assets/lib/footer.jsp"%>-->
και το elegxoslogin.jsp
- Κώδικας: Επιλογή όλων
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<%@page import="com.mysql.jdbc.Driver.*"%>
<%@page import="java.util.Properties"%>
<%
String username = request.getParameter("username");
String password = request.getParameter("password");
//String from= session.getAtribute("last");
String data = "jdbc:mysql://localhost:3306/bio";
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection(data, "root", "root");
Statement st = conn.createStatement();
ResultSet rec = st.executeQuery("SELECT username FROM users WHERE username='" + username + "' AND password=MD5('" + password + "')");
boolean ok = false;
while(rec.next())
{
username = rec.getString("username");
ok=true;
}
if(!ok)
{
out.println("Δώσατε λάθος συνθηματικό ή password");
response.sendRedirect("sample.jsp");
}
else
{
%>
<h1>Επιλογή Διαδρομής</h1>
<p>Έχετε να επιλέξεται μεταξύ των:
<table>
<tr>
<td>
<a href="./admin">Σελίδα Διαχείρησης</a>
</td>
<td><!--<a href="<%%>">-->Σημείο πριν από την είσοδό σας<!--</a>--></td>
<tr>
</table>
</p>
<%
}
session.setAttribute("username", username );
session.setAttribute("loged_in", true);
session.setAttribute("from","./elegxoslogin.jsp");
conn.close();
%>
[code]
Ακόμη στον φάκελο WEB-INF/lib [b]αντέγραψα[/b] το αρχείο mysql-connector-java-5.1.16.jar (Υπεύθυνο για java - mysql connection) από το /usr/share/java/mysql-connector-java-5.1.16.jar
Και το μόνο που παίρνω είναι:
[code]
HTTP Status 500 -
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: An exception occurred processing JSP page /project/elegxoslogin.jsp at line 13
10: //String from= session.getAtribute("last");
11: String data = "jdbc:mysql://localhost:3306/bio";
12:
13: Class.forName("com.mysql.jdbc.Driver");
14: Connection conn = DriverManager.getConnection(data, "root", "root");
15: Statement st = conn.createStatement();
16: ResultSet rec = st.executeQuery("SELECT username FROM users WHERE username='" + username + "' AND password=MD5('" + password + "')");
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:568)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:455)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
root cause
javax.servlet.ServletException: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:911)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:840)
org.apache.jsp.project.elegxoslogin_jsp._jspService(elegxoslogin_jsp.java:127)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
root cause
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1701)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1546)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:126)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:63)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Class.java:186)
org.apache.jsp.project.elegxoslogin_jsp._jspService(elegxoslogin_jsp.java:77)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.26 logs.
Τι στο καλό έκανα λάθος γιατί δεν τρέχει?
