Advertisement
Guest User

Untitled

a guest
Aug 8th, 2018
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.76 KB | None | 0 0
  1.  
  2. <%@page import="java.sql.PreparedStatement"%>
  3. <%@page import="java.sql.DriverManager"%>
  4. <%@page import="java.sql.Connection"%>
  5. <%
  6. String name=request.getParameter("n");
  7. String email=request.getParameter("em");
  8. String mobile=request.getParameter("mb");
  9. try{
  10. Class.forName("oracle.jdbc.driver.OracleDriver");
  11. Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","scott", "tiger");
  12. PreparedStatement ps=con.prepareStatement("insert into studinfo values(?,?,?)");
  13. ps.setString(1, name);
  14. ps.setString(2,email);
  15. ps.setString(3,mobile);
  16. int r=ps.executeUpdate();
  17. if(r>=1)
  18. out.print("1 record is inserted");
  19. con.close();
  20. }
  21.  
  22. catch (Exception e) {
  23. // TODO Auto-generated catch block
  24. e.printStackTrace();
  25. }
  26.  
  27.  
  28. %>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement