Hello, I think there is an error in your sql string. In my database (postgres) I do not need the semicolon at the end of the sql string. And for testing you should output your string, so you can see if there are other errors. Most errors are missing whitespaces or missing quotes. Bye, Susanne -----Urspr�ngliche Nachricht----- Von: layyong [SMTP:[EMAIL PROTECTED]] Gesendet am: Donnerstag, 16. August 2001 10:38 An: [EMAIL PROTECTED] Betreff: Re: How to store data into JDBC-ODBC database? have u created the link?!! i mean in the ODBS?!! --- Jiming Wu <[EMAIL PROTECTED]> wrote: > Hi Everyone, > > I got problem to store data into JDBC-ODBC database > through servlet. > The servlet works but the data can not be stored > into > the database. I got error message from the servlet > all > the time. > Can you tell me why? > The original java, html code and the database are > attached. > Thanks for your help. > > > > __________________________________________________ > Do You Yahoo!? > Make international calls for as low as $.04/minute > with Yahoo! Messenger > http://phonecard.yahoo.com/> // Fig. 19.16: GuestBookServlet.java > // Three-Tier Example > import java.io.*; > import javax.servlet.*; > import javax.servlet.http.*; > import java.util.*; > import java.sql.*; > > public class GuestBookServlet extends HttpServlet { > private Statement statement = null; > private Connection connection = null; > private String URL = "jdbc:odbc:GuestBook"; > > public void init( ServletConfig config ) > throws ServletException > { > super.init( config ); > > try { > Class.forName( > "sun.jdbc.odbc.JdbcOdbcDriver" ); > connection = > DriverManager.getConnection( URL, "", "" > ); > } > catch ( Exception e ) { > e.printStackTrace(); > connection = null; > } > } > > public void doPost( HttpServletRequest req, > HttpServletResponse res ) > throws ServletException, IOException > { > String email, firstName, lastName, company, > snailmailList, cppList, javaList, > vbList, > iwwwList; > > email = req.getParameter( "Email" ); > firstName = req.getParameter( "FirstName" ); > lastName = req.getParameter( "LastName" ); > company = req.getParameter( "Company" ); > snailmailList = req.getParameter( "mail" ); > cppList = req.getParameter( "c_cpp" ); > javaList = req.getParameter( "java" ); > vbList = req.getParameter( "vb" ); > iwwwList = req.getParameter( "iwww" ); > > PrintWriter output = res.getWriter(); > res.setContentType( "text/html" ); > > if ( email.equals( "" ) || > firstName.equals( "" ) || > lastName.equals( "" ) ) { > output.println( "<H3> Please click the back > " + > "button and fill in all " + > "fields.</H3>" ); > output.close(); > return; > } > > /* Note: The GuestBook database actually > contains fields > * Address1, Address2, City, State and Zip > that are not > * used in this example. However, the insert > into the > * database must still account for these > fields. */ > boolean success = insertIntoDB( > "'" + email + "','" + firstName + "','" + > lastName + > "','" + company + "',' ',' ',' ',' ',' ','" > + > ( snailmailList != null ? "yes" : "no" ) + > "','" + > ( cppList != null ? "yes" : "no" ) + "','" > + > ( javaList != null ? "yes" : "no" ) + > "','" + > ( vbList != null ? "yes" : "no" ) + "','" > + > ( iwwwList != null ? "yes" : "no" ) + "'" > ); > > if ( success ) > output.print( "<H2>Thank you " + firstName > + > " for registering.</H2>" ); > else > output.print( "<H2>An error occurred. " + > "Please try again > later.</H2>" ); > > output.close(); > } > > private boolean insertIntoDB( String > stringtoinsert ) > { > try { > statement = connection.createStatement(); > statement.execute( > "INSERT INTO GuestBook values (" + > stringtoinsert + ");" ); > statement.close(); > } > catch ( Exception e ) { > System.err.println( > "ERROR: Problems with adding new entry" > ); > e.printStackTrace(); > return false; > } > > return true; > } > > public void destroy() > { > try { > connection.close(); > } > catch( Exception e ) { > System.err.println( "Problem closing the > database" ); > } > } > } > > /************************************************************************** > * (C) Copyright 1999 by Deitel & Associates, Inc. > and Prentice Hall. * > * All Rights Reserved. > * > * > * > * DISCLAIMER: The authors and publisher of this > book have used their * > * best efforts in preparing the book. These efforts > include the * > * development, research, and testing of the > theories and programs * > * to determine their effectiveness. The authors and > publisher make * > * no warranty of any kind, expressed or implied, > with regard to these * > * programs or to the documentation contained in > these books. The authors * > * and publisher shall not be liable in any event > for incidental or * > * consequential damages in connection with, or > arising out of, the * > * furnishing, performance, or use of these > programs. * > *************************************************************************/ <HR> <!-- Fig. 19.17: GuestBookForm.html --> <HTML> <HEAD> <TITLE>Deitel Guest Book Form</TITLE> </HEAD> <BODY> <H1>Guest Book</H1> <FORM ACTION=http://localhost:8080/servlet/GuestBookServlet METHOD=POST><PRE> * Email address: <INPUT TYPE=text NAME=Email> * First Name: <INPUT TYPE=text NAME=FirstName> * Last name: <INPUT TYPE=text NAME=LastName> Company: <INPUT TYPE=text NAME=Company> * fields are required </PRE> <P>Select mailing lists from which you want to receive information<BR> <INPUT TYPE=CHECKBOX NAME=mail VALUE=mail> Snail Mail<BR> <INPUT TYPE=CHECKBOX NAME=c_cpp VALUE=c_cpp> <I>C++ How to Program & C How to Program</I><BR> <INPUT TYPE=CHECKBOX NAME=java VALUE=java> <I>Java How to Program</I><BR> <INPUT TYPE=CHECKBOX NAME=vb VALUE=vb> <I>Visual Basic How to Program</I><BR> <INPUT TYPE=CHECKBOX NAME=iwww VALUE=iwww> <I>Internet and World Wide Web How to Program</I><BR> </P> <INPUT TYPE=SUBMIT Value="Submit"> </FORM> </BODY> </HTML> __________________________________________________ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
