protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
DBConnect con = new DBConnect();
String nickname = null;
String name = null;
String NName = null;
String strasse = null;
String plz = null;
String ort = null;
String nation = null;
String email = null;
String urlName = null;
String urlAdresse = null;
RegistrationInfo info = new RegistrationInfo();
BeanUtilities.populateBean(info,request);
String benutzerID = null;
/**Neuer Benutzer wird angelegt.*/
con.dbExecute("INSERT INTO `benutzer` ( `BenutzerID` , `Nickname` , `Name` , `Nachname` , `Passwort` , `email` , `Strasse` , `PLZ` , `Ort` , `Nation` )"+
"VALUES ("+
"'', '"+ info.getNickname() +"', '"+ info.getName() +"', '"+ info.getNachname() +"', '"+ info.getPasswort() +"', '"+ info.getEmail() + "'," +
"'"+ info.getStrasse()+ "', '"+ info.getPlz() +"', '"+ info.getOrt() +"', '"+ info.getNation() + "'" +
");");
//Es wird eine SQL Abrage gesendet, welche BenutzerID der Neue Benutzer hat.
ResultSet rsID = con.dbQuery("SELECT `BenutzerID` , `Nickname` " +
"FROM `benutzer` "+
"WHERE `Nickname` LIKE CONVERT( _utf8 '"+ info.getNickname() +"'"+
"USING latin1 )" +
"COLLATE latin1_general_ci");
//BenutzerID wird ausgelesen
try {
while(rsID.next() == true){
benutzerID = rsID.getString("BenutzerID");
nickname = rsID.getString("Nickname");
System.out.println(benutzerID);
con.dbExecute("INSERT INTO `url` ( `URLID` , `URLName` , `URLAdresse` , `BenutzerID` , `UserID` )" +
"VALUES (" +
"'', '" + info.getUrlName() + "', '" + info.getUrl() + "', '" + benutzerID + "', '0'" +
")");
}
}catch (SQLException SQLex){
System.out.println("Fehler beim Auslesen der BuntzerID! " + SQLex.toString());
}
PrintWriter out = response.getWriter();
try{
//BenutzerID Nickname Name Nachname Passwort email Strasse PLZ Ort Nation
benutzerID = rsID.getString("BenutzerID");
rsID.close();
System.out.println(benutzerID);
String queryString = "SELECT * FROM `benutzer` WHERE `BenutzerID` =" + benutzerID +" LIMIT 0 , 1";
ResultSet rsBenutzer = con.dbQuery(queryString);
while(rsBenutzer.next()){
nickname = rsBenutzer.getString("Nickname");
name = rsBenutzer.getString("Name");
NName = rsBenutzer.getString("Nachname");
email = rsBenutzer.getString("email");
strasse = rsBenutzer.getString("Strasse");
ort = rsBenutzer.getString("Ort");
plz = rsBenutzer.getString("PLZ");
nation = rsBenutzer.getString("Nation");
}
rsBenutzer.close();
//URLID URLName URLAdresse BenutzerID UserID
queryString = "SELECT * FROM `url` WHERE `BenutzerID` =" + benutzerID +" LIMIT 0 , 1";
ResultSet rsURL = con.dbQuery(queryString);
while(rsURL.next()){
urlName = rsURL.getString("URLName");
urlAdresse = rsURL.getString("URLAdresse");
}
rsURL.close();
} catch (SQLException ex){
System.out.println("Fehler beim auslesen aus der Datenbank. " + ex.toString());
System.out.println("MESSAGE: " + ex.getMessage());
}
finally{
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\"\n" +
"\"http://www.w3.org/TR/html4/loose.dtd\">\n" +
"<html> \n" +
"<head> \n" +
"<title>Webtracer</title> \n"+
"<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\">\n" +
"<style type=\"text/css\">\n" +
"<!--\n" +
"body {\n" +
"background-color: #FFCC33;\n" +
"}\n" +
"-->\n" +
"</style></head>\n" +
"<body> \n"+
"<table width=\"715\" height=\"515\" border=\"0\"> \n"+
" <tr> \n"+
" <td width=\"705\" valign=\"top\" bgcolor=\"#FFFF66\"><div align=\"left\"> \n"+
" <h1>Herzlich Willkommen " + name + " " + NName + "!</h1> \n"+
" <h3>&</h3> \n"+
" <h3>Ihre pers&nlichen Daten: </h3> \n"+
" <div align=\"center\"> \n"+
" <table width=\"395\" height=\"163\" border=\"0\"> \n"+
" <tr> \n"+
" <td width=\"117\">
BenutzerID:</p> </td> \n"+
" <td width=\"268\">" + benutzerID + "</td> \n"+
" </tr> \n"+
" <tr> \n"+
" <tr> \n"+
" <td>Nickname:</td> \n"+
" <td>"+ nickname +"</td> \n"+
" </tr> \n"+
" <td>Name:</td> \n"+
" <td>"+ name +"</td> \n"+
" </tr> \n"+
" <tr> \n"+
" <td>Nachname:</td> \n"+
" <td>"+ NName +"</td> \n"+
" </tr> \n"+
" <tr> \n"+
" <td>Strasse:</td> \n"+
" <td>"+ strasse +"</td> \n"+
" </tr> \n"+
" <tr> \n"+
" <td height=\"21\">PLZ:</td> \n"+
" <td>"+ plz +"</td> \n"+
" </tr> \n"+
" <tr> \n"+
" <td height=\"21\">Ort:</td> \n"+
" <td>"+ ort +"</td> \n"+
" </tr> \n"+
" <tr> \n"+
" <td height=\"21\">Nation:</td> \n"+
" <td>"+ nation +"</td> \n"+
" </tr> \n"+
" <tr> \n"+
" <td height=\"21\">e-mail:</td> \n"+
" <td>"+ email +"</td> \n"+
" </tr> \n"+
" </table> \n"+
" <h3 align=\"left\">&</h3> \n"+
" <h3 align=\"left\">Ihre zu &berwachende URL:</h3> \n"+
" <table width=\"387\" border=\"0\"> \n"+
" <tr> \n"+
" <td width=\"108\">URL Name:</td> \n"+
" <td width=\"263\">"+ urlName +"</td> \n"+
" </tr> \n"+
" <tr> \n"+
" <td>URL Adresse:</td> \n"+
" <td>"+ urlAdresse +"</td> \n"+
" </tr> \n"+
" </table> \n"+
" <p align=\"left\">&</p> \n"+
" <p align=\"left\">Sie k&nnen Ihre Daten jederzeit unter &Mein Konto& &ndern. </p> \n"+
" </div> \n"+
" </div></td> \n"+
" </tr> \n"+
"</table> \n"+
"</body> \n"+
"</html> \n");
con.dbClose();
} //try-catch
} //funktion
