- About Us
- Board of Directors
- Careers
- Contact Us
- Content Partner Program
- Executive Management
- FAQ
- Founders
- Internships
- Lyrics Partner Program
- Patents
- Press Room
%@ page import="java.sql.*" %>
<%@ page errorPage="errorpage.jsp" %>
<%@ page import="java.util.*" %>
|
|||||||||||||||
|
|||||||||||||||
|
|||||||||||||||
|
"); } String dbUser = "dba"; String dbPasswd = "sql"; String dbURL = "jdbc:sybase:Tds:localhost:2638"; //connect Connection conn = null; try { conn = DriverManager.getConnection(dbURL,dbUser,dbPasswd); //out.println(" Connection status: " + conn + "
"); } catch(Exception e) { out.println("Connection failed: " + e.toString() + "
"); } Statement stmt = conn.createStatement(); ResultSet rs; */ String sql; // insert String value = request.getParameter("submit"); if(value!=null) { String username = request.getParameter("Login"); String email = request.getParameter("Email"); String pass1 = request.getParameter("Password1"); String pass2 = request.getParameter("Password2"); if((pass1.equals(pass2)) && (username!=null)) { sql = "INSERT INTO signup VALUES("+"'"+ username +"',"+"'"+ pass1 +"',"+"'"+ email +"')"; dbselect.executeQuery(sql); //response.sendRedirect("Signup_success.html"); %>
<% out.println(" You have sucessfully signed up as "+ username +" , thank you !!!"); %>
Click here to proceed to log on to your new account.
<% } else if (!(pass1.equals(pass2))) { %> <% //response.sendRedirect("SignUp.jsp"); } response.sendRedirect("/purejsp/Signup_success.html"); //RequestDispatcher.forward("Signup_success.html"); } /* //rs.close(); stmt.close(); //commit conn.commit(); //disconnect conn.close(); */ %>