What does your code do if you remove the insertData.set calls?
> -----Original Message-----
> From: A mailing list about Java Server Pages specification and reference
> [mailto:[EMAIL PROTECTED]]On Behalf Of Ting Abbey
> Sent: Wednesday, July 05, 2000 3:09 PM
> To: [EMAIL PROTECTED]
> Subject: insert data
>
>
> Dear JSP guru(s),
>
> I am new to JSP. I have a problem and need your help. Thanks in advance!
> I try to get input from user and insert the data into Sybase db.
> I received no error but no user data is inserted into the db.
> Please help!
> Below are the codes for both the JSP & the bean:
>
> -----------JSP-------------------------------------------------------
> <html>
> <%@ page import = "dbPlay.UserInsertDataBean"%>
> <jsp:useBean id="insertData" scope="session"
> class="dbPlay.UserInsertDataBean"/>
> <jsp:setProperty name="insertData" property="*" />
> <body>
>
> <form method=get>
> Item <input type =text name=item><p>
> Quantity <input type = text name=quan><p>
> Unit Price <input type = text name=price><p>
> <input type=submit value="submit">
> </form>
>
> <% insertData.setItem(request.getParameter("item"));
> insertData.setQuan(request.getParameter("quan"));
> insertData.setPrice(request.getParameter("price"));
> insertData.doInsert();
> %>
>
> <%-- insertData.doInsert(); --%>
> </body>
> </html>
>
>
> -------------------bean----------------------------------------
> package dbPlay;
>
> import java.sql.*;
> import java.util.*;
> import com.sybase.jdbcx.SybDriver;
>
>
> public class UserInsertDataBean{
> String LItem;
> String Lquan;
> String Lprice;
>
> public UserInsertDataBean() {super();}
>
> public void setItem(String item){
> this.LItem = item;}
>
> public void setQuan(String quan){
> this.Lquan = quan;}
>
> public void setPrice(String price){
> this.Lprice = price;}
>
> public void doInsert()throws
> ClassNotFoundException, InstantiationException,
> IllegalAccessException{
> try{
>
> SybDriver sybDriver = (SybDriver)
> Class.forName("com.sybase.jdbc2.jdbc.SybDriver").newInstance();
>
> Properties SysProps = new Properties();
> SysProps.put("user","dbuser");
> SysProps.put("password","");
> String url = "jdbc:sybase:Tds:165.122.250.28:5000/stm";
> Connection con = DriverManager.getConnection(url,SysProps);
>
> Statement stmt = con.createStatement();
> stmt.executeUpdate("insert OfficeSupply values "+
> "(this.LItem,this.Lquan,this.Lprice,0)");
> con.close();}
> catch (SQLException e){
> e.getMessage();}
>
> }
> }
>
>
> -----------------------------end----------------------------------
> ----------
> ------
>
> ==================================================================
> =========
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
