QuestionAsk Questions?
sumit kumar jain pithani
how to get popup fro servelt to jsp by using ajax.
I went popup in jsp page when my form submit successfully. through servlet can any buddy give r explian how to write the code
Sumit kumar jain pithani
View Answers
July 30, 2012 at 4:23 PM
this simple dude it is like popup after submiting the form the value of field will sub,mit r insert into data base server the is simple code for it
1.jsp page
2.java script page
3.servlet page
here is jsp page :Salu2.jsp file
----------------------------------------------------------------------------------------------------------------------------
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="Controller.ConnectionString"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<link rel="stylesheet" type="text/css" href="Main.css">
<script language="javascript" type="text/javascript" src="saluValidate.js"></script>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<div id="coltwo1">
<div id="salu" >
<div id="tittle"> SALUTATION </div>
<div id="saluin">
<form name="Salutation" method="post" action="Salutation">
<fieldset style="width:350px;height: 100px; ">
<div id="smart" style="margin-top: 10px;" >
<label style="font-size: medium;" title="Fulltitle">Full Name </label>
<input type="text" name="Fulltitle" id="title1" style="width: 180px" title="select Fulltitle ">
</div>
<div id="smart" style="padding-top: 5px;">
<label style="font-size: medium;" title="Shorttitle">Short Name </label>
<input type="text" name="Shorttitle" id="title2" title="select Shorttitle ">
</div>
<input type="hidden" name="id" id="title3" value="xx">
</fieldset>
<div style=" clear: both;">
<input type="submit" name ="s1" value="SUBMIT" onclick="return validateSalu(this.value);" class="button" title="SUBMIT">
<input type="reset" name ="s2" value="RESET" class="button" title="RESET">
<input type="button" name ="s3" value="UPDATE" class="button" onclick="return validateSalu(this.value);" title="UPDATE">
<input type="button" name ="s4" value="DELETE" class="button" onclick="return validateSalu(this.value);" title="DELETE">
</div>
</form>
</div>
<div id="salu1" >
<select name="drop1" size="6" multiple="multiple" style="width: 150px;" id="listB1" onclick="return func(this.value);" title="drop1">
<optgroup label=" SALUTAION"></optgroup>
<%
ConnectionString cs=new ConnectionString();
cs.getConn();
PreparedStatement p=cs.conn.prepareStatement("select * from Salutation ");
ResultSet rs=p.executeQuery();
while(rs.next())
{
String sid=rs.getString(1);
String stitle=rs.getString(2);
%>
<option value="<%=sid%>">
<% out.println(sid +" "+stitle); %>
</option>
<%}
rs.close();
p.close();
%>
</select>
</div>
</div>
</div>
</body>
</html>
------------------------------------------------------------------------------------------------------------------------
this my java script and ajax file same..:saluValidate.js
----------------------------------------------------------
function validateSalu(butt){
var fn=document.Salutation.Fulltitle.value;
var sn=document.Salutation.Shorttitle.value;
var salu_id=document.Salutation.id.value;
var i=0;
var j=0;
alert("sumit "+(++j));
if(fn=="")
{
alert("Please Enter Full Name");
fn="";
document.Salutation.Fulltitle.focus();
return false;
}else if(!fn.match(/^[a-zA-Z]+$/)){
alert("Please Enter Correct Full Name");
fn="";
document.Salutation.Fulltitle.focus();
return false;
}
if(sn=="")
{
alert("Please Enter Short Name");
sn="";
document.Salutation.Shorttitle.focus();
return false;
}else if(!sn.match(/^[a-zA-Z]+$/)){
alert("Please Enter Correct Short Name");
sn="";
document.Salutation.Shorttitle.focus();
return false;
}
var B=true;
if((/SUBMIT/g).test(butt)){
B=confirm("DO YOU WANT SUBMIT --- SALUTATION !!! PRESS OK ELSE CANCEL");
i=1;
//alert(""+butt+""+i);
}else if((/UPDATE/g).test(butt)){
B=confirm("DO YOU WANT UPDATE --- SALUTATION !!! PRESS OK ELSE CANCEL");
i=2;
//alert(""+butt+""+i);
}else if((/DELETE/g).test(butt)){
B=confirm("DO YOU WANT DELETE --- SALUTATION !!! PRESS OK ELSE CANCEL");
i=3;
//alert(""+butt+""+i);
}
if(B==true){
AjexFun(fn,sn,i,salu_id);
return true;
}else{
return false;
}
}
var xmlhttp;
function AjexFun(f,s,b,i){
alert("sumit1");
url="Salutation?full="+f+"&short="+s+"&button1="+b+"&id="+i;
if(window.XMLHttpRequest){
xmlhttp=new XMLHttpRequest();
}
else{
xmlhttp=new ActiveXobjective("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=fun;
alert("sumit2");
xmlhttp.open("post",url, true);
alert("sumit3");
xmlhttp.send();
}
function fun(){
if(xmlhttp.readyState==4){
var x=xmlhttp.responseText;
alert(x);
document.getElementById("salu1").innerHTML=x;
document.getElementById("title3").value="";
document.getElementById("title1").value="";
document.getElementById("title2").value="";
return false;
}
}
function func(id){
//alert("sumit1");
url="Salutation?id1="+id;
if(window.XMLHttpRequest){
xmlhttp=new XMLHttpRequest();
}else{
xmlhttp=new ActiveXobjective("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=fun1;
//alert("sumit2");
xmlhttp.open("get",url, true);
//alert("sumit3");
xmlhttp.send();
}
function fun1(){
if(xmlhttp.readyState==4){
var x=xmlhttp.responseText;
alert("sumit1"+x);
var y=x.split(":");
document.getElementById("title3").value=y[0];
document.getElementById("title1").value=y[1];
document.getElementById("title2").value=y[2];
return true;
}
}
------------------------------------------------------------
------------------------------------------------------------
this my java servlet page ............:Salutation.java
---------------------------------------------------------
package Controller;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* Servlet implementation class Salutation
*/
@WebServlet("/Salutation")
public class Salutation extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public Salutation() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
//PrintWriter out=response.getWriter();
System.out.println("get1");
ConnectionString cs=new ConnectionString();
cs.getConn();
String salid=" ";
String result="";
salid=(request.getParameter("id1")).toUpperCase();
try{
PreparedStatement p=cs.conn.prepareStatement("select * from Salutation where salu_id ='"+salid+"'" );
ResultSet rs=p.executeQuery();
System.out.println("get3");
while(rs.next())
{
result+=rs.getString("salu_id");
result+=":"+rs.getString("salu_name");
result+=":"+rs.getString("salu_title");
}
response.getWriter().print(result);
}catch(Exception e){
System.out.print(e.getMessage());
}
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
try{
PrintWriter out=response.getWriter();
System.out.println("servlet1");
ConnectionString cs=new ConnectionString();
cs.getConn();
String fullname=" ";
String shortname=" ";
String sid=" ";
int count=0;
System.out.println("servlet2");
fullname=(request.getParameter("full")).toUpperCase();
shortname=(request.getParameter("short")).toUpperCase();
sid=(request.getParameter("id")).toUpperCase();
String button=request.getParameter("button1");
System.out.println(button);
Integer i= Integer.valueOf(button);
System.out.println(i+""+sid);
switch(i){
case 1:
try{
PreparedStatement p=cs.conn.prepareStatement("select * from Salutation where salu_name ='"+fullname+"'"+"and salu_title='"+shortname+"'" );
ResultSet rs=p.executeQuery();
System.out.println("servlet3");
while(rs.next())
{
count++;
}
if(count>=1)
{
System.out.println("servlet4");
out.println("already exist !!!");
}
else
{
System.out.println("servlet5");
String url="{call salut (?,?)}";
CallableStatement p1=cs.conn.prepareCall(url);
p1.setString(1, fullname);
p1.setString(2, shortname);
p1.executeUpdate();
out.println("Submit successfull !!!");
}
}catch(Exception e){
System.out.print(e.getMessage());
}
break;
case 2:
try{
String url="{call update_salut (?,?,?)}";
CallableStatement p1=cs.conn.prepareCall(url);
p1.setString(1,sid);
p1.setString(2,fullname);
p1.setString(3,shortname);
p1.executeUpdate();
PreparedStatement p2=cs.conn.prepareStatement("select * from Salutation where status<>"+2);
p2.executeQuery();
response.getWriter().print("Update successfull !!!");
}catch(Exception e){
System.out.print(e.getMessage());
}
break;
case 3:
try{
System.out.print("jain Delete 1"+sid);
String url="{call del_salu1 (?)}";
System.out.print("jain Delete 1");
CallableStatement p1=cs.conn.prepareCall(url);
p1.setString(1,sid);
p1.executeUpdate();
PreparedStatement p2=cs.conn.prepareStatement("select * from Salutation where status<>"+2);
p2.executeQuery();
response.getWriter().print("Delete successfull !!!");
}catch(Exception e){
System.out.print(e.getMessage());
}
break;
}
}catch(Exception e){
response.sendRedirect("Salu2.jsp");
System.out.println(e.getMessage());
}
}
}
------------------------------------------------------------------------------------------------------------------------
connection between the database and servelet using java script:ConnectionString.java
-----------------------------------------------
package Controller;
import java.sql.*;
public class ConnectionString {
public Connection conn=null;
public void getConn()
{
try
{
String url="jdbc:sqlserver://"*******ip--address***********";databaseName=komal";
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn=DriverManager.getConnection(url, "username", "password");
}
catch(Exception e)
{
e.getMessage();
}
}
}
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
