0

For me getting same result (all the text box are null value is filled) after move the textboxes after calling request.getParameter() also...
What i need to change it?
Where i need to edit?

First Jsp Page

       <%@ page import="java.sql.*" %>
        <% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");%>
        <HTML>
        <HEAD>
        <TITLE>Fetching Data From a Database</TITLE>
        </HEAD>
        <BODY>
        <H1>Fetching Data From a Database</H1>
        <%
    Connection connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","password");  
    ResultSet resultset;
    Statement statement=connection.createStatement();
    resultset = statement.executeQuery("SELECT * FROM testtb");
    if (!resultset.next()) {
    out.println("Sorry, could not find the data. ");
    } else {
    %>
    <TABLE cellpadding="15" border="1" style="background-color: #ffffcc" align="center">
    <TR>
    <TH>Id</TH>
    <TH>Task Name</TH>
    <TH>Description</TH>
    <TH>Priority</TH>
    <TH>Date</TH>
      <TH>Time</TH>
    <TH>Edit</TH>
    <TH>Delete</TH>
    </TR>
    <%
    do {
    %>
    <TR>
    <TD> <%= resultset.getString(1)%> </TD>
    <TD> <%= resultset.getString(3)%> </TD>
    <TD> <%= resultset.getString(4)%> </TD>
    <TD> <%= resultset.getString(5)%> </TD>
    <TD> <%= resultset.getString(6)%> </TD>
     <TD> <%= resultset.getString(7)%> </TD>
    <TD><input type="button" name="edit" value="Edit" onClick="javascript:window.location='edit.jsp';" style="background-color:#49743D;font-weight:bold;color:#ffffff;">
    </TD>
    <TD><input type="button" name="delete" value="Delete" onClick="javascript:window.location='deleteData.jsp';"style="background-color:#ff0000;font-weight:bold;color:#ffffff;"></TD>
    </TR>
    <%resultset.next();
    } while (resultset.isAfterLast() != true);
    %>
    </TABLE>
    <BR>
    <%
    }
    %>
    </BODY>
    </HTML>

Second JSP Page

<%@ page language="java" import="java.sql.*"%>
<head>
</head>
<body>
  <form name="editform" method="post" action="edit.jsp">
    <%! String id = "";
    String taskname = "";
    String description = "";
    String priority = "";
    String date = "";
    String time = "";
    %>
    <br><br><br>
<%
id = request.getParameter("id");
taskname = request.getParameter("taskname");
description = request.getParameter("description");
priority = request.getParameter("priority");
date = request.getParameter("date");
    time = request.getParameter("time");
  %>           
<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>Task Name</td>
  <td><input type="text" name="taskname" value="<%=taskname%>"></td>
  </tr>
  <tr>
  <td>Descrption</td>
  <td><input type="text" name="description" value="<%=description%>"></td>
  </tr>
  <tr>
  <td>Priority</td>
  <td><input type="text" name="priority" value="<%=priority%>"></td>
  </tr>
  <tr>
  <td>Date</td>
  <td><input type="text" name="date" value="<%=date%>"></td>
  </tr>
  <tr>
  <td>Time</td>
  <td><input type="text" name="time" value="<%=time%>"></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;
    String url = "jdbc:mysql://localhost:3306/test";
    String username = "root";
    String password = "password";
    String driver = "com.mysql.jdbc.Driver";  
out.println(request.getRequestURI());
if (id != null && taskname != null && description != null && priority != null && date != null && time != null) {
if (id != "" && taskname != "" && description != "" && priority != "" && date != "" && time != "") {
try {
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url,username,password);
System.out.println("Connected to the database");
//ArrayList al = null;
// ArrayList userList = new ArrayList();
String query = "UPDATE testtb SET id= "+id+",taskname=" + taskname + ",description=" + description + ",priority=" + priority + ",date=" + date + ",time=" + time + "";
stmt = conn.createStatement();
int i = stmt.executeUpdate(query);
System.out.println("query" + query);
if (i > 0) {
response.sendRedirect("welcome.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>




Give me a brief description******

Edited by pradap.adwani

2
Contributors
1
Reply
12
Views
4 Years
Discussion Span
Last Post by peter_budo
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.