list.jsp

<list.jsp>

       <script type="text/javascript">

        function createRequestObject(){ //ini gw coba2, cma ga ngerti artinya :D
            var ro;
            var browser = navigator.appName;
            if(browser == "Microsoft Internet Explorer"){
                ro = new ActiveXObject ("Microsoft.XMLHTTP");
            }else{
                ro = new XMLHttpRequest();
            }
            return ro;
        }

        var http =createRequestObject();

        function overlay() {
        el = document.getElementById("overlay");
	el.style.visibility = (el.style.visibility == "visible") ? "hidden" : "visible";
        }
        </script>

    <body>
        <div id="header">
            <div class="wrap">STMIK JAYAKARTA</div>
        </div>
        <div id="content">
            <div class="content_list">
        <a href="index.jsp">Tambah Data</a>
        <table class="list">
            <tr>
                <th>Username</th>
                <th>Tanggal Lahir</th>
                <th>Jenis Kelamin</th>
                <th>Hobi</th>
                <th>Jurusan</th>
                <th>Komentar</th>
                <th>Action</th>
            </tr>
        <%
        try {
            String connectionURL = "jdbc:mysql://localhost:3306/mahasiswa";
            String user_db = "root";
            String pwd_db = "";
            Class.forName("com.mysql.jdbc.Driver");
            Connection connection = DriverManager.getConnection(connectionURL,user_db,pwd_db);
            Statement stm = connection.createStatement();

            String sql="SELECT username,tanggal_lahir,jenis_kelamin,"
                    + "hobi,jurusan,komentar FROM master_member";

            ResultSet rs = stm.executeQuery(sql);

            while (rs.next()){
          %>
                 <tr>
                     <td><%=rs.getString("username")%></td>
                     <td><%=rs.getString("tanggal_lahir")%></td>
                     <td><%=rs.getString("jenis_kelamin")%></td>
                     <td><%=rs.getString("hobi")%></td>
                     <td><%=rs.getString("jurusan")%></td>
                     <td><%=rs.getString("komentar")%></td>
                     <td><a href="edit.jsp?id=<%=rs.getString("username")%>" onclick="overlay()">Edit</a> |
                         <a href="hapus.jsp?id=<%=rs.getString("username")%>" onclick="return confirm ('Hapus?')">Hapus</a>
                     </td>
                 </tr>
            <%
                }
            }
            catch(SQLException se){
            out.println("Error Occured" +se.getMessage());
            }
            %>
        </table>
            </div>
        </div>
        <div id="overlay">
            //ini tempat bwt page edit.jsp
        </div> <!--End of overlay-->