File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JSP and the fly likes this is wot my codes like Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSP
Bookmark "this is wot my codes like" Watch "this is wot my codes like" New topic
Author

this is wot my codes like

payal kapadia
Greenhorn

Joined: Feb 08, 2005
Posts: 10
my codes something like this.

<html>....
//script
function subb()
{


document.f1.submit();
<%
String id1=(request.getParameter("gpd"));
System.out.println(id1);
insbn.setsc_details(id1);
insbn.retdb();
%>
}
//script ends

<form>

<input type="text" name="gpd">
<input type="button" name="ss" value="submit" >//onclick goes to subb

</form></html>

//the bean file goes like this.

public class insretgp
{

public String sc;

public String getsc_details()
{
return sc;
}

public void setsc_details(String c)
{
sc=c;
System.out.println(sc);
}

public void retdb()
{
String sname=getsc_details();
String nn="null";
try
{


Context initCtx=new InitialContext();
if(initCtx == null)
throw new Exception("Boom - no Context");
Context envCtx=(Context) initCtx.lookup("java:comp/env");
DataSource ds=(DataSource) envCtx.lookup("jdbc/myoracle");
Connection conn=ds.getConnection();
Statement stmt2=conn.createStatement();

String query2="insert into gp" + "(ss)"+"values" +"('"+sname+"')";
String query3="delete from gp where (ss='"+nn+"')";
Statement stmt3=conn.createStatement();
stmt2.executeUpdate(query2);
stmt3.executeUpdate(query3);
stmt2.close();
stmt3.close();
conn.close();
}
catch(SQLException e)
{
System.out.println("Exception occured in class:insretgp" +e.toString());
}
catch(Exception er)
{
System.out.println("Exception occured in class:insretgp" +er.toString());
}}}
Vijay Sharma
Ranch Hand

Joined: Feb 02, 2005
Posts: 32
Hi payal,
First thing you should learn variable Naming skills.Because you had taken gbd,nn this kind of variable,so it makes understanding code worse.Anyway i had reviewed your code.There you had taken one variable as nn and assign it a string value null.Again just check your query.Also do one thing first remove all the statement of context lookup and createStatement from the retdb() function.Put these statement in the class outside the function.Then it becomes more clear.I think from somewhere you are inserting the value of "nn" variable.That's why it is creating the problems.Just do these things and check whether the code is working or not,and tell me.


Vijay Sharma
Ben Souther
Sheriff

Joined: Dec 11, 2004
Posts: 13410

You'll also get a lot more people to look at your code and help you out if you wrap it in code tags to preserve indenting.

There is a UBB CODE button on the page that makes this very easy.


Java API J2EE API Servlet Spec JSP Spec How to ask a question... Simple Servlet Examples jsonf
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: this is wot my codes like