how to create a dynamic website

View Answers

November 7, 2008 at 3:13 PM

Hi friend,

<html>
<title>employee form in servlets</title>
<head>

<script type="text/javascript">

function checkEmail(email) {
if (/^\w+([\.-]?\w+)*@\w+([\.-]?\w+)*(\.\w{2,3})+$/.test(email)){
return (true)
}
alert("Invalid email address.Please Enter again.")
return (false);
}

function validateForm(theForm){

if(theForm.empname.value==""){

//Please enter username

alert("Please enter User Name.");

theForm.empname.focus();

return false;

}

if(theForm.lastname.value==""){

//Please enter lastname

alert("Please enter Last Name.");

theForm.lastname.focus();

return false;

}

if(theForm.email.value==""){
alert("Please enter email!");
theForm.email.focus();
return false;
}
if(!checkEmail(theForm.email.value)){
theForm.email.focus();
return false;
}

return true;
}
</script>
</head>

<body>
<center>
<table border="0" width="600px" bgcolor="lightblue" cellpadding="2" cellspacing="4">
<tr>
<td width="100%">
<form method="GET" action="InsertDataAction" onsubmit="return validateForm(this);">

<h2 align="center" align="top">Employee Registration Form</h2>
<table border="0" width="100%">
<tr>
<td width="50%"><b>Employee Name:</b></td>
<td width="50%"><input type="text" name="empname" size="20"/> </td>
</tr>
<tr>
<td width="50%"><b>Middle Name:</b></td>
<td width="50%"><input type="text" name="midname" size="20"/> </td>
</tr>
<tr>
<td width="50%"><b>Last Name:</b></td>
<td width="50%"><input type="text" name="lastname" size="20"/> </td>
</tr>
<tr>
<td width="50%"><b>Address:</b></td>
<td width="50%"><input type="text" name="address" size="50"/> </td>
</tr>

<td width="50%"><b>E-mail:</b></td>
<td width="50%"><input type="text" name="email" size="30"/> </td>
</tr>

</table><center><p>
<input type="submit" value="Submit" name="submit">
<input type="reset" value="Reset" name="reset">
</center>
</form>
</td>
</tr>
</table>
</center>
</body>

</html>

November 7, 2008 at 3:32 PM

This is Action code.

package javacode;

import java.io.*;
import java.sql.*;

import javax.servlet.*;
import javax.servlet.http.*;

public class InsertDataAction extends HttpServlet{
public void doGet(HttpServletRequest request, HttpServletResponse response)throws
ServletException, IOException{
response.setContentType("text/html");
PrintWriter out = response.getWriter();
System.out.println("Insert data Example!");
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String userName = "amar";
String password = "amar123";
Connection con = null;
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,userName,password);
try{
Statement st = con.createStatement();
String empname=request.getParameter("empname");
String midname =request.getParameter("midname");
String lastname =request.getParameter("lastname");
String address=request.getParameter("address");
String email =request.getParameter("email");

int val = st.executeUpdate("insert into empDetail(empname,midname,lastname,address,email) values('"+empname+"','"+midname+"','"+lastname+"','"+address+"','"+email+"')");
con.close();
out.println("success data insert into database");
}
catch (SQLException ex){
System.out.println("SQL statement is not executed!");
}
}
catch (Exception e){
e.printStackTrace();
}

}
}

---------------------

November 7, 2008 at 3:35 PM

web.xml

<?xml version="1.0" encoding="ISO-8859-1"?>

<web-app xmlns="http://java.sun.com/xml/ns/javaee";

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";

xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd";

version="2.5">

<description>

Servlet and JSP Examples.

</description>

<display-name>Servlet and JSP Examples</display-name>

<servlet>
<servlet-name>insertDataAction</servlet-name>
<servlet-class>javacode.InsertDataAction</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>insertDataAction</servlet-name>
<url-pattern>/jsp/InsertDataAction</url-pattern>
</servlet-mapping>

</web-app>

------------------------------

Visit for more information.

http://www.roseindia.net/servlets/

Thanks.

Amardeep

how to create a dynamic website

Questions by Category