Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try{
- Class.forName("oracle.jdbc.driver.OracleDriver");
- Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","hr","hr");
- PreparedStatement pstmt = con.prepareStatement("insert into bill_master values (?,?,?)");
- bno = Integer.parseInt(request.getParameter("billno"));
- name = request.getParameter("cust_name");
- amt = Integer.parseInt(request.getParameter("amt"));
- pstmt.setInt(1, bno);
- pstmt.setString(2, name);
- pstmt.setInt(3, amt);
- int i = pstmt.executeUpdate();
- con.commit();
- System.out.println("Record added successfully.");
- }catch(Exception e){
- System.out.println("Sorry");
- }
Add Comment
Please, Sign In to add comment