Advertisement
Guest User

Untitled

a guest
Jan 14th, 2017
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.02 KB | None | 0 0
  1. import java.sql.Connection;
  2. import java.sql.DriverManager;
  3. import java.sql.SQLException;
  4.  
  5. public class conectionclass {
  6.  
  7. public static Connection getConnection(){
  8.  
  9. Connection conn = null ;
  10. try {
  11. Class.forName("com.mysql.jdbc.Driver");
  12. conn = DriverManager.getConnection( "jdbc:mysql://localhost:3306/emps","root", "12345" );
  13. System.out.println("------------- Connection Succesful ----------------");
  14. } catch (SQLException | ClassNotFoundException e) {
  15. // TODO Auto-generated catch block
  16. System.out.println("------------- Connection Fail ----------------");
  17.  
  18. e.printStackTrace();
  19. }
  20. return conn;
  21. }
  22.  
  23. }
  24.  
  25. @POST
  26. @Path("/postjson")
  27. @Produces("application/json")
  28. public Employee getJSONfromApp(HashMap p) {
  29.  
  30. return ( new empdao()).getEmployee("test", "1234") ;
  31.  
  32. }
  33.  
  34. @Override
  35. public Employee getEmployee(String employee, String pass) {
  36. int count = 0 ;
  37. Connection conn = Connectionclass.getConnection();
  38. // System.out.println("Employee : "+employee+" Connection : "+conn);
  39. if(employee!=null || employee != "" )
  40. {
  41. String query = "select * from emps where username = '"+employee+"' && pass = '"+pass+"' ";
  42. try {
  43. Statement stmt = conn.createStatement() ;
  44. System.out.println("Statement created.."+ stmt);
  45. ResultSet a = stmt.executeQuery(query);
  46.  
  47. while(a.next()){
  48. return (new Employee(a.getString(2) , a.getString(3) ));
  49. }
  50.  
  51. } catch (Exception e) {
  52. // TODO Auto-generated catch block
  53. System.out.println("Error in connection.....");
  54. // e.printStackTrace();
  55. } finally{
  56. try {
  57. conn.close();
  58. } catch ( Exception e) {
  59. System.out.println("Error in closing connection.....");
  60. // e.printStackTrace();
  61. }
  62.  
  63. }
  64.  
  65. }
  66.  
  67. return null;
  68. }
  69.  
  70. ------------- Connection Fail ----------------
  71. java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
  72. at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1305)
  73. at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1157)
  74. at java.lang.Class.forName0(Native Method)
  75. at java.lang.Class.forName(Class.java:259)
  76. at com.app.App3.Connectionclass.getConnection(Connectionclass.java:13)
  77. at com.app.App3.empdao.getEmployee(empdao.java:47)
  78. at com.mkyong.rest.JSONService.getJSONfromApp(JSONService.java:90)
  79. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  80. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  81. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  82. at java.lang.reflect.Method.invoke(Method.java:483)
  83. at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)
  84. at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:255)
  85. at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:220)
  86. at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:209)
  87. at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:519)
  88. at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:496)
  89. at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119)
  90. at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
  91. at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
  92. at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
  93. at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
  94. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
  95. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  96. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  97. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
  98. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  99. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
  100. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
  101. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
  102. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
  103. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
  104. at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)
  105. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
  106. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)
  107. at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091)
  108. at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:668)
  109. at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:223)
  110. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1517)
  111. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1474)
  112. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  113. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  114. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  115. at java.lang.Thread.run(Thread.java:744)
  116. Error in connection.....
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement