-
Notifications
You must be signed in to change notification settings - Fork 0
/
Registration.jsp
72 lines (64 loc) · 2.63 KB
/
Registration.jsp
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@ page import="java.sql.*" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Registration Form</title>
</head>
<body><%
Connection conn = null;
try{
//"jdbc:mysql://68.178.143.9:3306/thoughtspot"
conn = DriverManager.getConnection("jdbc:mysql://p3nlmysqladm002.secureserver.net/grid55/15/index.php:3306/toughtspot","thoughtspot","Nerdsquad14!");
if(conn != null){
System.out.println("connected");
}
//String query = ("SELECT program, school FROM Programs p INNER JOIN Schools s WHERE p.program=s.program;");
//PreparedStatement ps = null;
}catch(SQLException e){
e.printStackTrace();
}finally{
}
%>
<form method="post" action="controler">
<table id="table">
<tr id="tableRow"><td id="tableData">User Name:</td>
<td> <input required type="text" name="userName"><br><br></td></tr>
<tr id="tableRow"><td id="tableData">First Name:</td>
<td id="tableData"><input required type="text" name="firstName"><br><br></td></tr>
<tr id="tableRow"><td id="tableData">Last Name:</td>
<td id="tableData"> <input required type="text" name="lastName"><br><br></td></tr>
<tr id="tableRow"><td id="tableData">email:</td>
<td id="tableData"> <input required type="email" name="email"><br><br></td></tr>
<tr id="tableRow"><td id="tableData">School: </td>
<td id="tableData"><select name="optionsSchool">
<option value="">schoolName
<option value="schoolName">schoolName
<option value="schoolName">schoolName
</select><br><br></td></tr>
<tr id="tableRow"><td id="tableData">Program:</td>
<td id="tableData"> <select name="optionsProgram">
<option value="program">program
<option value="program">program
<option value="program">program
</select><br><br></td></tr>
<tr id="tableRow"><td id="tableData">Phone Number:</td>
<td id="tableData"> <input required type="number" name="phoneNumber"><br><br></td></tr>
<tr id="tableRow"><td>Street Address:</td>
<td id="tableData"><input required type="text" name="streetAddress"><br><br></td></tr>
<tr id="tableRow"><td id="tableData">Province: </td>
<td id="tableData"><select name="optionsProvince">
<option value="Province">Province
<option value="Province">Province
<option value="Province">Province
</select> <br><br></td></tr>
<tr id="tableRow"><td>Postal Code: </td>
<td id="tableData"><input required type="text" name="postalCode"><br><br></td></tr>
<tr><td colspan="2"><input type="submit" name="submit" value="Register">
</table>
</form>
</body>
</html>