API tools faq
paste
Guest User

Untitled

a guest
Sep 10th, 2018
104
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.08 KB | None | 0 0
raw download clone embed print report
  1. cannot connect to database using jdbc
  2. import java.sql.Connection;
  3. import java.io.IOException;
  4. import java.io.PrintWriter;
  5. import javax.servlet.ServletException;
  6. import javax.servlet.http.HttpServlet;
  7. import javax.servlet.http.HttpServletRequest;
  8. import javax.servlet.http.HttpServletResponse;
  9. import javax.sql.*;
  10. import javax.servlet.*;
  11. import java.io.*;
  12. import java.sql.PreparedStatement;
  13. import java.sql.ResultSet;
  14. import java.sql.SQLException;
  15. import java.sql.Statement;
  16. import java.sql.Driver;
  17. import java.sql.DriverManager;
  18. import javax.servlet.http.HttpSession;
  19.  
  20.  
  21. public class Login extends HttpServlet {
  22.  
  23.  
  24. protected void processRequest(HttpServletRequest request, HttpServletResponse response)
  25. throws ServletException, IOException{
  26. response.setContentType("text/html;charset=UTF-8");
  27. PrintWriter out = response.getWriter();
  28. try {
  29. HttpSession session = request.getSession();
  30. Connection conn = null;
  31. PreparedStatement prepState = null;
  32. Statement state = null;
  33. ResultSet result = null;
  34. boolean login = false;
  35. String username = request.getParameter("username");
  36. String password = request.getParameter("password");
  37. String checkLogin = ("SELECT * FROM users WHERE username = ? AND password = ?");
  38.  
  39. try{
  40.  
  41. Class.forName("com.mysql.jdbc.Driver");
  42. conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/matrix","","");
  43.  
  44. prepState = conn.prepareStatement(checkLogin);
  45. prepState.setString(1, username);
  46. prepState.setString(2, password);
  47.  
  48. result = prepState.executeQuery();
  49.  
  50. login = result.next();
  51.  
  52. if(login){
  53. out.println("login");
  54. String id = result.getString(1);
  55. String getUser = ("SELECT empLastName, empFirstName FROM employees WHERE empID = ? ");
  56. prepState = conn.prepareStatement(getUser);
  57. prepState.setString(1, id);
  58. result = prepState.executeQuery();
  59. String first = result.getString(2);
  60. String last = result.getString(1);
  61.  
  62. out.println("<html>");
  63. out.println(first + " " + last);
  64. out.println("</html>");
  65. }
  66.  
  67.  
  68. }catch(Exception e){
  69. out.println("ERROR");
  70. e.printStackTrace(System.err);
  71. }
  72. }catch(Exception db){
  73.  
  74.  
  75. } finally {
  76. out.close();
  77. }
  78. }
  79.  
  80. INFO: The start() method was called on component [StandardEngine[Catalina].StandardHost[localhost].StandardContext[/Matrix]] after start() had already been called. The second call will be ignored.
  81. java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
  82. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
  83. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
  84. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
  85. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919)
  86. at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4004)
  87. at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1284)
  88. at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2312)
  89. at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2122)
  90. at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:774)
  91. at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:49)
  92. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  93. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
  94. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
  95. at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
  96. at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
  97. at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:375)
  98. at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:289)
  99. at java.sql.DriverManager.getConnection(DriverManager.java:582)
  100. at java.sql.DriverManager.getConnection(DriverManager.java:185)
  101. at Login.processRequest(Login.java:57)
  102. at Login.doPost(Login.java:119)
  103. at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
  104. at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
  105. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
  106. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  107. at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:393)
  108. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
  109. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  110. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
  111. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
  112. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:498)
  113. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
  114. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
  115. at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:562)
  116. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
  117. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:394)
  118. at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:243)
  119. at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:188)
  120. at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302)
  121. at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
  122. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
  123. at java.lang.Thread.run(Thread.java:662)
  124.  
  125. import java.sql.Connection;
  126. import java.sql.DriverManager;
  127. import java.sql.SQLException;
  128. import javax.servlet.ServletContext;
  129. import javax.servlet.ServletContextEvent;
  130. import javax.servlet.ServletContextListener;
  131.  
  132. /**
  133. * Web application lifecycle listener.
  134. * @author Acer
  135. */
  136. public class StartupListener implements ServletContextListener {
  137. private Connection dbconn;
  138.  
  139. // this method gets called when the application is started up..
  140. public void contextInitialized(ServletContextEvent sce) {
  141. // obtain a reference to the context..
  142. ServletContext context = sce.getServletContext();
  143.  
  144. // retrieve context initialization parameters defined in the web.xml file..
  145. String driverName = context.getInitParameter("driverName");
  146. String connURL = context.getInitParameter("connURL");
  147.  
  148. try {
  149. // open connection to database..
  150. Class.forName(driverName);
  151. dbconn = DriverManager.getConnection(connURL);
  152.  
  153. // expose database connection as a context scope object..
  154. context.setAttribute("dbconn", dbconn);
  155. } catch (Exception e) {
  156. // application startup will fail if this method throws an exception..
  157. throw new RuntimeException("Web application startup failed. Cannot open database connection.");
  158. }
  159. }
  160.  
  161. // this method gets called when the application is shut down..
  162. public void contextDestroyed(ServletContextEvent sce) {
  163. // close the previously opened database connection..
  164. if (dbconn != null) {
  165. try {
  166. dbconn.close();
  167. } catch (SQLException e) {
  168. }
  169. }
  170. }
  171. }
  172.  
  173. Class.forName("com.mysql.jdbc.Driver");
  174. conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/matrix","root","");
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!