Advertisement
Guest User

Untitled

a guest
Mar 11th, 2016
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.86 KB | None | 0 0
  1. <script type="text/javascript">
  2. <%!
  3. public class AddEvent {
  4. String strHost = "jdbc:mysql://localhost:3306/databaseName";
  5. String strUserName = "username";
  6. String strPass = "password";
  7.  
  8. Connection con = null;
  9. PreparedStatement stmAddEvent = null;
  10. ResultSet rslResult = null;
  11.  
  12. public AddEvent(){
  13. try {
  14. con = DriverManager.getConnection(strHost, strUserName, strPass);
  15. stmAddEvent = con.prepareStatement(
  16. "SELECT * FROM `tableName`");
  17. } catch (SQLException e){
  18. e.printStackTrace();
  19. }
  20. }
  21.  
  22. public ResultSet displayEvent() {
  23. try {
  24. rslResult = stmAddEvent.executeQuery();
  25. } catch (SQLException e){
  26. e.printStackTrace();
  27. }
  28. return rslResult;
  29. }
  30. }
  31. %>
  32. </script>
  33.  
  34. <script type="text/javascript">
  35. <%
  36. AddEvent addEvent = new AddEvent();
  37. ResultSet rslResult = addEvent.displayEvent();
  38. %>
  39. </script>
  40.  
  41. <table border="1">
  42. <tbody>
  43. <tr>
  44. <td>ID: </td>
  45. <td>Name: </td>
  46. </tr>
  47. <script type="text/javascript">
  48. <% while (rslResult.next()){ %>
  49. </script>
  50. <tr>
  51. <td><script type="text/javascript"> <%= rslResult.getInt("column1") %> </script></td>
  52. <td><script type="text/javascript"> <%= rslResult.getString("column2") %> </script></td>
  53. </tr>
  54. <script type="text/javascript">
  55. <% } %>
  56. </script>
  57. </tbody>
  58. </table>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement