<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>
<%
String user,password;
String pw=request.getParameter("pass");
try {
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/partner", "", "");
Statement stmt = conn.createStatement();
String sql="select * from user where username like '"+benutzerName+"'";
ResultSet res=stmt.executeQuery(sql);
res.first();
user=res.getString(1);
if(benutzerName.equals(user)) {
password=res.getString(2);
if(pw.equals(password)) {
out.println("
Hallo " +benutzerName + "! Login erfogreich</p>");
}
else {
out.println("Falsches Passwort
");
out.println("[url='login.html']Nochmal[/url]");
}
}
else {
out.println("Falscher Benutzername
");
out.println("[url='login.html']Nochmal[/url]");
}
}
catch(ClassNotFoundException err) {
out.println("DB-Treiber nicht gefunden");
out.println(err);
}
catch(SQLException err) {
out.println("Connect nicht möglich");
out.println(err);
}
%>