<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<%@ page import = "java.sql.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.lang.*" %>
<%@ page import="de.tum.sep.*" %>
<%@ page contentType="text/html; charset=UTF-8" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title> RFID Projekt</title>
</head>
<body bgcolor="#DDDDDD">
<%
String anmelden = (String)request.getParameter("anmelden");
if (anmelden == null)
{
%>
<h1>RFID Projekt: Anmeldung</h1><p>Bitte geben Sie Ihre Benutzerkennung und Ihr Passwort ein.</p>
<form action="indexRFID.jsp" method="post">
<table width="600" border="0">
<tr>
<td width="124"> Kennung: </td>
<td width="147">
<input type="text" name="kennung" value=""/>
</td>
<td width="312"> </td>
</tr>
</table>
<table width="600" border="0">
<tr>
<td width="124"> Passwort: </td>
<td width="147">
<input type="text" name="passwort" value=""/>
</td>
<td width="312"> </td>
</tr>
</table>
<%
}
else
{
String kennung = (String)request.getParameter("kennung");
String passwort = (String)request.getParameter("passwort");
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con =
DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost;1433;databaseName=RFID;","boxer",
"boxer");
Statement st = con.createStatement();
ResultSet oResultSet = st.executeQuery("SELECT kennung, passwort FROM Benutzer ");
// ResultSet oResultSet = st.executeQuery("SELECT AnbieterName FROM Anbieter ");
String result1 = "";
String result2 = "";
out.println("Ablauf 1;");
int i = 0;
while(oResultSet.next())
{
i= i++;
result1 = oResultSet.getString("kennung");
out.println("result1 =" +result1);
result2 = oResultSet.getString("passwort");
out.println("result2 =" +result2);
out.println("kennung =" +kennung);
// out.println("passwort =" +passwort);
}
%>
<!-- <td>Kennung :<%//= kennung%></td>-->
<%
st.close();
con.close();
}
catch(SQLException sql)
{
System.out.println("SQL-Fehler: " + sql);
}
%>
<h2> Willkommen zur Projekt RFID </h2>
<table width= "700" border="0">
<tr>
<td><font
color="#0000FF"> Wenn Sie eine neue Transponder in Datenbank
speicher, bitte hier
<A
href="indexTransponder.jsp">clicken</A></font></td>
</tr>
</table>
<table width= "700" border="0">
<tr>
<td><font
color="#0000FF"> Wenn Sie eine neue SchreibLeseGeraete in Datenbank
speicher, bitte hier
<A
href="indexSLG.jsp">clicken</A></font></td>
</tr>
</table>
<table width="600" border="0">
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
<table width="600" border="0">
<tr>
Wenn Sie
</tr>
</table>
<table>
<tr>
<td>Suche nach <input type="text" size="20" name="query">in
<select name="search" size="0">
<option value=1>Transponder</option>
<option value=2>SLG</option>
<option value=3>Antenne</option>
<option value=4>Anbieter</option>
<option value=5>Personen</option>
</select>
<input type="submit" name="suche" value="Suchen"></td>
</tr>
</table>
<%
}
%>
<input type="submit" name="anmelden" value="Anmelden">
<input type="submit" name="registern" value="Registern">
</form>
</body>
</html>