Search...
FAQs Subscribe
Pie
FAQs
Recent topics Flagged topics Hot topics Best topics
Search...
Search within JDBC and Relational Databases Search Coderanch
Advance search Google search
Register / Login
thread boost book review grid granny polymorphism advertise on coderanch
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
advertise on coderanch thread boost book review grid meaningless drivel building better world book
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Error - ; expected

 
Sri Gnana
Ranch Hand
Posts: 166
posted 19 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Hi,
when i try to execute the code given below, its throwing compile time error
; expected, please help me
__________________________________

<%@ page import="java.sql.*" %>


<html>
<Body bgcolor=silver>
<br>
<%



String s1=null,s2=null,s3=null,s4=null,s5=null,s6=null;
String sqltext;

s1=request.getParameter("txtName");
s2=request.getParameter("txtAdnno");
s3=request.getParameter("selClass");
s4=request.getParameter("selSec");
s5=request.getParameter("txtDate");
s6=request.getParameter("txtAdnfee");



if(s1 !=null)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc dbc:Adn","","");
Statement st=con.createStatement();

sqltext="insert into AllIn ("Name, Adnno, Class, Section, Date, Adnfee") values ('"+s1+"','"+s2+"','"+s3+"','"+s4+"','"+s5+"','"+s6+"' )";

st.executeUpdate(sqltext);
out.println("Inserted Successfully!");

}
catch(Exception e)
{
System.out.println(e);
}
}
else
{
%>

your data could not be inserted
<A HREF=Admission.html> Click Here </A> to Try again !
<%
}
%>

</body>
</html>

Thanks & Regards
Sri Gnana
Everythings Programmed!...

 
Lalita Sattavat
Greenhorn
Posts: 10
posted 19 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
line 31 should be
sqltext="insert into AllIn (Name, Adnno, Class, Section, Date, Adnfee) values ('"+s1+"','"+s2+"','"+s3+"','"+s4+"','"+s5+"','"+s6+"' )";
 
Sri Gnana
Ranch Hand
Posts: 166
posted 19 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Hi
Lalita

Thanks,
I have tried it but its giving syntax error, help me please!...

Thanks & Regards
Sri Gnana
Everythings Programmed!...

 
Catalin Merfu
Ranch Hand
Posts: 42
posted 19 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
I believe the SQL statement is the problem:

"insert into AllIn ("Name, Adnno, Class, Section, Date, Adnfee") values ('"+s1+"','"+s2+"','"+s3+"','"+s4+"','"+s5+"','"+s6+"' ";

Try

"insert into AllIn (Name, Adnno, Class, Section, Date, Adnfee) values ('"+s1+"','"+s2+"','"+s3+"','"+s4+"','"+s5+"','"+s6+"' ";

I removed the "" for the column list (not needed).

Catalin Merfu<br /><a href="http://www.accendia.com" target="_blank" rel="nofollow">High Performance Java Networking</a>

 
Sri Gnana
Ranch Hand
Posts: 166
posted 19 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
I have tried it , now also i'm getting the same problem
Please help me

Thanks & Regards
Sri Gnana
Everythings Programmed!...

 
Sri Gnana
Ranch Hand
Posts: 166
posted 19 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Please ANy One Help Me!

Thanks & Regards
Sri Gnana
Everythings Programmed!...

 
Ivor Lithan
Greenhorn
Posts: 10
posted 19 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator


sqltext="insert into AllIn (Name, Adnno, Class, Section, Date, Adnfee) values ('"+s1+"','"+s2+"','"+s3+"','"+s4+"','"+s5+"','"+s6+"' )";



You say you get a syntax error when you do this - is that at compile time, or when you run it? - i.e. is it a sql sytnax error?

What url are you using to test it?
 
Bear Bibeault
Sheriff
Posts: 67747
173
I like...
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
posted 19 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
OK, it's clear at this point that is not a JSP issue but a JDBC syntax one. So I'm moving this to that forum.

But before you leave just let me interject that not abstracting database access out of the JSP is a serious crime against nature in my opinion.

[Asking smart questions] [About Bear] [Books by Bear]

 
Just the other day, I was thinking ... about this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
reply
    Bookmark Topic Watch Topic
  • New Topic
Boost this thread!
Similar Threads
More...