서블릿 비즈니스 로직 처리
맥북에서 mariadb를 이용해 연동하기
servlet
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
MemberDAO dao = new MemberDAO();
List<MemberVO> list = dao.listMembers();
out.print("<html><body>");
out.print("<table border='1'> <tr align='center' bgcolor='lightgreen'>");
out.print("<td>id</td><td>password</td><td>name</td><td>email</td>");
for(int i =0; i<list.size();i++) {
MemberVO memberVO = (MemberVO)list.get(i);
String id = memberVO.getId();
String pwd = memberVO.getPwd();
String name = memberVO.getName();
String email = memberVO.getEmail();
out.print("<tr><td>" + id + "</td><td> " + pwd + "</td><td>" + name + "</td><td>" + email+ "</td>");
}
out.print("</table></body></html>");
}
MemberVO
public class MemberVO {
private String id;
private String pwd;
private String name;
private String email;
public MemberVO() {
System.out.println("VO 생성자 호출");
}
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getPwd() {
return pwd;
}
public void setPwd(String pwd) {
this.pwd = pwd;
}
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;
}
MemberDAO
public class MemberDAO {
private static final String driver = "org.mariadb.jdbc.Driver";
private static final String url = "jdbc:mariadb://localhost:3306/test";
private static final String user = "root";
private static final String pwd = [비밀번호];
private Connection con;
private Statement stmt;
public List<MemberVO> listMembers() {
List<MemberVO> list = new ArrayList<MemberVO>();
try {
connDB();
String query = "select * from t_member";
System.out.println(query);
ResultSet rs = stmt.executeQuery(query);
while(rs.next()) {
String id = rs.getString("id");
String pwd = rs.getString("pwd");
String name = rs.getString("name");
String email = rs.getString("email");
MemberVO vo = new MemberVO();
vo.setId(id);
vo.setPwd(pwd);
vo.setName(name);
vo.setEmail(email);
list.add(vo);
}
rs.close();
stmt.close();
con.close();
} catch(Exception e) {
e.printStackTrace();
}
return list;
}
private void connDB() {
try {
Class.forName(driver);
System.out.println("maria driver loading good");
con = DriverManager.getConnection(url,user,pwd);
System.out.println("connection good");
stmt=con.createStatement();
System.out.println("statement good");
}catch( Exception e) {
e.printStackTrace();
}
}
출력