Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


Sanjeev
Web Related
1 Answer(s)      5 years and 10 months ago
Posted in : JSP-Servlet



Advertisement
View Answers

March 17, 2009 at 12:56 AM


Hi friend,

I am sending you few code as the JSP pages which will help you in solving your problem. In these JSP pages the first jsp page Updaterecord.jsp will allow you to see the updated records and as well as you can insert here the database records to be added. It internally calls the insertmid.jsp which after performing insertion will redirect to the Updaterecord.jsp page. Code is as follows :

Updaterecord.jsp

<%@ page language="java" import="java.io.*, java.sql.*" %>
<html>
<head>
<title>update record</title>
</head>
<body>
<table border="1">
<tr>
<td>Id</td>
<td>First Name</td>
<td>Last Name</td>
</tr>
<%
int id=0;
Connection con = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String driver = "com.mysql.jdbc.Driver";
String userName ="amar";
String password="amar123";
String name="";
String lastName="";

try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,userName,password);

Statement st = con.createStatement();
String sqlQuery = "Select * from userinform";
ResultSet rs = st.executeQuery(sqlQuery);
while(rs.next())
{
%>
<tr>
<td><%=rs.getInt(1) %></td>
<td><%=rs.getString(2) %></td>
<td><%=rs.getString(3) %></td>
</tr>
<% }
}
catch(Exception e) {
System.out.println(e.getMessage());
}
%>

<center>
<table border="0" width="400px" cellspacing="0" cellpadding="0">
<tr>
<td width="100%">
<center>
<h2><font color="#FF0033">Add data into database</font></h2></center>
<form name="updateForm" action="insertmid.jsp" method="GET" >
<input type="hidden" name="id" value="<%=id%>">
<table border="1" width="400px" cellspacing="0" cellpadding="0" bgcolor="#CCFFCC">
<td width="50%"><b>Name</b></td>
<td width="50%">
<input type="text" name="name" value="<%=name%>"></td></tr>
<td width="50%"><b>Last Name</b></td>
<td>
<input type="text" name="lsname" value="<%=lastName%>"><br/></td>
</tr>
<tr><td><center>
<input type="submit" name="update" value="Update"></center></td></tr>
</tr>
</table>
</form>
</td>
</tr>
</table>
</center>
</body>
</html>

// insertmid.jsp

<%@ page language="java" import="java.sql.*" %>

<%
Connection con = null;
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String userName = "amar";
String password = "amar123";
if(request.getParameter("name")!=null && request.getParameter("lsname")!=null){
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,userName,password);
try{
Statement st = con.createStatement();
String name=request.getParameter("name");
String lsname=request.getParameter("lsname");
int val = st.executeUpdate("insert into userinform(name,lsname) values('"+name+"','"+lsname+"')");
con.close();
response.sendRedirect("Updaterecord.jsp");
}
catch (SQLException ex){
System.out.println("SQL statement is not executed!");
}
}
catch (Exception e){
e.printStackTrace();
}
}
%>

Thanks for posting questions.
RoseIndia Team


Related Tutorials/Questions & Answers:
Web Related - JSP-Servlet
Web Related  Dear Sir, I am in truble, i need your help. How can i update my webpage by inserting the value in database. The webpage... time and all these values i want to show on my web page dynamically.plz help me
Internet and Web related questions for Web Master.
Internet and Web related questions for Web Master.   Explain the difference between the Internet and Web. What are Web browsers? Explain the two main functions of a Web browser. Write a note on the structure of a Web page. What
Advertisements
Related to XML
Related to XML  I have made a web application which send the SMS, i have provided the url in which i have to save the msg and the number's(to whom the message to be send).After fetching the message and numbers i was keeping
Related to XML
Related to XML  I have made a web application which send the SMS, i have provided the url in which i have to save the msg and the number's(to whom the message to be send).After fetching the message and numbers i was keeping
StringBuffer related.
StringBuffer related.  how to make StringBuffer as immutable
related to database
related to database  how to override existing values in table? when user enters his updated data through query
Related to Histogram
Related to Histogram  hi this is srinivasrao. In my project i have to display using chart for that i want to use histogram. k chart displayed but the values given by me is not related display chart so please give the code if u
related to java
related to java  what is mean of }); in java.i know that } is used to close a block of statement,) is used to close a statement and ";"is used after close a statement but i can not usderstood the use of }); together in a java
Related to Project
Related to Project  how speech to text project can be make in java? Please tell me the coding part therapeutically i know i have to use java speech api which offer two technology 1. speech recognization 2. speech syenthesis
java related - Java Beginners
know where to start from. I have purchased one java related book. But I am... Microsystems. Though it is associated with the World Wide Web but it is older than the origin of Web. It was only developed keeping in mind the consumer electronics
Dumps related to weblogic certification
Dumps related to weblogic certification   I want to perform the weblogic certification exam code 1z0-110. Can anybody please provide me the dumps related to 1z0-110 Thanks in advance
question related to overloading
question related to overloading  what is difference between function overloading & method overloading
question related to overloading
question related to overloading  what is difference between function overloading & method overloading
Java and jvm related question
Java and jvm related question  What is difference between java data types and jvm data types
Java Related Question
Java Related Question  hi, Why java doesn't has primitive type as an object,whats an eligibility to have a primitive type as an object by the languages
liferay related query
liferay related query  can you suggest me how to get all the session ids of different users logged in to liferay
Server Related exception
Server Related exception  How will write code to handle serverside exceptions in our projects.Earlier we dont know which exception the code will throw
Question related to Hibernate
Question related to Hibernate  Why do we use Set in child class in 1:many hibernate ,why can't we use Directly HashSet
Related to weblogic server8.1
Related to weblogic server8.1  hi Everybody, i have write a simple servlet program and deploy on weblogic8.1 server. when I'm running this app. when...:\firstApp\WEB-INF\classes;C:\bea\userprojects\domains\mydomain
iphone property list related
iphone property list related  question related to iphone application...... how to retrieve data from plist and again check the condition if data is found in plist then go to next view and print those value in table
string related question
string related question  *q.1>how i dispaly the reference of string variableS ? eg:-String s1="my name"; Sring s2="your name"; here what is address of variable s1 and s2
JDBC related query
JDBC related query  How to merge two resultset of two different queries, wherein both the resultset(after query execution)gives an integer value as its column
problem related to onSubmit() method
problem related to onSubmit() method  Hello, I am developing application.when i submit form at that time formBacking() method is call...Instead of that onSubmit() should have to call .... please help me
project related question
project related question  1- how to insert a date through hibernate 2- how to insert exact time ,date separetly in the data base for current time date
database related query
database related query  i have created database in phpmyadmin of wampserver ! but i can't see it in mysql command line ! Can anybody please help me
Struts related Question
Struts related Question  Hi All, I have a one question on validation framework for client side validation please help me on that. suppose i don't want to put required=true in our JSP then what will happen. what error will come
query related to jdbc
query related to jdbc  hello, i have done my database connection successfully ie db2 with RAD. but while running my application i am not able to fetch the data so please suggest and help me
web
web  what do you mean by stacking elements? explain with example(in web programming
web
web  what do you mean by stacking elements? explain with example(in web programming
query related to uploading file
query related to uploading file  hello friends i am doing my project in servlet and i want to upload a file and store file in local hard drive and file name and path in oracle database.with name file name and path i also want
java related question
java related question  How can we make a program in which we make mcqs question file and then make its corresponding answer sheet....like if we make 15 mcqs then java should generate it answer sheet of 15 mcqs with a,b,c d
 

 

 

DMCA.com