Guest User

abcdefghitr

a guest
Aug 30th, 2017
23
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. try{
  2. Class.forName("oracle.jdbc.driver.OracleDriver");
  3. Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","hr","hr");
  4. PreparedStatement pstmt = con.prepareStatement("insert into bill_master values (?,?,?)");
  5. bno = Integer.parseInt(request.getParameter("billno"));
  6. name = request.getParameter("cust_name");
  7. amt = Integer.parseInt(request.getParameter("amt"));
  8. pstmt.setInt(1, bno);
  9. pstmt.setString(2, name);
  10. pstmt.setInt(3, amt);
  11. int i = pstmt.executeUpdate();
  12. con.commit();
  13. System.out.println("Record added successfully.");
  14.  
  15. }catch(Exception e){
  16. System.out.println("Sorry");
  17. }
Add Comment
Please, Sign In to add comment