· 9 years ago · Apr 15, 2017, 10:20 PM
1<!--
2Luke O Brien
3Games Design lvl 8 Year 2, Semester 2
4Enterprise Application Development
5-->
6
7<!DOCTYPE html>
8<!-- Login -->
9<html>
10<head>
11<title> Login </title>
12<link rel="stylesheet" type="text/css" href="style1.css">
13
14</head>
15
16<body>
17<center>
18<div id="wrapper">
19<div id="header">
20
21<img src="heading.png" width="700" height="75"><!-- Heading -->
22
23<a href="login.html"><img src="resources/navi/Login.png" width="120" height="40" style="float:right"></a>
24<br>
25<!-- Website Navigation -->
26<a href="homePage.html"><img src="resources/navi/home1.png" width="120" height="40"></a>
27<a href="information.html"><img src="resources/navi/information1.png" width="180" height="40"></a>
28<a href="questionnaire.html"><img src="resources/navi/questionnaire1.png" width="200" height="40"></a>
29<a href="donate.html"><img src="resources/navi/donate1.png" width="130" height="40"></a>
30
31</div>
32
33<div id="main"> <!-- start of the main body -->
34 <p>
35 Login if you have an existing account.<br>
36 Otherwise you can create an account by filling out the Registration section<br>
37 </p><br>
38 <!--
39 <form action ="login" method ="POST">
40 USERNAME:<input type="text" name="username">
41 <br><br>
42 PASSWORD:<input type="text" name="password">
43 <br><br>
44 <input type="submit" value="Login"/>
45 </form>
46 <br><br><br>
47 -->
48 <form action ="register" method ="POST">
49 USERNAME:<input type="text" name="username">
50 <br><br>
51 PASSWORD:<input type="text" name="password">
52 <br><br>
53 FIRST NAME:<input type="text" name="firstName">
54 <br><br>
55 LAST NAME:<input type="text" name="lastName">
56 <br><br>
57 EMAIL ADDRESS:<input type="text" name="email">
58 <br><br>
59 <input type="submit" value="Register"/>
60 </form>
61 <br><br><br>
62</div>
63
64<div id="footer"> <!-- start of the footer -->
65<p>This site was created by Luke O Brien. I can be contacted at <a href="mailto:lukeob19@gmail.com"> this email address.</a></p>
66<a href="homePage.html">Back to HomePage</a>
67</div>
68</center>
69
70</body>
71</html>
72
73//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
74
75/*
76 * To change this license header, choose License Headers in Project Properties.
77 * To change this template file, choose Tools | Templates
78 * and open the template in the editor.
79 */
80
81import java.io.IOException;
82import java.io.PrintWriter;
83import java.sql.DriverManager;
84import javax.servlet.ServletException;
85import javax.servlet.annotation.WebServlet;
86import javax.servlet.http.HttpServlet;
87import javax.servlet.http.HttpServletRequest;
88import javax.servlet.http.HttpServletResponse;
89import com.mysql.jdbc.*;
90import javax.servlet.ServletException;
91/**
92 *
93 * @author test
94 */
95@WebServlet(urlPatterns = {"/register"})
96public class register extends HttpServlet
97{
98
99 String username;
100 String password;
101 String firstName;
102 String lastName;
103 String email;
104
105 Connection conn;
106 PreparedStatement prepStat;
107 Statement stat;
108
109
110 public void init() throws ServletException
111 {
112 String URL = "jdbc:mysql://localhost:3306/";
113 String DB = "lukeDB";
114 String USERNAME = "root";
115 String PASSWORD ="password";
116
117 try
118 {
119 Class.forName("com.mysql.jdbc.Driver");
120 conn = (Connection)DriverManager.getConnection(URL+DB,USERNAME,PASSWORD);
121 stat = (Statement)conn.createStatement();
122
123 System.out.println("INIT TEST");
124
125 stat.execute("CREATE TABLE IF NOT EXISTS users(userID INTEGER NOT NULL AUTO_INCREMENT, "
126 + "username VARCHAR(40), "
127 + "password VARCHAR(40), "
128 + "firstName VARCHAR(40), "
129 + "lastName VARCHAR(40), "
130 + "email VARCHAR(50), "
131 + "CONSTRAINT pk_users PRIMARY KEY (userID))"); // making a primary key
132 System.out.println("INIT TEST1");
133
134 }
135 catch(Exception e)
136 {
137 System.out.println(e);
138 }
139 }
140 protected void processRequest(HttpServletRequest request, HttpServletResponse response)
141 throws ServletException, IOException
142 {
143 username = request.getParameter("username");
144 password = request.getParameter("password");
145 firstName = request.getParameter("firstName");
146 lastName = request.getParameter("lastName");
147 email = request.getParameter("email");
148
149 try
150 {
151 System.out.println("QUERY TEST");
152
153 String query = "INSERT INTO users VALUES (DEFAULT,?,?,?,?,?)";
154 prepStat = (PreparedStatement)conn.prepareStatement(query);
155 prepStat.setString(1, username);
156 prepStat.setString(2, password);
157 prepStat.setString(3, firstName);
158 prepStat.setString(4, lastName);
159 prepStat.setString(5, email);
160 prepStat.executeUpdate();
161
162 }
163 catch(Exception e)
164 {
165 System.out.println(e);
166 }
167 }
168
169 // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
170 /**
171 * Handles the HTTP <code>GET</code> method.
172 *
173 * @param request servlet request
174 * @param response servlet response
175 * @throws ServletException if a servlet-specific error occurs
176 * @throws IOException if an I/O error occurs
177 */
178 @Override
179 protected void doGet(HttpServletRequest request, HttpServletResponse response)
180 throws ServletException, IOException {
181 processRequest(request, response);
182 }
183
184 /**
185 * Handles the HTTP <code>POST</code> method.
186 *
187 * @param request servlet request
188 * @param response servlet response
189 * @throws ServletException if a servlet-specific error occurs
190 * @throws IOException if an I/O error occurs
191 */
192 @Override
193 protected void doPost(HttpServletRequest request, HttpServletResponse response)
194 throws ServletException, IOException {
195 processRequest(request, response);
196 }
197
198 /**
199 * Returns a short description of the servlet.
200 *
201 * @return a String containing servlet description
202 */
203 @Override
204 public String getServletInfo() {
205 return "Short description";
206 }// </editor-fold>
207
208}