Model1 Architecture

2019. 8. 3. 20:32

1. 홈화면

1) WebContent - index.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Model1 Architecture</title> </head> <body> <h3>Model1 Architecture</h3> <p>Model1 JSP 파일 내에서 view와 컨트롤러 모두 실행되는 구조</p> <img src="model1.jpg"/> <ul> <li> <a href="allMemberCount.jsp">전체 회원수 보기</a> </li> <li> <form action="findMemberListByname.jsp"> 이름<input type="text" name="name" required="required"> <input type="submit" value="검색"> </form> </li> </ul> </body> </html>

- 12번 째 줄 이미지

[이미지 출처] https://www.javatpoint.com/model-1-and-model-2-mvc-architecture

2) src - loader.DbDriverLoader.java

package loader; import javax.servlet.ServletContextEvent; import javax.servlet.ServletContextListener; import javax.servlet.annotation.WebListener; @WebListener public class DbDriverLoader implements ServletContextListener{ public DbDriverLoader() { } public void contextDestroyed(ServletContextEvent sce) { } public void contextInitialized(ServletContextEvent event) { try { Class.forName("org.mariadb.jdbc.Driver"); System.out.println("db driver loading..."); } catch (ClassNotFoundException e) { e.printStackTrace(); } } }

3) src - model.MemberVO.jsp

package model; public class MemberVO { private String id; private String name; private String email; public MemberVO(String id, String name, String email) { super(); this.id = id; this.name = name; this.email = email; } public String getId() { return id; } public void setId(String id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getEmail() { return email; } public void setEmail(String email) { this.email = email; } @Override public String toString() { return "MemberVO [id=" + id + ", name=" + name + ", email=" + email + "]"; } }

4) src - model.MemberDAO.java

package model; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; // Singleton Design Pattern 적용 public class MemberDAO { //singleton private static MemberDAO instance=new MemberDAO(); private MemberDAO() {} public static MemberDAO getInstance() { return instance; } //db connection public Connection getConnection() throws SQLException{ return DriverManager.getConnection("jdbc:mysql://localhost:3306/study_db","study_user","user"); } public void closeAll(PreparedStatement pstmt,Connection con) throws SQLException{ if(pstmt!=null) pstmt.close(); if(con!=null) con.close(); } public void closeAll(ResultSet rs,PreparedStatement pstmt,Connection con) throws SQLException{ if(rs!=null) rs.close(); closeAll(pstmt,con); } }

2. 전체 회원수

1) WebContent - allMemberCount.jsp

<%@ page import="model.MemberDAO" %> <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>model1 전체 회원수</title> </head> <body> <% MemberDAO dao=MemberDAO.getInstance(); %> 총회원수:<%=dao.getMemberCount() %> 명 </body> </html>

2) src - model.MemberDAO.java

//회원수 전체를 가져오는 메소드 public int getMemberCount() throws SQLException{ int count=0; Connection con=null; ResultSet rs=null; PreparedStatement pstmt=null; try { con=getConnection(); String sql="select count(*) from member"; pstmt=con.prepareStatement(sql); rs=pstmt.executeQuery(); if(rs.next()) count=rs.getInt(1); } finally { closeAll(rs,pstmt, con); } return count; }

3. 회원 검색

1) WebContent - findMemberListByname.jsp

<%@page import="model.MemberVO" %> <%@page import="java.util.ArrayList"%> <%@page import="model.MemberDAO"%> <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>회원검색 결과</title> <style> table, td, th { border: 1px solid black; } table { border-collapse: collapse; width: 50%; } th,td { text-align: center; } </style> </head> <body> <% String name=request.getParameter("name"); ArrayList<MemberVO> list=MemberDAO.getInstance().findMemberListByname(name); if(list.isEmpty()){ %> <script type="text/javascript"> alert("<%=name%>라는 회원이 없습니다"); location.href="index.jsp"; </script> <% }else{ %> <%=name %> 회원 정보<br><br> <table> <thead> <tr> <th>순번</th><th>이름</th><th>아이디</th><th>이메일</th> </tr> </thead> <tbody> <%for(int i=0;i<list.size();i++){ %> <tr> <td><%=i+1 %></td> <td><%=list.get(i).getId() %></td> <td><%=list.get(i).getName() %></td> <td><%=list.get(i).getEmail() %></td> </tr> <% } %> </tbody> </table> <% } %> </body> </html>

2) src - model.MemberDAO.java

//회원 검색 정보 가져오는 메소드 public ArrayList<MemberVO> findMemberListByname(String name) throws SQLException{ ArrayList<MemberVO> list=new ArrayList<MemberVO>(); Connection con=null; ResultSet rs=null; PreparedStatement pstmt=null; try { con=getConnection(); String sql="select id,name,email from member where name=?"; pstmt=con.prepareStatement(sql); pstmt.setString(1, name); rs=pstmt.executeQuery(); while(rs.next()) list.add(new MemberVO(rs.getString(1),rs.getString(2),rs.getString(3))); } finally { closeAll(rs, pstmt, con); } return list; }

[참고] Model1 개념 참고 https://thatisgood.tistory.com/entry/model1-vs-model2-%EC%B0%A8%EC%9D%B4%EC%A0%90

'1.JAVA Web Programming > [2주차]DB,Model1,Model2' 카테고리의 다른 글

DB 연동 - jdk에 MariaDB jdbc jar파일 넣기 & 이클립스 연동 테스트 (1)	2019.08.03
DB 연동 - mariadb 설치 (0)	2019.08.03

개발자로가는길

Model1 Architecture

'1.JAVA Web Programming > [2주차]DB,Model1,Model2' 카테고리의 다른 글

+ Recent posts

티스토리툴바