Guest User

Untitled

a guest
Jan 12th, 2019
143
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.40 KB | None | 0 0
  1. Access denied when attempting to connect to mysql from servlet in myeclipse
  2. import java.io.IOException;
  3. import java.io.IOException;
  4. import java.io.PrintWriter;
  5. import java.sql.Connection;
  6. import java.sql.ResultSet;
  7. import java.sql.SQLException;
  8. import java.sql.Statement;
  9.  
  10. import javax.annotation.Resource;
  11. import javax.servlet.ServletException;
  12. import javax.servlet.http.HttpServlet;
  13. import javax.servlet.http.HttpServletRequest;
  14. import javax.servlet.http.HttpServletResponse;
  15. import javax.sql.DataSource;
  16.  
  17. public class EmployeeServlet extends HttpServlet {
  18. private static final long serialVersionUID = 1L;
  19.  
  20. @Resource(name = "jdbc/testDB")
  21. DataSource ds;
  22.  
  23. public EmployeeServlet() {
  24. super();
  25. }
  26.  
  27. public void doGet(HttpServletRequest request, HttpServletResponse response)
  28. throws ServletException, IOException {
  29. try {
  30. Connection con = ds.getConnection();
  31.  
  32. Statement stmt = con.createStatement();
  33. String query = "select * from Employee";
  34. ResultSet rs = stmt.executeQuery(query);
  35.  
  36. PrintWriter out = response.getWriter();
  37. response.setContentType("text/html");
  38. out.print("<center><h1>Employee Details</h1></center>");
  39. out.print("<html><body>");
  40. out.print("<table border="1" cellspacing=10 cellpadding=5>");
  41. out.print("<tr><th>Employee ID</th>");
  42. out.print("<th>Employee Name</th>");
  43. out.print("<th>Salary</th>");
  44. out.print("<th>Department</th></tr>");
  45.  
  46. while (rs.next()) {
  47. out.print("<tr>");
  48. out.print("<td>" + rs.getInt("emp_id") + "</td>");
  49. out.print("<td>" + rs.getString("emp_name") + "</td>");
  50. out.print("<td>" + rs.getDouble("salary") + "</td>");
  51. out.print("<td>" + rs.getString("dept_name") + "</td>");
  52. out.print("</tr>");
  53. }
  54. out.print("</table></body></html>");
  55. } catch (SQLException e) {
  56. e.printStackTrace();
  57. }
  58. }
  59.  
  60. public void doPost(HttpServletRequest request, HttpServletResponse response)
  61. throws ServletException, IOException {
  62. }
  63. }
  64.  
  65. <?xml version="1.0" encoding="UTF-8"?>
  66. <Context crossContext="true">
  67. <WatchedResource>WEB-INF/web.xml</WatchedResource>
  68. <Resource name="jdbc/testDB" auth="Container"
  69. type="javax.sql.DataSource"
  70. maxActive="100" maxIdle="30" maxWait="10000"
  71. username="root" password="root"
  72. driverClassName="com.mysql.jdbc.Driver"
  73. url="jdbc:mysql://localhost/mysql">
  74. </Context>
  75.  
  76. jdbc:mysql://localhost:<port>/mysql
Add Comment
Please, Sign In to add comment