Advertisement
Guest User

Untitled

a guest
Apr 22nd, 2017
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.92 KB | None | 0 0
  1. index.jsp:
  2.  
  3. package com.example.saeid;
  4.  
  5.  
  6. import java.sql.Connection;
  7. import java.sql.DriverManager;
  8. import java.sql.PreparedStatement;
  9. import java.sql.ResultSet;
  10. import java.sql.SQLException;
  11.  
  12. public class LoginCheck {
  13. static Boolean isadmin = false;
  14. public static boolean validate(String name, int pass) {
  15. boolean isValid = false;
  16. Connection conn = null;
  17. ResultSet rs = null;
  18. String db_userName = "root";
  19. String db_Password = "uyhgbv098";
  20. String db_Name = "my_demo_database";
  21. String driver = "com.mysql.jdbc.Driver";
  22. String url = "jdbc:mysql://localhost:3306/";
  23. PreparedStatement ps = null;
  24. try {
  25. Class.forName(driver);
  26. conn = DriverManager.getConnection(url+db_Name,db_userName,db_Password);
  27. ps =conn.prepareStatement
  28. ("select * from user_account where username=? and password=?");
  29. ps.setString(1, name);
  30. ps.setInt(2, pass);
  31. rs = ps.executeQuery();
  32. if(rs.next()) {
  33. isValid = true;
  34. isadmin = rs.getBoolean("isadmin");
  35. }
  36.  
  37.  
  38. }catch (Exception e) {
  39. System.out.println(e);
  40. } finally {
  41. if (conn != null) {
  42. try {
  43. conn.close();
  44. } catch (SQLException e) {
  45. e.printStackTrace();
  46. }
  47. }
  48. if (ps != null) {
  49. try {
  50. ps.close();
  51. } catch (SQLException e) {
  52. e.printStackTrace();
  53. }
  54. }
  55. if (rs != null) {
  56. try {
  57. rs.close();
  58. } catch (SQLException e) {
  59. e.printStackTrace();
  60. }
  61. }
  62. }
  63. return isValid;
  64. }
  65.  
  66. public static Boolean admin(){
  67. return isadmin;
  68. }
  69. }
  70.  
  71. package com.example.saeid;
  72.  
  73. import java.io.IOException;
  74. import javax.servlet.RequestDispatcher;
  75. import javax.servlet.ServletException;
  76. import javax.servlet.http.HttpServlet;
  77. import javax.servlet.http.HttpServletRequest;
  78. import javax.servlet.http.HttpServletResponse;
  79. import javax.servlet.http.HttpSession;
  80. import java.io.PrintWriter;
  81.  
  82. import com.example.saeid.LoginCheck;
  83.  
  84.  
  85.  
  86.  
  87. public class LoginServlet extends HttpServlet{
  88.  
  89. private static final long serialVersionUID = 1L;
  90.  
  91. public void doPost(HttpServletRequest request, HttpServletResponse response)
  92. throws ServletException, IOException {
  93.  
  94. response.setContentType("text/html");
  95. PrintWriter out = response.getWriter();
  96.  
  97. String n=request.getParameter("username");
  98. String p=request.getParameter("userpass");
  99. int p2 = Integer.parseInt(p);
  100.  
  101. HttpSession session = request.getSession(false);
  102. if(session!=null)
  103. session.setAttribute("name", n);
  104.  
  105. if(LoginCheck.validate(n, p2)){
  106. if(LoginCheck.admin()){
  107. RequestDispatcher rd=request.getRequestDispatcher("welcome.jsp");
  108. rd.forward(request,response);
  109. }
  110. else{
  111. RequestDispatcher rd=request.getRequestDispatcher("NewFile.jsp");
  112.  
  113. rd.forward(request,response);
  114.  
  115. }
  116.  
  117. }
  118. else{
  119. out.print("<p style="color:red">Sorry username or password error</p>");
  120. RequestDispatcher rd=request.getRequestDispatcher("index.jsp");
  121. rd.include(request,response);
  122. }
  123.  
  124. out.close();
  125. }
  126. }
  127.  
  128. package com.example.saeid;
  129.  
  130. import java.io.*;
  131. import javax.servlet.*;
  132. import javax.servlet.http.*;
  133. import java.sql.*;
  134.  
  135. public class Register extends HttpServlet {
  136. private static final long serialVersionUID = 1L;
  137.  
  138. protected void doPost(HttpServletRequest request, HttpServletResponse response)
  139. throws ServletException, IOException {
  140. response.setContentType("text/html;charset=UTF-8");
  141. PrintWriter out = response.getWriter();
  142.  
  143. String name = request.getParameter("name");
  144. String pass = request.getParameter("pass");
  145. String email = request.getParameter("email");
  146. try{
  147.  
  148. //loading drivers for mysql
  149. Class.forName("com.mysql.jdbc.Driver");
  150.  
  151. //creating connection with the database
  152. String db_userName = "root";
  153. String db_Password = "uyhgbv098";
  154. String url = "jdbc:mysql://localhost:3306/";
  155. String db_Name = "my_demo_database";
  156. Connection con=DriverManager.getConnection
  157. (url+db_Name,db_userName,db_Password);
  158.  
  159. PreparedStatement ps=con.prepareStatement
  160. ("insert into user_acount values(?,?,?)");
  161.  
  162. ps.setString(1, name);
  163. ps.setString(2, email);
  164. ps.setString(3, pass);
  165. int i=ps.executeUpdate();
  166.  
  167. if(i>0)
  168. {
  169. out.println("You are sucessfully registered");
  170. }
  171.  
  172. }
  173. catch(Exception se)
  174. {
  175. se.printStackTrace();
  176. }
  177.  
  178. }
  179. }
  180.  
  181. </servlet-mapping>
  182.  
  183. <servlet>
  184. <servlet-name>register</servlet-name>
  185. <servlet-class>Register</servlet-class> // give the full path
  186. </servlet>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement