<%
String msg = request.getParameter("msg");
if ("valid".equals(msg)) {
%>
New Employee Successfully Registered !
<% } %>
<%
if ("invalid".equals(msg)) {
%>
Something Went Wrong! Please Try Again !
<% }%>
<%
if ("invalidEmail".equals(msg)) {
%>
Invalid Email ID! Please Try Again !
<% }%>
<%
if ("invalidPassword".equals(msg)) {
%>
Invalid Password! Please Try Again!
<% }%>
<%
int id =1;
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/CLINIHR", "root", "Clinica123");
Statement ps = con.createStatement();
ResultSet rs = ps.executeQuery("SELECT max(id) from users");
while(rs.next()){
id=rs.getInt(1);
id=id+1;
}
}
catch(Exception e){
out.println(e);
}
%>