Java

code is nopt updating the database as given below

Please support our Java advertiser: Programming Forums - DaniWeb Sister Site

•

Join Date: Oct 2007

Posts: 19

Reputation: mrityunjay22 is an unknown quantity at this point

Solved Threads: 0

mrityunjay22 mrityunjay22 is offline

Offline

Newbie Poster

code is nopt updating the database as given below

Oct 16th, 2007

jsp code

<%@ page import="temperory.Mrityunjay.*"%>
<%@ page import="com.MindShaper.ClassTeacher.Utility.BaseServlet.VSHttpServlet" %>
<%@ page import="java.util.*"%>
<%@ page import="com.MindShaper.ClassTeacher.Utility.Helper.*" %>
<%@ page import="ClassTeacher.SessionObject"%>
<%@ page import="ClassTeacher1.MemoryTables"%>

<HTML>
<HEAD>
<TITLE>Student Information</TITLE>

<script language="JavaScript1.2" src="functions.js" type="text/javascript"> </script>
<link rel="stylesheet" href="lib.css" type="text/css">

<style type="text/css">

</style>

</HEAD>

<BODY>
<link rel="stylesheet" href="/utils/infrastructure/common.css" type="text/css">
<form name="input" method='get' action="/servlets/temperory.Mrityunjay.Update" >
<%

SessionObject sessObj= (SessionObject)request.getSession(false).getValue("com.MindShaper.ClassTeacher.VS.SessionObject");
if(sessObj == null) {
String errMsg = "Your Session Has Been Deactivated";
errMsg = MemoryTables.removeSpaces(errMsg);
response.sendRedirect("/servlets/ClassTeacher.GetLoginData?errMsg=" + errMsg);
return;
}
Displayname a= new Displayname();
int Id=RequestHelper.getInt(request,"Id",0);
String act = RequestHelper.getString(request,"act","");
String fname = "";
String lname ="";
String class1="";

if(act.equalsIgnoreCase("edit"))
{
a = Displayname.getbyId(Id);
fname=a.getFirstname();
lname = a.getLastname();
class1=a.getClass1();

}

%>

<table border="0" align='center' width="70%" height="20%">
<tr>
<th align=Center colspan=0></th>
</tr>
Type your first name:
<input type="text" name="FirstName" value ="<%=fname%>">
<br>
<br>Type your last name:
<input type="text" name="LastName"value= "<%=lname%>">
<br>
<br>Type your Class:
<input type="text" name="Class" value= "<%=class1%>" >
<br>
<input type="submit" value="UPDATE">
<input type="hidden" name="act" value="<%=act%>">
</form>
</BODY>
</HTML>

servlet code

// Decompiled by Jad v1.5.8e2. Copyright 2001 Pavel Kouznetsov.
// Jad home page: http://kpdus.tripod.com/jad.html
// Decompiler options: packimports(3)
// Source File Name: AddEditArea.java

package temperory.Mrityunjay;

import ClassTeacher.SessionObject;
import ClassTeacher1.MemoryTables;
import com.MindShaper.ClassTeacher.Utility.BaseServlet.VSHttpServlet;
import com.MindShaper.ClassTeacher.Utility.Helper.*;
import java.io.IOException;
import java.util.Date;
import javax.servlet.ServletException;
import javax.servlet.http.*;

// Referenced classes of package com.MindShaper.ClassTeacher.Utility.Administration.NTransport:
// NTransportDBHelper

public class Update extends VSHttpServlet
{

public Update()
{
}

public void doGet(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException
{
doPost(req, res);
}

public void doPost(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException
{
SessionObject sessObj1 = (SessionObject)req.getSession(false).getValue("com.MindShaper.ClassTeacher.VS.SessionObject");
if(sessObj1 == null)
{
String errMsg = "Your Session Has Been Deactivated";
errMsg = MemoryTables.removeSpaces(errMsg);
res.sendRedirect("/servlets/ClassTeacher.GetLoginData?errMsg=" + errMsg);
return;
}
Log.log("1");
String act;
act= RequestHelper.getString(req,"act","");
Log.log("2");

int Id= RequestHelper.getInt(req, "Id",0);
String fname = RequestHelper.getString(req, "FirstName", "");
String lname = RequestHelper.getString(req, "LastName", "");
String class1 = RequestHelper.getString(req, "Class", "");

String query1= "UPDATE MRITYUNJAY set Firstname = '"+StringHelper.makeDbSafe(fname)+"',Lastname = '"+StringHelper.makeDbSafe(lname)+"',Class='"+StringHelper.makeDbSafe(class1)+"' where Id= "+Id;
Log.log("3");
try
{
DBHelper.executeIt(query1);
}

catch(Exception e)
{
}

res.sendRedirect("/temp/mrityunjay/displayname.jsp");

}
}

plz help as urgent as possible

•

Join Date: Feb 2006

Posts: 2,467

Reputation: masijade has much to be proud of

Solved Threads: 266

masijade

Offline

Nearly a Posting Maven

Re: code is nopt updating the database as given below

Oct 16th, 2007

Error messages and stack traces would help.

Java Programmer and Sun Systems Administrator

----------------------------------------------

Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.
--Brian Kernighan

•

Join Date: Oct 2007

Posts: 19

Reputation: mrityunjay22 is an unknown quantity at this point

Solved Threads: 0

mrityunjay22 mrityunjay22 is offline

Offline

Newbie Poster

Re: code is nopt updating the database as given below

Oct 16th, 2007

there is no error messages and i dont know how to code trace plz help me i need it urgently

•

Join Date: Feb 2006

Posts: 2,467

Reputation: masijade has much to be proud of

Solved Threads: 266

masijade

Offline

Nearly a Posting Maven

Re: code is nopt updating the database as given below

Oct 16th, 2007

I'm sorry, but that says it all.

The application server you are using to server these pages has a log. The errors should be found there. And I said nothing about a "code trace". I said a "stack trace", these should also be in the log file, probably directly after the error message, as long as the application server is not configure to prevent them.