Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <script type="text/javascript">
- <%!
- public class AddEvent {
- String strHost = "jdbc:mysql://localhost:3306/databaseName";
- String strUserName = "username";
- String strPass = "password";
- Connection con = null;
- PreparedStatement stmAddEvent = null;
- ResultSet rslResult = null;
- public AddEvent(){
- try {
- con = DriverManager.getConnection(strHost, strUserName, strPass);
- stmAddEvent = con.prepareStatement(
- "SELECT * FROM `tableName`");
- } catch (SQLException e){
- e.printStackTrace();
- }
- }
- public ResultSet displayEvent() {
- try {
- rslResult = stmAddEvent.executeQuery();
- } catch (SQLException e){
- e.printStackTrace();
- }
- return rslResult;
- }
- }
- %>
- </script>
- <script type="text/javascript">
- <%
- AddEvent addEvent = new AddEvent();
- ResultSet rslResult = addEvent.displayEvent();
- %>
- </script>
- <table border="1">
- <tbody>
- <tr>
- <td>ID: </td>
- <td>Name: </td>
- </tr>
- <script type="text/javascript">
- <% while (rslResult.next()){ %>
- </script>
- <tr>
- <td><script type="text/javascript"> <%= rslResult.getInt("column1") %> </script></td>
- <td><script type="text/javascript"> <%= rslResult.getString("column2") %> </script></td>
- </tr>
- <script type="text/javascript">
- <% } %>
- </script>
- </tbody>
- </table>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement