Forum:

How to perform operations like insert,delete,add,move next etc in jsp page?

Bhardwaj Shweta

Ranch Hand

Posts: 36

I like...

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

hello,

After retrieving the data into jsp page with the help of servlets,how can i perform operations like
add,delete,move next ,previous etc..

control flow:
i have two jsp pages and one servlet.....
in first jsp page,i have a hyperlink to servlet.In servlet i established the connection and now another jsp page comes into picture,which is showing all the data.
now i have multiple buttons in that jsp page for inserting new records ,deleting existing ones and buttons for traversing forward and backward .. now m not getting how to do coding for these buttons and control flow.

//code for jsp page

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@page import="java.sql.*" %>
<%@ page import = "java.util.*" %>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Project Information</title>
<script language="JavaScript">

function clear()
{
	 document.projectform.pname.value="";
	 document.projectform.remarks.value="";
	 document.projectform.contact.value="";
	 document.projectform.sponsor.value="";
	 document.projectform.owner.value="";
	 document.projectform.pname.disabled= false;
	 document.projectform.remarks.disabled = false;
	 document.projectform.contact.disabled = false;
	 document.projectform.sponsor.disabled= false;
	 document.projectform.owner.disabled = false;
	 document.projectform.priority.disabled = false;
	
}
function addf()

{  
	document.op.save.disabled=false;
	document.op.cancel.disabled = false;
	clear();
	
	
	
}
function deletef()
   {
	alert("Are you sure you want to delete this record");
	
	
	}

function nextf()

{
	
	
}

</script>
</head>
<body >
<table class="outerbox" >
<tr><td class="boxtitle" >Projects</td></tr>
<tr><td > </td></tr>

<td>
project Name
</td>
<td><input type="text" name="pname" id="pname" size="25" value="<%=request.getAttribute("pr_name")%>" disabled></input>
</td>

</tr>
<tr>
<td>
Description/Remarks
</td>
<td><input type="text" name="remarks" size="25" value="<%=request.getAttribute("pr_remarks")%>"  disabled></input>
</td>
</tr>
<tr>

<td>
Client IT Contact Person
</td>
<td><input type="text" name="contact" size="25" value="<%=request.getAttribute("pr_cnt")%>" disabled></input>
</td>

</tr>
<tr>
 
<td>
Business Sponsor
</td>
<td><input type="text" name="sponsor" size="25" value="<%=request.getAttribute("pr_bsponsor")%>" disabled></input>
</td>
</tr>
<tr>
 
<td>
Business Project owner
</td>
<td><input type="text" name="owner" size="25" value="<%=request.getAttribute("pr_bpowner")%>" disabled></input>
</td>
</tr>
<tr><td>Priority</td>
<td>
<Select name="priority" disabled>
<option selected><%=request.getAttribute("pr_priority")%></option>
<option>High</option>
<option>Medium</option>
<option>Low</option>
</Select></td>
</tr>
</table>
</form>
<HR  SIZE="3"> 
<form   name="op" method="post" action="projectservlet">
<table  class="navigationclass" >
<tr><td > </td></tr>
<tr><td  >Operations</td><td  >Navigation</td></tr>
<tr>
<td><button type="submit"  name="save" value="save" onclick="savef()" disabled>Save</button></td>
<td><button type="button"  name="add" value="add" onclick="addf()">Add</button></td>
<td><button type="submit"  name="delete" "value="delete" onclick="delete()">delete</button></td>
<td><button type="submit"  name="cancel" value="cancel" onclick="cancelf()" disabled>Cancel</button></td>
<td><button type="submit"  name="edit" value="edit" onclick="editf()">Edit</button></td>
<td><button type="submit"  name="first" value="first" onclick="firstf()">First</button></td>
<td><button type="submit"  name="prev" value="prev" onclick="prevf()">prev</button></td>
<td><button type="submit"  name="next" value= "next" onclick="nextf()">Next</button></td>
<td><button type="submit"  name="last" value="last" onclick="lastf()">Last</button></td>
<td><button type="submit"  name="find" value="find" onclick="findf()">Find</button></td>
</tr>
</table>
</form>

</table>

</body>
</html>

//code for servlet

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		response.setContentType("text/html;charset=UTF-8");
	       PrintWriter out = response.getWriter();
	    
	        
	        Connection con = null;
	        Statement st;
	        ResultSet rs;
	        
	        try {
	            Class.forName("oracle.jdbc.driver.OracleDriver");

con = DriverManager.getConnection("jdbc:oracle:thin:@//localhost:1521/orcl", "scott", "tiger");
	           // String button1 = request.getParameter("next");
	            
	            
	            st=con.createStatement();
	            rs=st.executeQuery("select * from prproject");
	            
	            
              
	            out.println("<html>");
	            out.println("<head>");
	            out.println("<title>Servlet servlet1</title>");  
	            out.println("</head>");
	            out.println("<body>");
	           
	            
	            if(rs.next())
	            {
	                  
	            	String s1 = rs.getString("pname");
		            String s2 = rs.getString("remarks");
		            String s3= rs.getString("cnt");
		            String s4 = rs.getString("bsponsor");
		            String s5 = rs.getString("bprowner");
		            String s6 = rs.getString("priority");

request.setAttribute("pr_name",s1);
		            request.setAttribute("pr_remarks",s2);
		            request.setAttribute("pr_cnt",s3);
		            request.setAttribute("pr_bsponsor",s4);
		            request.setAttribute("pr_bpowner",s5);
		            request.setAttribute("pr_priority",s6);
		            
		            
		           
	                RequestDispatcher rd=getServletContext().getRequestDispatcher("/project.jsp");
	                rd.forward(request,response);
	             }
	
	      
	            out.println("</body>");
	            out.println("</html>");
	            
	        }catch(SQLException e1)
	        {
	            out.println(e1.getMessage());
	        } catch (ClassNotFoundException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
	        finally
	        {
	            out.close();
	           
	        }
	    } 
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
	this.doPost(request,response);
	}

}

Thanks

Regards,
Shweta Bhardwaj

Bear Bibeault

Sheriff

Posts: 67754

173

I like...

posted 14 years ago

1
Number of slices to send:

Optional 'thank-you' note:

Send

Hmmm, I'm trying to look at your code, but the stubborn forum software has made it look all wonky. If you use CODE tags when posting code to the forums (see the FAQ at ⇒ UseCodeTags ⇐) they tell it "Hey! Keep your hands off my formatting!" and your code will look just like when you cut and pasted it into the reply. Cool, no?

I went and added code tags to your post. See how much easier the code is to read?

[Asking smart questions] [About Bear] [Books by Bear]

HTML 5 (verified skill)
Skill verified by Jeanne Boyarsky

CSS 3 (verified skill)
Skill verified by Jeanne Boyarsky

JavaScript (verified skill)
Skill verified by Jeanne Boyarsky

Bhardwaj Shweta

Ranch Hand

Posts: 36

I like...

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

yeah:) Thanks Bear for doing that

Regards,
Shweta Bhardwaj