<html>
<body>
<%@ page import="java.sql.*" %>
<%
Connection con=null;
Statement st=null;
ResultSet rs= null;
try{
Class.forName("org.gjt.mm.mysql.Driver").newInstan ce();
}
catch(Exception e)
{
out.println("Unable to load driver"+e.getMessage());
}
try
{
String MYSQL_HOST = "richese.csci.unt.edu";
String MYSQL_DB = "rp0110";
String MYSQL_USER = "rp0110";
String MYSQL_PASSWD = "rp0110";
String MYSQL_TABLE = "client";
con = DriverManager.getConnection(
"jdbc:mysql://" + MYSQL_HOST + "/" + MYSQL_DB +
"?user=" + MYSQL_USER + "&password=" + MYSQL_PASSWD);
}//end try
catch(Exception e){
out.println("error connecting to DataBase "+e);
}//end catch
try{
String username = request.getParameter("username");
String password = request.getParameter("password");
String technology = request.getParameter("technology");
String experience = request.getParameter("experience");
String qualification = request.getParameter("qualification");
String skills = request.getParameter("skills");
String adress = request.getParameter("address");
String email = request.getParameter("email");
st = con.createStatement();
String selqry = "select nvl(max(jobseekerid),0) from job_seekers";
rs = st.executeQuery(selqry);
int maxvalue=0;
if(rs.next())
maxvalue = Integer.parseInt(rs.getString(1))+1;
String insqry = "insert into jobseekers values("+maxvalue+
",'"+username+"','"+password+"','"+technology+
"',"+experience+",'"+qualification+"','"+skill s+
"','"+adress+"','"+email+"')";
int rowsaffected = st.executeUpdate(insqry);
if(rowsaffected > 0)
{
con.commit();
out.println("Thanks for registering<br> with us <br>");
}
st.close();
con.close();
}
catch(Exception e)
{
String message = e.getMessage();
}
finally
{
st.close();
con.close();
}
%>
</body>
</html>