Log In
Sign Up
Jobs
Job Search
Explore all available job openings across industries and locations.
Company Search
Find your dream jobs categorized by company names.
Themed Jobs
Discover job opportunities organized by specific themes or industries.
Download our App
Tools
Resume
Create your job-winning resume using our free resume builder.
Portfolio
Showcase your skills and projects with a professional portfolio.
Resume
Create your job-winning resume using our free resume builder.
Resume Builder
Make a resume for free.
Resume Templates
Access our extensive library of professional & ready-to-use templates.
Resume Examples
Get inspired by real resume examples to create your own.
Occupation Guide
Access resume writing guides tailored for different professions.
Resume Help
Get expert advice on all things resume from our team of recruitment specialists.
Portfolio
Showcase your skills and projects with a professional portfolio.
Portfolio Maker
Create a professional portfolio to highlight your skills and projects.
Portfolio Gallery
Browse through our collection of real portfolios for inspiration and networking.
Resources
Articles
Read insightful articles on career development, job search strategies, and more.
View All Articles
Job Search Guide
Resume & CV
Cover Letter
Portfolio
Interview Skills
Job Search Tips
Industry & Job Overview
Career Guidance
Career Planning
Career Tools
Career Development
Personal Branding
Success Stories
Success Stories
Business Excellence
People Operations
Recruitment & HR
About CakeResume
People & Culture
News & Updates
Events
Featured Reads
Resume & CV
What to Write in an Email When Sending a Resume [+ Examples & Tips]
Read More
Hire
Talent Search
Find Resumes.
Job Posting
Start for Free.
Recruitment Service
Acquire Talent.
Employer of Record (EOR)
Empower Your Business in Taiwan.
Employer Branding
Build and promote your employer brand.
Pricing
Job Posting Plans
Talent Search Plans
Resume Builder Plans
Build your Network
My Network
Access your personal network connections and manage your contacts.
CakeResume Meet
Expand your professional network by meeting and connecting with other users.
Community
Engage with other users through discussions, forums, and networking events.
Download our App
Build your Network
My Network
Access your personal network connections and manage your contacts.
CakeResume Meet
Expand your professional network by meeting and connecting with other users.
Community
Engage with other users through discussions, forums, and networking events.
Log In
Sign Up
Portfolios
黃博彥
資策會結訓專題設計 - 投影片封面
資策會結訓專題設計 - 投影片封面
資策會結訓專題設計 - 投影片封面
By
黃博彥
・
Taoyuan City, Taiwan
Connect
專題相關資料連結 - https://drive.google.com/drive/folders/1So_uJbXnw3kqafYZbI9tGoAS_YIqwXQ8?usp=sharing 專題設計中使用到 JSP / Servlet / Oracle Database / JavaScript / jQuery / Bootstrap 並且配合MVC架構進行撰寫 我負責的區塊有: 會員功能 (影片) 0:56 - 3:03 會員註冊、登入、修改會員資料 團購功能 (影片) 16:37 - 23:47 後台上架商品、修改商品資料、前台加入/退出團購、前後台訂單管理、計算折扣及成立訂單排程器 討論區功能 (影片) 33:52 - 37:45 新增文章/留言、修改文章/留言、移除文章/留言、加入/取消收藏 下方是Github的連結 https://github.com/Pukesheep/EA101G1_Project.git 表格規格請參考 https://docs.google.com/spreadsheets/d/1tGOv1-loR6FqbrnTjQJtdcVkSFdV_OB0qbCT97f6lXw/edit?usp=sharing 會員有1個表格 member表格-用來存放會員相關資料。 Model位置在 EA101G1_Project/src/com/member/model interface-制定方法。 由Controller呼叫MemberService再透過此類別存取Member表格的資料。 上線的DAO是使用JNDI的版本,JDBC的版本是測試SQL語法用。 Controller則是EA101G1_Project/src/com/member/controller CheckServlet-檢查用來註冊的信箱(資料庫設定此欄位為Unique)是否被使用過。 MemberServlet是用來處理新增、修改、查詢等功能的輸入參數的驗證檢查以及完成資料存取後轉交到View。 MailService-寄送郵件所使用的程式,用來會員註冊(控制器的signup區塊)完成後寄送密碼函所呼叫的類別。 ShowMemberPic-會員表格存有會員大頭貼,用來對資料庫查詢圖片欄位後呈現出來。 LoginHandler-檢查會員登入所輸入的資訊是否正確以及處理登出的程式。 View放在 EA101G1_Project/WebContent/front-end/member 以及 EA101G1_Project/WebContent/back-end/member的位置 JSP檔案裏面使用JSTL / EL / HTML / CSS / JavaScript / jQuery / Bootstrap配合使用。 團購功能有4個表格 groupbuy表格-存放商品資訊(開始/截止時間、團購商品的折扣資訊)。 gromem表格-存放團購編號以及會員編號,用來記錄加入團購的會員,或者是查詢會員加入哪些團購。 gro_order表格-團購截止後經過計算人數對應折扣得到新的價格並成立訂單,本表格即是存放訂單資訊。 rebate表格-商品折扣的機制為滿X人可為商品打Y折,因正規化而將人數條件以及折扣另存一個表格。 EA101G1_Project/src/com/groupbuy EA101G1_Project/src/com/gromem EA101G1_Project/src/com/gro_order EA101G1_Project/src/com/rebate com/groupbuy/util內為一個設定為啟動時載入的Servlet程式-GroupbuyTimer,用來設定兩個排程器的時間。 Undeploy-功能是檢查架上商品的截止時間並且計算人數是否達成折扣門檻再分類成達標或者是未達標。 OrderList-篩選出達標的商品、再根據商品的資訊(加入此團購商品的會員、折扣後的價格)成立訂單。 Model、View以及Controller概念則是與會員功能大致上類似。 討論區功能有4個表格 post-存放會員所發表的文章資訊。 comm-對於文章所發表的留言資訊。 ptype-依照發表文章時所選擇的文章類型。 favorite_post-會員可以收藏文章功能,相關的資訊利用這個表格存放。 功能設計-後台功能簡化成代表管理員的帳號由前台登入來管理討論區,可以移除會員的文章/留言。 Model以及Controller概念則是與會員功能大致上類似。 View在設計上仿照Facebook的呈現,大多數的操作都會在同一個頁面完成,所以front-end/post/listAllPost.jsp當中所含的JSTL / EL / JavaScript / jQuery / Bootstrap 程式碼較其他JSP檔案來得多。 雖然專題裡面沒有運用到Hibernate以及Spring等框架,但課程中仍然有學習到,正在複習手邊教材進行強化。
Report
Please login to comment.
Post
黃博彥
Connect
Published: Aug 28th 2020
60
7
0
MVC
Bootstrap
JSP/Servlet
Oracle
JavaScript
Java
Share