📝 회원 목록 조회
💡 VS Code
🔎 index.jsp
...
<h3>회원 목록 조회</h3>
<p>일정 시간 마다 비동기로 회원 목록(회원 번호, 이메일, 닉네임) 조회</p>
<table border="1">
<thead>
<tr>
<th>회원 번호</th>
<th>이메일</th>
<th>닉네임</th>
</tr>
</thead>
<tbody id="memberList">
<tr>
<td>1</td>
<td>user01@kh.or.kr</td>
<td>유저일</td>
</tr>
<tr>
<td>2</td>
<td>user02@kh.or.kr</td>
<td>유저이</td>
</tr>
<tr>
<td>3</td>
<td>user03@kh.or.kr</td>
<td>유저삼</td>
</tr>
</tbody>
</table>
...
🔎 main.js
function selectAll(){
$.ajax({
url : "member/selectAll",
dataType : "json",
success : function(list){
const memberList = document.getElementById("memberList");
memberList.innerText = "";
for(let item of list){
const tr = document.createElement("tr");
const td1 = document.createElement("td");
td1.innerText = item.memberNo;
const td2 = document.createElement("td");
td2.innerText = item.memberEmail;
const td3 = document.createElement("td");
td3.innerText = item.memberNickname;
tr.append(td1, td2, td3);
memberList.append(tr);
}
},
error : function(){
console.log("에러 발생");
}
});
}
(function(){
selectAll();
window.setInterval(selectAll, 10000);
})();
💡 Eclipse
🔎 selectAllServlet.java
package edu.kh.community.member.controller;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.google.gson.Gson;
import edu.kh.community.member.model.service.MemberService;
import edu.kh.community.member.model.vo.Member;
@WebServlet("/member/selectAll")
public class selectAllServlet extends HttpServlet {
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
try {
MemberService service = new MemberService();
List<Member> list = service.selectAll();
new Gson().toJson(list, resp.getWriter());
}catch(Exception e) {
e.printStackTrace();
}
}
}
🔎 MemberService.java
public List<Member> selectAll() throws Exception{
Connection conn = getConnection();
List<Member> list = dao.selectAll(conn);
close(conn);
return list;
}
🔎 MemberDAO.java
public List<Member> selectAll(Connection conn) throws Exception{
List<Member> list = new ArrayList<>();
try {
String sql = prop.getProperty("selectAll");
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
while(rs.next()) {
Member mem = new Member();
mem.setMemberNo( rs.getInt(1) );
mem.setMemberEmail( rs.getString(2) );
mem.setMemberNickname( rs.getString(3) );
list.add(mem);
}
} finally {
close(rs);
close(stmt);
}
return list;
}
🔎 member-sql.xml
<entry key="selectAll">
SELECT MEMBER_NO, MEMBER_EMAIL, MEMBER_NICK
FROM MEMBER
WHERE SECESSION_FL = 'N'
ORDER BY MEMBER_NO
</entry>
💡 출력 화면