JSP

JSP(홈쇼핑회원관리프로그램)_2024-09-13

앵보몬 2024. 9. 20. 09:46
728x90
반응형

shopping.zip
4.64MB

 

DB

--1.회원정보 명세서
CREATE TABLE MEMBER_TBL_02 (
    CUSTNO NUMBER(6) PRIMARY KEY,
    CUSTNAME VARCHAR2(20),
    PHONE VARCHAR2(13),
    ADDRESS VARCHAR2(60),
    JOINDATE DATE,
    GRADE CHAR(1),
    CITY CHAR(2)
);
   
--2.회원매출정보 명세서
CREATE TABLE MONEY_TBL_02 (
    CUSTNO NUMBER(6),
    SALENOL NUMBER(8),
    PCOST NUMBER(8),
    AMOUNT NUMBER(4),
    PRICE NUMBER(8),
    PCODE VARCHAR2(4),
    SDATE DATE,
    PRIMARY KEY (CUSTNO, SALENOL),
    FOREIGN KEY (CUSTNO) REFERENCES MEMBER_TBL_02(CUSTNO)
);
   
   
--1.회원정보테이블(MEMBER_TBL_02)
INSERT INTO MEMBER_TBL_02 VALUES (100001, '김행복', '010-1111-2222', '서울 동대문구 휘경1동', '20151202', 'A', '01');
INSERT INTO MEMBER_TBL_02 VALUES (100002, '이축복', '010-1111-3333', '서울 동대문구 휘경2동', '20151206', 'B', '01');
INSERT INTO MEMBER_TBL_02 VALUES (100003, '장믿음', '010-1111-4444', '울릉군 울릉읍 독도1리', '20151001', 'B', '30');
INSERT INTO MEMBER_TBL_02 VALUES (100004, '최사랑', '010-1111-5555', '울릉군 울릉읍 독도2리', '20151113', 'A', '30');
INSERT INTO MEMBER_TBL_02 VALUES (100005, '진평화', '010-1111-6666', '제주도 제주시 외나무골', '20151225', 'B', '60');
INSERT INTO MEMBER_TBL_02 VALUES (100006, '차공단', '010-1111-6666', '제주도 제주시 감나무골', '20151211', 'C', '60');

--2.회원매출정보(MONEY_TBL_02)
INSERT INTO MONEY_TBL_02 VALUES (100001, 20160001, 500, 5, 2500, 'A001', '20160101');
INSERT INTO MONEY_TBL_02 VALUES (100001, 20160002, 1000, 4, 4000, 'A002', '20160101');
INSERT INTO MONEY_TBL_02 VALUES (100001, 20160003, 500, 3, 1500, 'A008', '20160101');
INSERT INTO MONEY_TBL_02 VALUES (100002, 20160004, 2000, 1, 2000, 'A004', '20160102');
INSERT INTO MONEY_TBL_02 VALUES (100002, 20160005, 500, 1, 500, 'A001', '20160103');
INSERT INTO MONEY_TBL_02 VALUES (100003, 20160006, 1500, 2, 3000, 'A003', '20160103');
INSERT INTO MONEY_TBL_02 VALUES (100004, 20160007, 500, 2, 1000, 'A001', '20160104');
INSERT INTO MONEY_TBL_02 VALUES (100004, 20160008, 300, 1, 300, 'A005', '20160104');
INSERT INTO MONEY_TBL_02 VALUES (100004, 20160009, 600, 1, 600, 'A006', '20160104');
INSERT INTO MONEY_TBL_02 VALUES (100004, 20160010, 3000, 1, 3000, 'A007', '20160106');

SELECT * FROM MEMBER_TBL_02;
SELECT * FROM MONEY_TBL_02;

commit;

 

shopping.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
  <meta charset="UTF-8">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
  <title>쇼핑몰 회원관리 프로그램</title>
 <link rel="stylesheet" href="style.css" />
</head>
<body>

  <header>쇼핑몰 회원관리 ver 1.0</header>

  <nav>
    <a href="join_copy.jsp">회원등록</a>
    <a href="search.jsp">회원목록조회/수정</a>
    <a href="income.jsp">회원매출조회</a>
    <a href="index.jsp">Home</a>
  </nav>

  <section class="main-section">
    <h2>쇼핑몰 회원관리 프로그램</h2>
    <p>쇼핑몰 회원정보와 회원매출정보 데이터베이스를 구축하고 회원관리 프로그램을 작성하는 프로그램이다. <br>
    <br><br><b>프로그램 작성 순서</b><br><br>
    1. 회원정보 테이블을 생성한다.<br>
    2. 매출정보 테이블을 생성한다.<br>
    3. 회원정보, 매출정보 테이블에 제시된 문제지의 참조 데이터를 추가 생성한다.<br>
    4. 회원정보 입력 화면 프로그램을 작성한다.<br>
    5. 회원정보 조회 프로그램을 작성한다.<br>
    6. 회원매출정보 조회 프로그램을 작성한다.<br>
    </p>
  </section>

  <footer>HRDKOREAⓒopyright 2023 All rights reserved. Human Resources Development Service of Korea</footer>

</body>
</html>

 

styles.css

@charset "UTF-8";
  body {
    font-family: Arial, sans-serif;
    margin: 0;
    padding: 0;
    color: #333;
    background-color: #f4f4f4;
    }
   
    h2 {
    text-align: center;
    font-weight: bolder;
        text-shadow: 1px 1px darkgray;
  }

    /* Header styling */
    header {
      position: fixed;
      top: 0;
      width: 100%;
      height: 80px;
      background-color: dimgray;
      color: white;
      line-height: 80px;
      text-align: center;
      font-size: 28px;
      font-weight: bolder;
      text-shadow: 1px 1px darkgray;
    }

    /* Navigation styling */
    nav {
      position: fixed;
      top: 80px;
      width: 100%;
      height: 40px;
      background-color: #333;
      color: white;
      line-height: 40px;
      padding: 0 20px;
      display: flex;
      align-items: stretch;
      font-weight: bolder;
    }

    nav a {
      text-decoration: none;
      color: inherit;
      padding: 0 15px;
      transition: background-color 0.3s ease;
    }

    nav a:hover {
      background-color: darkgray;
    }

    .main-section {
      padding-top: 120px;
      padding: 20px;
      background-color: white;
      box-shadow: 0 0 10px rgba(0, 0, 0, 0.1);
    margin:0 auto;
    margin-top:150px;
      width: 50%;
    }
   
    /* Footer styling */
    footer {
      position: fixed;
      bottom: 0;
      width: 100%;
      height: 50px;
      background-color: #333;
      color: white;
      text-align: center;
      line-height: 50px;
      font-size: 15px;
      font-weight: bolder;
    }
   
    table {
    width: 70%;
    text-align: center;
    margin: 0 auto;
  }
 
  table, th, td {
    border: 1px solid black;
  }
 
  footer {
    position: fixed;
    bottom: 0;
    width: 100%;
    height: 50px;
  }

 

 

 

 

 

728x90
반응형