Web Related

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