hi i m tannu
i m creating one web site using jsp and servlet and mysql
i m create one servlet that do insert and update and delete operation
update and delete run perfactly but ia have some problem plz seee this
this is my servlet
smast:::::::::
/*staff_mast*/
import java.io.*;
import java.net.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class smast extends HttpServlet {
ResultSet rs=null;
boolean s;
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
out.println("<html>");
out.println("<head>");
out.println("<title>Servlet smast</title>");
out.println("</head>");
out.println("<body>");
out.println("<form>");
try
{
connect c=new connect();
String delid=request.getParameter("id");
String upid=request.getParameter("uid");
if (delid != null)
{
c.task("delete from staff_add where sid="+delid);
c.task("delete from staff_mast where sid="+delid);
}
String btnsave=request.getParameter("save");
if(btnsave!=null)
{
String txt2=request.getParameter("t2");
String txt3=request.getParameter("t3");
String txt4=request.getParameter("t4");
String txt5=request.getParameter("t5");
String txt6=request.getParameter("t6");
String txt7=request.getParameter("t7");
int txt8=Integer.parseInt(request.getParameter("t8"));
String txt9=request.getParameter("t9");
String txt10=request.getParameter("t10");
String txt11=request.getParameter("t11");
String txt12=request.getParameter("t12");
String txt13=request.getParameter("t13");
String txt14=request.getParameter("t14");
String txt15=request.getParameter("t15");
int txt16=Integer.parseInt(request.getParameter("t16") );
String txt17=request.getParameter("t17");
String sid=request.getParameter("t1");
c.task("update staff_add set add1='"+txt11+"',add2='"+txt12+"',city='"+txt13+"' ,state='"+txt14+"',country='"+txt15+"',zipcode="+t xt16+",mob='"+txt17+"' where sid='"+sid+"'");
c.task("update staff_mast set fname='"+txt2+"',lname='"+txt3+"',gender='"+txt4+" ',dob='"+txt5+"',qualification='"+txt6+"',email_id ='"+txt7+"',payment="+txt8+",specialist='"+txt9+"' ,jdate='"+txt10+"' where sid='"+sid+"'");
}
rs=c.result("select m.*,a.* from staff_mast m,staff_add a where m.sid=a.sid");
out.println("<a href='http://localhost:8084/ntik_code/sw_valid1.jsp'> INSERT</a>");
out.println("<table border=1 align=center>");
if (upid != null)
{
s=true;
}
out.println("<tr>");
out.println("<th>");
out.println("SID");
out.println("</th>");
out.println("<th>");
out.println("FNAME");
out.println("</th>");
out.println("<th>");
out.println("LNAME");
out.println("</th>");
out.println("<th>");
out.println("GENDER");
out.println("</th>");
out.println("<th>");
out.println(" "+"DATE OF BIRTH"+" ");
out.println("</th>");
out.println("<th>");
out.println("QUALIFICATION");
out.println("</th>");
out.println("<th>");
out.println("EMAIL_ID");
out.println("</th>");
out.println("<th>");
out.println("PAYMENT");
out.println("</th>");
out.println("<th>");
out.println("SPECIALIST IN");
out.println("</th>");
out.println("<th>");
out.println("JOINING DATE");
out.println("</th>");
out.println("<th>");
out.println("ADDRESS1");
out.println("</th>");
out.println("<th>");
out.println("ADDRESS2");
out.println("</th>");
out.println("<th>");
out.println("CITY");
out.println("</th>");
out.println("<th>");
out.println("STATE");
out.println("</th>");
out.println("<th>");
out.println("COUNTRY");
out.println("</th>");
out.println("<th>");
out.println("ZIPCODE");
out.println("</th>");
out.println("<th>");
out.println("MOBILE");
out.println("</th>");
out.println("</tr>");
while(rs.next())
{
out.println("<tr>");
String id=rs.getString(1);
out.println("<td>"+id+"</td>");
if(s == true && id.equals(upid))
{
out.println("<input type=hidden name=t1 value="+id+">");
out.println("<td> <input type=text name=t2 value='"+rs.getString(2)+"'></td>");
out.println("<td> <input type=text name=t3 value='"+rs.getString(3)+"'></td>");
out.println("<td> <input type=text name=t4 value='"+rs.getString(4)+"'></td>");
out.println("<td width=100% > <input type=text name=t5 value='"+rs.getDate(5).toString()+"'></td>");
out.println("<td> <input type=text name=t6 value='"+rs.getString(6)+"'></td>");
out.println("<td> <input type=text name=t7 value='"+rs.getString(7)+"'></td>");
out.println("<td> <input type=text name=t8 value="+rs.getInt(8)+"></td>");
out.println("<td> <input type=text name=t9 value='"+rs.getString(9)+"'></td>");
out.println("<td> <input type=text name=t10 value='"+rs.getDate(10).toString()+"'></td>");
out.println("<td> <input type=text name=t11 value='"+rs.getString("add1")+"'></td>");
out.println("<td> <input type=text name=t12 value='"+rs.getString("add2")+"'></td>");
out.println("<td> <input type=text name=t13 value='"+rs.getString("city")+"'></td>");
out.println("<td> <input type=text name=t14 value='"+rs.getString("state")+"'></td>");
out.println("<td> <input type=text name=t15 value='"+rs.getString("country")+"'></td>");
out.println("<td> <input type=text name=t16 value="+rs.getInt("zipcode")+"></td>");
out.println("<td> <input type=text name=t17 value='"+rs.getString("mob")+"'></td>");
out.println("<td> <input type=submit name=save value=SAVE></td>");
out.println("<td> <input type=submit name=can value=CANCEL></td>");
}
else
{
out.println("<td>"+rs.getString(2)+"</td>");
out.println("<td>"+rs.getString(3)+"</td>");
out.println("<td>"+rs.getString(4)+"</td>");
out.println("<td>"+rs.getDate(5).toString()+"</td>");
out.println("<td>"+rs.getString(6)+"</td>");
out.println("<td>"+rs.getString(7)+"</td>");
out.println("<td>"+rs.getInt(8)+"</td>");
out.println("<td>"+rs.getString(9)+"</td>");
out.println("<td>"+rs.getDate(10).toString()+"</td>");
out.println("<td>"+rs.getString("add1")+"</td>");
out.println("<td>"+rs.getString("add2")+"</td>");
out.println("<td>"+rs.getString("city")+"</td>");
out.println("<td>"+rs.getString("state")+"</td>");
out.println("<td>"+rs.getString("country")+"</td>");
out.println("<td>"+rs.getInt("zipcode")+"</td>");
out.println("<td>"+rs.getString("mob")+"</td>");
out.println("<td><a href=http://localhost:8084/ntik_code/smast?id='"+id+"'>DELETE</a></td>");
out.println("<td><a href=http://localhost:8084/ntik_code/smast?uid="+id+">UPDATE</a></td>");
out.println("</tr>");
}
}
out.println("</table>");
rs.close();
}
catch(Exception e)
{
out.println(e);
}
out.println("</form>");
out.println("</body>");
out.println("</html>");
out.close();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
public String getServletInfo() {
return "Short description";
}
}
this is my sint servlet from where i m doing insertion
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class sint extends HttpServlet {
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
public void destroy() {
}
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
response.setContentType("text/html");
java.io.PrintWriter out = response.getWriter();
try
{
connect c=new connect();
out.println("<html>");
out.println("<head>");
out.println("<title>Servlet</title>");
out.println("</head>");
out.println("<body>");
String st1=request.getParameter("sub");
if (st1 != null)
{
out.println("ok");
String s1=request.getParameter("sid1");
String nm1=request.getParameter("fnm");
String nm2=request.getParameter("lnm");
String gen=request.getParameter("g1");
String dt=request.getParameter("db");
String qu=request.getParameter("qua");
String email=request.getParameter("ei");
int pay=Integer.parseInt(request.getParameter("py"));
String sp1=request.getParameter("sp");
String jdt=request.getParameter("jd");
String ar1=request.getParameter("ad1");
String ar2=request.getParameter("ad2");
String ct1=request.getParameter("ct");
String state1=request.getParameter("st");
String cnt=request.getParameter("ctr");
int pin =Integer.parseInt(request.getParameter("zc"));
String m1=request.getParameter("mb");
c.task("insert into staff_mast values('"+s1+"','"+nm1+"','"+nm2+"','"+gen+"','"+d t+"','"+qu+"','"+email+"',"+pay+",'"+sp1+"','"+jdt +"')");
c.task("insert into staff_add values('"+s1+"','"+ar1+"','"+ar2+"','"+ct1+"','"+s tate1+"','"+cnt+"',"+pin+",'"+m1+"')");
}
}
catch(Exception e)
{
out.println(e);
}
out.println("</body>");
out.println("</html>");
out.close();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
processRequest(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
processRequest(request, response);
}
public String getServletInfo() {
return "Short description";
}
}
and this is my jsp file from where i m doing javascript validation
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8" import="java.util.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<script language="JavaScript">
<!--
function validate(form)
{
if(form.fnm.value=="")
{
alert("please fill up the first name");
form.fnm.focus();
}
else if(form.lnm.value=="")
{
alert("please fill up the last name");
form.lnm.focus();
}
else
{
form.submit();
}
}
//end hiding -->
</script>
</head>
<body>
<form action="http://localhost:8084/ntik_code/sint" method="get">
SID:
<input type="text" name="sid1" >
<br>
FNAME:
<input type="text" name="fnm" >
<br>
LNAME:
<input type="text" name="lnm" >
<br>
GENDER:
<input type="text" name="g1" >
<br>
DATE OF BIRTH(Y/M/D)
<input type="text" name="db" >
<br>
QUALIFICATION:
<input type="text" name="qua" >
<br>
EMAILID:
<input type="text" name="ei" >
<br>
PAYMENT:
<input type="text" name="py" >
<br>
SPECIALIST IN:
<input type="text" name="sp" >
<br>
JOINING DATE:(y/m/d)
<input type="text" name="jd" >
<br>
ADDRESS1:
<input type="text" name="ad1">
<br>
ADDRESS2:
<input type="text" name="ad2">
<br>
CITY:
<input type="text" name="ct">
<br>
STATE:
<input type="text" name="st">
<br>
COUNTRY:
<input type="text" name="ctr">
<br>
ZIPCODE:
<input type="text" name="zc">
<br>
MOBILE:
<input type="text" name="mb">
<br>
<input type="button" value="submit" name="sub" onclick="validate(this.form)">
</form>
</body>
</html>
now i want to remove sint servlet and doing whole code in jsp file and i use connect java class from dere i call constructor for connection
this connection run in servlet perfactly but not in jsp
now i want to put validation by javascript only
and if i run this program javascript run perfactly but when i fill up the data and submit it pass to the db but not inserting and it gives no error if u knw any wrong in it plz tell me its urgent for me
jsp and my sql
