J2ee database Application
HTML Page
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<center>
<h1>DB App</h1>
<table border="0">
<form action="Signup" method="post">
<thead>
<tr>
<th colspan="2">Signup</th>
<th></th>
</tr>
</thead>
<tbody>
<tr>
<td>Username:</td>
<td><input type="text" name="name"></td>
</tr>
<tr>
<td>Password:</td>
<td><input type="password" name="pass"></td>
</tr>
<tr>
<td>Address:</td>
<td><textarea name="add"></textarea></td>
</tr>
<tr>
<td>District:</td>
<td>
<select name="dist">
<option>Select</option>
<option>TVM</option>
<option>KLM</option>
<option>APZHA</option>
<option>KTM</option>
<option>EKM</option>
</select>
</td>
</tr>
<tr>
<td>Mail</td>
<td><input type="email" name="mail"></td>
</tr>
<tr>
<td><input type="submit"></td>
<td><input type="reset"></td>
</tr>
</tbody>
</table>
</form>
</center>
</body>
</html>
Insert Into DB
try {
String User=request.getParameter("name");
String Pass=request.getParameter("pass");
String Address=request.getParameter("add");
String Dist=request.getParameter("dist");
String Email=request.getParameter("mail");
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/login","root","");
PreparedStatement PSMT=con.prepareStatement("INSERT INTO `login`.`userdetails` (`Mail` ,`User` ,`pass` ,`Dist` ,`Address`)VALUES (?,?,?,?,?)");
PSMT.setString(1, Email);
PSMT.setString(2, User);
PSMT.setString(3, Pass);
PSMT.setString(4, Dist);
PSMT.setString(5, Address);
int i=PSMT.executeUpdate();
if(i>0){out.print("<script>alert('Success');</script>");}
}
catch(Exception ex)
{out.print(ex.getMessage());}
} finally {
out.close();
}
