Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- index.jsp:
- package com.example.saeid;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- public class LoginCheck {
- static Boolean isadmin = false;
- public static boolean validate(String name, int pass) {
- boolean isValid = false;
- Connection conn = null;
- ResultSet rs = null;
- String db_userName = "root";
- String db_Password = "uyhgbv098";
- String db_Name = "my_demo_database";
- String driver = "com.mysql.jdbc.Driver";
- String url = "jdbc:mysql://localhost:3306/";
- PreparedStatement ps = null;
- try {
- Class.forName(driver);
- conn = DriverManager.getConnection(url+db_Name,db_userName,db_Password);
- ps =conn.prepareStatement
- ("select * from user_account where username=? and password=?");
- ps.setString(1, name);
- ps.setInt(2, pass);
- rs = ps.executeQuery();
- if(rs.next()) {
- isValid = true;
- isadmin = rs.getBoolean("isadmin");
- }
- }catch (Exception e) {
- System.out.println(e);
- } finally {
- if (conn != null) {
- try {
- conn.close();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- if (ps != null) {
- try {
- ps.close();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- if (rs != null) {
- try {
- rs.close();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- }
- return isValid;
- }
- public static Boolean admin(){
- return isadmin;
- }
- }
- package com.example.saeid;
- import java.io.IOException;
- import javax.servlet.RequestDispatcher;
- import javax.servlet.ServletException;
- import javax.servlet.http.HttpServlet;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
- import javax.servlet.http.HttpSession;
- import java.io.PrintWriter;
- import com.example.saeid.LoginCheck;
- public class LoginServlet extends HttpServlet{
- private static final long serialVersionUID = 1L;
- public void doPost(HttpServletRequest request, HttpServletResponse response)
- throws ServletException, IOException {
- response.setContentType("text/html");
- PrintWriter out = response.getWriter();
- String n=request.getParameter("username");
- String p=request.getParameter("userpass");
- int p2 = Integer.parseInt(p);
- HttpSession session = request.getSession(false);
- if(session!=null)
- session.setAttribute("name", n);
- if(LoginCheck.validate(n, p2)){
- if(LoginCheck.admin()){
- RequestDispatcher rd=request.getRequestDispatcher("welcome.jsp");
- rd.forward(request,response);
- }
- else{
- RequestDispatcher rd=request.getRequestDispatcher("NewFile.jsp");
- rd.forward(request,response);
- }
- }
- else{
- out.print("<p style="color:red">Sorry username or password error</p>");
- RequestDispatcher rd=request.getRequestDispatcher("index.jsp");
- rd.include(request,response);
- }
- out.close();
- }
- }
- package com.example.saeid;
- import java.io.*;
- import javax.servlet.*;
- import javax.servlet.http.*;
- import java.sql.*;
- public class Register extends HttpServlet {
- private static final long serialVersionUID = 1L;
- protected void doPost(HttpServletRequest request, HttpServletResponse response)
- throws ServletException, IOException {
- response.setContentType("text/html;charset=UTF-8");
- PrintWriter out = response.getWriter();
- String name = request.getParameter("name");
- String pass = request.getParameter("pass");
- String email = request.getParameter("email");
- try{
- //loading drivers for mysql
- Class.forName("com.mysql.jdbc.Driver");
- //creating connection with the database
- String db_userName = "root";
- String db_Password = "uyhgbv098";
- String url = "jdbc:mysql://localhost:3306/";
- String db_Name = "my_demo_database";
- Connection con=DriverManager.getConnection
- (url+db_Name,db_userName,db_Password);
- PreparedStatement ps=con.prepareStatement
- ("insert into user_acount values(?,?,?)");
- ps.setString(1, name);
- ps.setString(2, email);
- ps.setString(3, pass);
- int i=ps.executeUpdate();
- if(i>0)
- {
- out.println("You are sucessfully registered");
- }
- }
- catch(Exception se)
- {
- se.printStackTrace();
- }
- }
- }
- </servlet-mapping>
- <servlet>
- <servlet-name>register</servlet-name>
- <servlet-class>Register</servlet-class> // give the full path
- </servlet>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement