
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %>




<html>
<head>


<title>
Create user for ${param.username}
</title>
</head>
<body bgcolor="white"  text="#400040" link="blue" alink="black" vlink="red">


<h2>User created for = ${param.username}</h2>




<sql:setDataSource 
 driver="com.mysql.jdbc.Driver"
 url="${initParam.DBconn_string}"
 user="${initParam.DBusername}"
 password="${initParam.DBpassword}" />
 
 


     
 <!-- Get the Calendar string from mysql -->
<sql:update >
  
  insert into calendar (username, password, email, sched, verified) values
    ('${param.username}', '${param.password}', '${param.email}', 'M:0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0|T:0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0|W:0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0|T:0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0|F:0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0|', 'verfied');
 </sql:update>


<a href="../changeSched.html">Enter or change</a> your schedule<br>
<a href="../index.html">Main menu</a>

</body>
</html>







