Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <%--
- Document : register1
- Created on : Sep 3, 2015, 3:21:27 AM
- Author : kbp
- --%>
- <%@page contentType="text/html" import="java.sql.*;" pageEncoding="UTF-8"%>
- <!DOCTYPE html>
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
- <title>JSP Page</title>
- </head>
- <body>
- <%
- String username=request.getParameter("t1");
- String password=request.getParameter("t2");
- String firstname=request.getParameter("t3");
- String lastname=request.getParameter("t4");
- String email=request.getParameter("t5");
- try{
- Class.forName("oracle.jdbc.driver.OracleDriver");
- Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","system","tiger");
- PreparedStatement ps=con.prepareStatement("insert into reg values(?,?,?,?,?)");
- ps.setString(1,username);
- ps.setString(2,password);
- ps.setString(3,firstname);
- ps.setString(4,lastname);
- ps.setString(5,email);
- ps.executeUpdate();
- out.println("Registration Done!!");
- }
- catch(Exception e)
- {
- out.println("Error"+e);
- }
- %>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement