jsp
how to edit only one row from multiple row from single jsp page dynamically
View Answers
August 5, 2013 at 5:27 PM
<%@ page language="java" import="java.sql.*"%>
<head>
</head>
<body bgcolor="#008B8B">
<form name="editform" method="post" >
<br><br><br>
<%
String id = request.getParameter("id");
String name = request.getParameter("name");
String username = request.getParameter("username");
String password = request.getParameter("password");
String company_id = request.getParameter("company_id");
String company_name = request.getParameter("company_name");
String address = request.getParameter("address");
String phone = request.getParameter("phone");
String fax = request.getParameter("fax");
String email_id = request.getParameter("email_id");
%>
<table align="center" width="300px" style="background-color:#EDF6EA;border:1px solid #000000;">
<tr><td colspan=2 style="font-weight:bold;" align="center">Edit User</td></tr>
<tr><td colspan=2 align="center" height="10px"></td></tr>
<tr>
<td>id</td>
<td><input type="text" name="id" value="<%=id%>"></td>
</tr>
<tr>
<td>name</td>
<td><input type="text" name="name" value="<%=name%>"></td>
</tr>
<tr>
<td>username</td>
<td><input type="text" name="username" value="<%=username%>"></td>
</tr>
<tr>
<td>password</td>
<td><input type="text" name="password" value="<%=password%>"></td>
</tr>
<tr>
<td>company_id</td>
<td><input type="text" name="company_id" value="<%=company_id%>"></td>
</tr>
<tr>
<td>company_name</td>
<td><input type="text" name="company_name" value="<%=company_name%>"></td>
</tr>
<tr>
<td>address</td>
<td><input type="text" name="address" value="<%=address%>"></td>
</tr>
<tr>
<td>phone</td>
<td><input type="text" name="phone" value="<%=phone%>"></td>
</tr>
<tr>
<td>fax</td>
<td><input type="text" name="fax" value="<%=fax%>"></td>
</tr>
<tr>
<td>email_id</td>
<td><input type="text" name="email_id" value="<%=email_id%>"></td>
</tr>
<tr>
<td></td>
<td><input type="submit" name="Submit" value="Update" style="background-color:#49743D;font-weight:bold;color:#ffffff;"></td>
</tr>
<tr><td colspan=2 align="center" height="10px"></td></tr>
</table>
<%
Statement stmt;
Connection conn = null;
out.println(request.getRequestURI());
if (id != null && name != null && username != null && password != null && company_id != null && company_name != null && address != null && phone != null && fax != null && email_id != null)
{
if (id != "" && name != "" && username != "" && password != "" && company_id != "" && company_name != "" && address != "" && phone != "" && fax != "" && email_id != "" ) {
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/company","root","root");
String query = "UPDATE addcmp SET id= "+id+",name=" + name + ",username=" + username + ",password=" + password + ",company_id=" + company_id + ",company_name=" + company_name + ", address=" + address + ", phone=" + phone + ", fax=" + fax + ", email_id=" + email_id + "";
stmt = conn.createStatement();
int i = stmt.executeUpdate(query);
System.out.println("query" + query);
if (i > 0)
{ System.out.println("Connected to the database");
response.sendRedirect("Edit.jsp");
}
conn.close();
System.out.println("Disconnected from database");
%>
<br>
<TABLE style="background-color: #E3E4FA;"
WIDTH="30%" border="1">
<tr><th>Data Modified successfully in database.</th></tr>
</TABLE>
<%
} catch (Exception e) {
e.printStackTrace();
}
}
}
%>
</form>
</body>
</html>
Related Tutorials/Questions & Answers:
Advertisements
JSP
what is JSP forward tag for what is JSP forward tag for It forwards the current request to another JSP page. Below is the syntax for the same:- <jsp:forward page="...url..." /> We can also forward parameter
what is JSP forward tag for what is JSP forward tag for It forwards the current request to another JSP page. Below is the syntax for the same:- <jsp:forward page="...url..." /> We can also forward parameter
jsp
jsp how to create a table in oracle using jsp and the table name is entered in text feild of jsp page
jsp how to create a table in oracle using jsp and the table name is entered in text feild of jsp page
jsp
jsp write a code for jsp file generator to generate a jsp page automatically taking html page as input
jsp write a code for jsp file generator to generate a jsp page automatically taking html page as input
JSP
JSP Hi, What is JSP? What is the use of JSP? Thanks Hi, JSP Stands for Java Server Pages. It is Java technology for developing web applications. JSP is very easy to learn and it allows the developers to use Java
JSP Hi, What is JSP? What is the use of JSP? Thanks Hi, JSP Stands for Java Server Pages. It is Java technology for developing web applications. JSP is very easy to learn and it allows the developers to use Java
jsp
jsp what is the basic necessities reguired for running jsp using JDBC bridge?? and how to write a jsp code to access the detail present in microsoft access pls send link regarding above
jsp what is the basic necessities reguired for running jsp using JDBC bridge?? and how to write a jsp code to access the detail present in microsoft access pls send link regarding above
JSP
JSP How to create CAPTCHA creation by using JSP? I need an code for CAPTCHA creation by using JSP... You can create a captcha validation using jsp. Have a look at the following tutorial: Captcha Creation
JSP How to create CAPTCHA creation by using JSP? I need an code for CAPTCHA creation by using JSP... You can create a captcha validation using jsp. Have a look at the following tutorial: Captcha Creation
JSP
What are JSP directives, page directives and include directives? what are jsp directives? and what are page directives? and what are include directives? can you explain taglib directives? JSP directives JSP
What are JSP directives, page directives and include directives? what are jsp directives? and what are page directives? and what are include directives? can you explain taglib directives? JSP directives JSP
JSP
Can you explain jsp page life cycle what is el how does el search for an attribute in JSP Can you explain jsp page life cycle what is el how does el...://www.roseindia.net/jsp/simple-jsp-example/LifeCycleOfJspPage.shtml http
Can you explain jsp page life cycle what is el how does el search for an attribute in JSP Can you explain jsp page life cycle what is el how does el...://www.roseindia.net/jsp/simple-jsp-example/LifeCycleOfJspPage.shtml http
JSP
JSP what are the different scopes an object can have in a jsp page JSP Scope Variables: Page scope-It makes the data available... the following links: http://www.roseindia.net/jsp/simple-jsp-example
JSP what are the different scopes an object can have in a jsp page JSP Scope Variables: Page scope-It makes the data available... the following links: http://www.roseindia.net/jsp/simple-jsp-example
jsp
jsp how to connect the database with jsp using mysql Hi Friend, Please visit the following links:ADS_TO_REPLACE_1 http://www.roseindia.net/jsp/connectjspwith_mysql.shtml http://www.roseindia.net/jsp
jsp how to connect the database with jsp using mysql Hi Friend, Please visit the following links:ADS_TO_REPLACE_1 http://www.roseindia.net/jsp/connectjspwith_mysql.shtml http://www.roseindia.net/jsp
JSP
what is jstl in JSP what is jstl JSTL is also called as JSP tag libraries. They are collection of custom actions which canbe accessed as JSP tags. For more information, visit the following link: JSTL Tutorials
what is jstl in JSP what is jstl JSTL is also called as JSP tag libraries. They are collection of custom actions which canbe accessed as JSP tags. For more information, visit the following link: JSTL Tutorials
JSP
access application data stored in JavaBeans components. The jsp expression...). Before JSP 2.0, we could use only a scriptlet, JSP expression, or a custom tag to include server state in the jsp page output. For more information, visit
access application data stored in JavaBeans components. The jsp expression...). Before JSP 2.0, we could use only a scriptlet, JSP expression, or a custom tag to include server state in the jsp page output. For more information, visit
JSP
JSP public opinion poll Develop a JSP for a news channel to conduct public opinion poll on any topic. Users will respond through yes or no options. Later display the result in percentage
JSP public opinion poll Develop a JSP for a news channel to conduct public opinion poll on any topic. Users will respond through yes or no options. Later display the result in percentage
jsp
jsp Hi all..I am new in jsp. I have a question. I want develope a jsp page it contain two part for two different user group. i want to hide some information from user1 group and same as user2 group. can i do this in single jsp
jsp Hi all..I am new in jsp. I have a question. I want develope a jsp page it contain two part for two different user group. i want to hide some information from user1 group and same as user2 group. can i do this in single jsp
jsp
jsp Dear deepak, wat is the purpose of converting jsp into servlet and how the process takes place.. with regards, praveen
jsp Dear deepak, wat is the purpose of converting jsp into servlet and how the process takes place.. with regards, praveen
jsp
jsp In any jsp all implicit objects are available directly, in such a case why we need PageContext object again
jsp In any jsp all implicit objects are available directly, in such a case why we need PageContext object again
JSP
JSP how does jsp engines instantiae tag handler classes instances JSP engines will always instantiate a new tag handler instance every time a tag is encounteredin a JSP page. A pool of tag instances are maintained
JSP how does jsp engines instantiae tag handler classes instances JSP engines will always instantiate a new tag handler instance every time a tag is encounteredin a JSP page. A pool of tag instances are maintained
jsp
jsp in my project i have following jsp in this jsp the pagesize=30 but i have to create drop down box with values 10,20,30. and i have to pass them to pagesize how can i do this please help me
jsp in my project i have following jsp in this jsp the pagesize=30 but i have to create drop down box with values 10,20,30. and i have to pass them to pagesize how can i do this please help me
JSP
JSP What is JSP? JavaServer Pages (JSP) is a server-side Java technology an extension to the Java servlet technology that helps... Pages (JSP) is a server-side Java technology an extension to the Java servlet
JSP What is JSP? JavaServer Pages (JSP) is a server-side Java technology an extension to the Java servlet technology that helps... Pages (JSP) is a server-side Java technology an extension to the Java servlet
JSP
objects in jsp Implicit objects in jsp are the objects... and are created at the conversion time of a jsp into a servlet. But we can pass.../o/jsp-implicit-objects.shtml
objects in jsp Implicit objects in jsp are the objects... and are created at the conversion time of a jsp into a servlet. But we can pass.../o/jsp-implicit-objects.shtml
JSP
objects in jsp Implicit objects in jsp are the objects... and are created at the conversion time of a jsp into a servlet. But we can pass.../jsp-implicit-objects.shtml
objects in jsp Implicit objects in jsp are the objects... and are created at the conversion time of a jsp into a servlet. But we can pass.../jsp-implicit-objects.shtml
JSP
JSP Consider that we need to have a text, combo, radio & checkbox in JSP page and the page data's are retrieved from
JSP Consider that we need to have a text, combo, radio & checkbox in JSP page and the page data's are retrieved from
JSP
JSP Develop a JSP to keep track number of users and display a message â??You are nth visitorâ?? where n is number of user
JSP Develop a JSP to keep track number of users and display a message â??You are nth visitorâ?? where n is number of user
JSP
how can we use beans in jsp how can we use beans in jsp JSP provides three tags to work with beans:- <jsp:useBean id="bean name... that defines the bean. <jsp:setProperty name = "id" property = "someProperty" value
how can we use beans in jsp how can we use beans in jsp JSP provides three tags to work with beans:- <jsp:useBean id="bean name... that defines the bean. <jsp:setProperty name = "id" property = "someProperty" value
Ads