File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes please help me Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Reply locked New topic
Author

please help me

stalin vanama
Greenhorn

Joined: Sep 15, 2005
Posts: 2
whilw i am compling the code i got this error.
code is

<%@ page import="java.util.*,java.io.*,javax.servlet.http.*,javax.servlet.*,java.sql.*,java.sql.ResultSet.*" session="true" %>

</b><br><br>

<html><head><title>Upadting Values</title></head>

<body bgcolor="#FCFCFO">

<b><a href="add.jsp" style="text-decoration:none">Add Account Details!</a>

   

<a href="val.jsp" style="text-decoration:none"> Display!</a>

   

<a href="login.jsp" style="text-decoration:none"> Logout!</a></b>

<hr>

<%

try

{

Connection con=null;

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

con = DriverManager.getConnection("Jdbc dbc:vsr","","");

Statement st = con.createStatement();

out.println("Connection Established <br>");

ResultSet rs = st.executeQuery("UPDATE accounts SET acountname = accountname,startdate = startdate,balance = balance,address = address WHERE accountno = accountno");

out.println("<b>Record Updated</b>");

System.out.println("Connection closed");

}catch(SQLException e)
{
out.println("SQLException: " + e.getMessage() + "<BR>");
while((e = e.getNextException()) != null)
out.println(e.getMessage() + "<BR>");
}

%>
Dave Salter
Ranch Hand

Joined: Jul 20, 2005
Posts: 292

Hi, Welcome to JavaRanch.

Please don't make multiple posts about the same subject. If you need to edit a post, theres a button at the top of the submission for that allows you to do this.

I've made a reply to your post

here, hopefully that will help.

Cheers.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: please help me