JSP

211020_jsp로 게시판 만들기

요옫 2021. 10. 20. 09:24

퀀텀db로 테이블 생성

dto-ssinsertform-dao--ssinsertaction

 

 

sinsangDto.java

package sinsang.model;

 

public class SinsangDto {

 

private String num;

private String name;

private String blood;

private String hp;

private String birth;

 

//setter,getter

public String getNum() {

return num;

}

public void setNum(String num) {

this.num = num;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public String getBlood() {

return blood;

}

public void setBlood(String blood) {

this.blood = blood;

}

public String getHp() {

return hp;

}

public void setHp(String hp) {

this.hp = hp;

}

public String getBirth() {

return birth;

}

public void setBirth(String birth) {

this.birth = birth;

}

}

 

 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

 

 

ssinsertform.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"

    pageEncoding="UTF-8"%>

<!DOCTYPE html>

<html>

<head>

<meta charset="UTF-8">

<title>Insert title here</title>

<link href="https://fonts.googleapis.com/css2?family=Nanum+Pen+Script&display=swap" rel="stylesheet">

<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">

<script src="https://code.jquery.com/jquery-3.5.0.js"></script>

<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script>

 

<script type="text/javascript">

/* 연락처에서 입력창 이동 */

function goFocus(hp) {

if(hp.value.length==4)

frm.hp3.focus();

}

</script>

 

</head>

<body>

  <form action="ssinsertaction.jsp" method="post" name="frm">

    <table class="table table-bordered" style="width: 350px;">

      <caption>신상정보</caption>

        <tr>

          <th width="100">이름</th>

          <td>

            <input type="text" name="name" size="8" placeholder="이름" required="required">

          </td>

        </tr>

        

        <tr>

          <th width="100">혈액형</th>

          <td>

            <select name="blood" size="1">

              <option value="A">A형</option>

              <option value="B">B형</option>

              <option value="O">O형</option>

              <option value="AB">AB형</option>

            </select>

          </td>

        </tr>

        

        <tr>

          <th width="100">연락처</th>

            <td>

              <select size="1" name="hp1">

                <option value="010">010</option>

                <option value="010">011</option>

                <option value="010">019</option>

                <option value="010">02</option>

                <option value="010">031</option>

              </select>

              <b>-</b>

              <input type="text" name="hp2" size="3" required="required"

                     onkeyup="goFocus(this)">

              <b>-</b>

              <input type="text" name="hp3" size="3" required="required">

            </td>

        </tr>

        

        <tr>

          <th width="100">생년월일</th>

          <td>

            <input type="date" name="birth" required="required">       

          </td>

        </tr>

        

        <tr>

          <td colspan="2" align="center">

            <input type="submit" value="DB저장">

            <input type="button" value="목록" onclick="location.href='sslist.jsp'">

          </td>

        </tr>

    </table>

  </form>

</body>

</html>

 

 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

sinsangDao.java

 

 

 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ssinsertaction.jsp

 

<%@page import="sinsang.model.SinsangDao"%>

<%@page import="sinsang.model.SinsangDto"%>

<%@ page language="java" contentType="text/html; charset=UTF-8"

    pageEncoding="UTF-8"%>

<!DOCTYPE html>

<html>

<head>

<meta charset="UTF-8">

<title>Insert title here</title>

<link href="https://fonts.googleapis.com/css2?family=Nanum+Pen+Script&display=swap" rel="stylesheet">

<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">

<script src="https://code.jquery.com/jquery-3.5.0.js"></script>

<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script>

</head>

<body>

<%

request.setCharacterEncoding("utf-8");

 

String name=request.getParameter("name");

String blood=request.getParameter("blood");

String birth=request.getParameter("birth");

//db에서는 hp하나이기에 hp1,2,3 묶어주기

String hp=request.getParameter("hp1")+"-"+

request.getParameter("hp2")+"-"+request.getParameter("hp3");

 

//dto생성해서 담기

SinsangDto dto=new SinsangDto();

 

dto.setName(name);

dto.setBlood(blood);

dto.setHp(hp);

dto.setBirth(birth);

 

//dao생성해서 insert메서드 호출

SinsangDao dao=new SinsangDao();

dao.sinsangInsert(dto);

 

//목록으로 이동

response.sendRedirect("sslist.jsp");

%>

</body>

</html>

 

 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

 

 

 

 

 

 

'JSP' 카테고리의 다른 글

211020_session  (0) 2021.10.20
211020_session으로 로그인/로그아웃  (0) 2021.10.20
211019_복습(jsp)  (0) 2021.10.19
211019_jsp로 게시판 만들기  (0) 2021.10.19
211012_form전송(checkbox, radio,select,array)  (0) 2021.10.12