signup.jsp

<%--
    Document   : signup
    Created on : Jul 31, 2017, 3:06:36 PM
    Author     : Shahadat-Hossain
--%>

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
	pageEncoding="ISO-8859-1"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>signup</title>
</head>
<body>
<%@ page import ="java.sql.*" %>
<%@ page import ="javax.sql.*" %>
<%
String user=request.getParameter("usrname");
String passcode=request.getParameter("usrpassword");
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/tourguide",
"root","");
Statement st= con.createStatement();
ResultSet rs;
int i=st.executeUpdate("insert into login values('"+user+"','"+passcode+"')");
session.setAttribute("sessionid",user);
out.println("Registered");

%>
</body>
</html>