New Topic/Question
Reply
i try to insert data into oracle database from a text box but i got error
my code is
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.ServletException;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
public class pos1 extends HttpServlet{
PrintWriter out = null;
Connection con = null;
ResultSet rs;
Statement Statement;
PreparedStatement ps;
private static final long serialVersionUID = 1L;
public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException{
try{
PrintWriter out = response.getWriter();
response.setContentType("text/html");
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@sanguine:1521:sanguine","retail","retail");
Statement = con.createStatement();
out.println("<!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN'><html><head><title>Add New Product</title>");
out.println("<meta http-equiv='Content-Type' content='text/html; charset=ISO-8859-1'>");
out.println("<link rel='STYLESHEET' href='mystyle.css' type='text/css'>");
out.println("<body><center><form name='form1' method='get'>");
out.println("<table border='0' cellspacing='2' cellpadding='2'><thead><tr><th colspan='2'>NEW ENTIRES</th></tr></thead>");
out.println("<tr> <td height='20'> </td> </tr><tr>");
out.println("<td><label>NewBillno</label></td><td><input type='text' name='plu'></td></tr>");
out.println("<tr><td><label>Itemcount</label> </td><td><input type='text' name='upc'></td></tr>");
out.println("<tr><td> Prd_Id_Plu </td><td> <input type='text' name='desc'> </td></tr>");
out.println("<tr><td> Price </td><td> <select < name='price'>");
try{
PreparedStatement ps = con.prepareStatement("select price from price_master");
rs = ps.executeQuery();
while(rs.next()){
out.println("<option>"+rs.getString(1).toString()+"</option>");
}
}catch(SQLException sql){
sql.printStackTrace();
}
out.println("</select> </td></tr>");
out.println("<tr><td> Qty </td><td> <input type='text' name='cat'> </td></tr>");
out.println("<tr><td> Tax Id </td><td> <select name='tax'>");
try{
PreparedStatement ps = con.prepareStatement("select tax_name from tax");
rs = ps.executeQuery();
while(rs.next()){
out.println("<option>"+rs.getString(1).toString()+"</option>");
}
}catch(SQLException sql){
sql.printStackTrace();
}
out.println("</select> </td></tr>");
out.println("<tr><td><label>Amount</label> </td><td><input type='text' name='lvl'></td></tr>");
out.println("<tr> <td height='20'> </td> </tr><tr><td align='right'> <input type='submit' name='save' value='Save' style='width:70;height:30;' onclick='insert()' class='button'> </td>");
out.println("<td align='center'> <input type='reset' name='cancel' value='Cancel' style='width:70;height:30;' class='button'> </td> </tr></table>");
con.setAutoCommit(false);
String str = "insert into trans_details values(?,?,?,?,?,?,?)";
ps = con.prepareStatement(str);
int pid = Integer.parseInt(request.getParameter("plu"));
int p = Integer.parseInt(request.getParameter("upc"));
int tax = Integer.parseInt(request.getParameter("desc"));
int lvl = Integer.parseInt(request.getParameter("price"));
int l = Integer.parseInt(request.getParameter("cat"));
int r = Integer.parseInt(request.getParameter("tax"));
int o = Integer.parseInt(request.getParameter("lvl"));
ps.setInt(1,pid);
ps.setInt(2,p);
ps.setInt(3,tax);
ps.setInt(4,lvl);
ps.setInt(5,l);
ps.setInt(6,r);
ps.setInt(7,o);
ps.executeUpdate();
out.println("</form></body></html>");
} catch (ClassNotFoundException e) {
out.println("Driver Error");
} catch (SQLException e) {
out.println("SQLException: " +
e.getMessage());
}
}
}
edit: added code tags PB
when i press submit button watever u enter into the texbox that will be stored in daztabse that is my requirment
pls can any one help
it is very urgent pls pls
thanks in advance
This post has been edited by sunitha: 22 January 2008 - 02:44 AM
MultiQuote
| 