QuestionAsk Questions?
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
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 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
