투표프로그램
PollMgr.java
package ch16;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Vector;
public class PollMgr {
private DBConnectionMgr pool;
public PollMgr() {
pool = DBConnectionMgr.getInstance();
}
//Max Num : 가장 최신의 num값 리턴
public int getMaxNum() {
Connection con = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
String sql = null;
int maxNum = 0;
try {
con = pool.getConnection();
sql = "select max(num) from tblPollList";
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if(rs.next()) maxNum = rs.getInt(1);
} catch (Exception e) {
e.printStackTrace();
} finally {
pool.freeConnection(con, pstmt, rs);
}
return maxNum;
}
//Poll Insert : 설문과 Item 같이 저장
public boolean insertPoll(PollListBean plBean,
PollItemBean piBean) {
Connection con = null;
PreparedStatement pstmt = null;
String sql = null;
boolean flag = false;
try {
con = pool.getConnection();
sql = "insert tblPollList(question,sdate,edate,wdate,type)"
+ "values(?,?,?,now(),?)";
pstmt = con.prepareStatement(sql);
pstmt.setString(1, plBean.getQuestion());
pstmt.setString(2, plBean.getSdate());
pstmt.setString(3, plBean.getEdate());
pstmt.setInt(4, plBean.getType());//1복수, 0단일
int cnt = pstmt.executeUpdate();
pstmt.close();
if(cnt==1) {//정상적인 tblPollList 저장
sql = "insert tblPollItem values(?,?,?,0)";
pstmt = con.prepareStatement(sql);
int listNum = getMaxNum();//방금 저장한 리스트의 num값
String item[] = piBean.getItem();
for (int i = 0; i < item.length; i++) {
if(item[i]==null||item[i].trim().equals(""))
break;
pstmt.setInt(1, listNum);
pstmt.setInt(2, i);
pstmt.setString(3, item[i]);
if(pstmt.executeUpdate()==1)
flag = true;
}//--for
}
} catch (Exception e) {
e.printStackTrace();
} finally {
pool.freeConnection(con, pstmt);
}
return flag;
}
//Poll List
public Vector<PollListBean> getPollList(){
Connection con = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
String sql = null;
Vector<PollListBean> vlist = new Vector<PollListBean>();
try {
con = pool.getConnection();
sql = "select * from tblPollList order by num desc";
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
while(rs.next()) {
PollListBean plBean = new PollListBean();
plBean.setNum(rs.getInt("num"));
plBean.setQuestion(rs.getString("question"));
plBean.setSdate(rs.getString("sdate"));
plBean.setEdate(rs.getString("edate"));
vlist.addElement(plBean);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
pool.freeConnection(con, pstmt, rs);
}
return vlist;
}
//Poll Read
public PollListBean getPoll(int num) {
Connection con = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
String sql = null;
PollListBean plBean = new PollListBean();
try {
con = pool.getConnection();
sql = "select num, question, type, active "
+ "from tblPollList where num = ?";
pstmt = con.prepareStatement(sql);
if(num==0)
num = getMaxNum();
pstmt.setInt(1, num);
rs = pstmt.executeQuery();
if(rs.next()) {
plBean.setNum(rs.getInt(1));
plBean.setQuestion(rs.getString(2));
plBean.setType(rs.getInt(3));
plBean.setActive(rs.getInt(4));
}
} catch (Exception e) {
e.printStackTrace();
} finally {
pool.freeConnection(con, pstmt, rs);
}
return plBean;
}
//Poll Item List
public Vector<String> getItemList(int listNum){
Connection con = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
String sql = null;
Vector<String> vlist = new Vector<String>();
try {
con = pool.getConnection();
sql = "select item from tblPollItem where listNum = ?";
pstmt = con.prepareStatement(sql);
if(listNum==0)
listNum = getMaxNum();//가장 최신의 설문의 아이템 리턴
pstmt.setInt(1, listNum);
rs = pstmt.executeQuery();
while(rs.next()) {
vlist.addElement(rs.getString(1));
}
} catch (Exception e) {
e.printStackTrace();
} finally {
pool.freeConnection(con, pstmt, rs);
}
return vlist;
}
//Count Sum : 설문 투표수
public int sumCount(int listNum) {
Connection con = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
String sql = null;
int sum = 0;
try {
con = pool.getConnection();
sql = "select sum(count) from tblPollItem where listNum = ?";
pstmt = con.prepareStatement(sql);
if(listNum==0) listNum = getMaxNum();
pstmt.setInt(1, listNum);
rs = pstmt.executeQuery();
if(rs.next()) {
sum = rs.getInt(1);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
pool.freeConnection(con, pstmt, rs);
}
return sum;
}
//Poll Update : 투표실행
public boolean updatePoll(int listNum, String itemNum[]) {
Connection con = null;
PreparedStatement pstmt = null;
String sql = null;
boolean flag = false;
try {
con = pool.getConnection();
sql = "update tblPollItem set count = count+1 where listNum = ? and itemNum = ?";
pstmt = con.prepareStatement(sql);
if(listNum==0) listNum = getMaxNum();
for (int i = 0; i < itemNum.length; i++) {
pstmt.setInt(1, listNum);
pstmt.setInt(2, Integer.parseInt(itemNum[i]));
if(pstmt.executeUpdate()==1)
flag = true;
}
} catch (Exception e) {
e.printStackTrace();
} finally {
pool.freeConnection(con, pstmt);
}
return flag;
}
//Poll View : 결과 보기
public Vector<PollItemBean> getView(int listNum){
Connection con = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
String sql = null;
Vector<PollItemBean> vlist = new Vector<PollItemBean>();
try {
con = pool.getConnection();
sql = "select item, count from tblPollItem where listNum=?";
pstmt = con.prepareStatement(sql);
pstmt.setInt(1, listNum == 0 ? getMaxNum():listNum);
rs = pstmt.executeQuery();
while(rs.next()) {
PollItemBean pibean = new PollItemBean();
String item[] = new String[1];
item[0] = rs.getString("item");
pibean.setItem(item);
pibean.setCount(rs.getInt("count"));
vlist.addElement(pibean);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
pool.freeConnection(con, pstmt, rs);
}
return vlist;
}
//Max Item Count : 아이템 중에 가장 높은 투표값
public int getMaxCount(int listNum) {
Connection con = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
String sql = null;
int maxCnt = 0;
try {
con = pool.getConnection();
sql = "select max(count) from tblPollItem where listNum = ?";
pstmt = con.prepareStatement(sql);
//if(listNum==0) listNum = getMaxNum();
//pstmt.setInt(1, listNum);
pstmt.setInt(1, listNum == 0 ? getMaxNum():listNum);
rs = pstmt.executeQuery();
if(rs.next()) {
maxCnt = rs.getInt(1);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
pool.freeConnection(con, pstmt, rs);
}
return maxCnt;
}
}
pollForm.jsp
<%@page import="java.util.Vector"%>
<%@page import="ch16.PollListBean"%>
<%@page import="ch15.UtilMgr"%>
<%@page contentType="text/html; charset=UTF-8"%>
<jsp:useBean id="mgr" class = "ch16.PollMgr"/>
<%
int num = 0;
if(request.getParameter("num") != null){
num = UtilMgr.parseInt(request, "num");
}
PollListBean plBean = mgr.getPoll(num);
Vector<String> vItem = mgr.getItemList(num);
String question = plBean.getQuestion();
int type = plBean.getType();
int active = plBean.getActive();
int sumCount = mgr.sumCount(num); //미구현
//out.print(question +" : " + vItem.size());
%>
<form action="pollFormProc.jsp">
<table border="1">
<tr>
<td colspan="2" width="300">
Q : <%=question%> <font color="blue">(<%=sumCount%>)</font>
</td>
</tr>
<tr>
<td colspan="2">
<%
for(int i=0;i<vItem.size();i++){
String item = vItem.get(i);
%>
<%if(type==1){%>
<input type="checkbox" name="itemnum" value="<%=i%>">
<%}else if(type==0){ %>
<input type="radio" name="itemnum" value="<%=i%>">
<%}%>
<%=item%><br>
<%}%>
</td>
</tr>
<tr>
<td width="150">
<%if(active==1){%>
<input type="submit" value="투표">
<%}else{%>
투표종료
<%}%>
</td>
<td>
<input type="button" value="결과"
onclick="javascript:window.open('pollView.jsp?num=<%=num%>'
,'pollView','width=500, height=350')">
</td>
</tr>
</table>
<input type="hidden" name="num" value="<%=num%>">
</form>pollFromProc.jsp
<!-- pollFormProc.jsp -->
<%@page import="ch16.UtilMgr"%>
<%@page contentType="text/html; charset=UTF-8"%>\
<jsp:useBean id="mgr" class="ch16.PollMgr"/>
<%
int listNum = UtilMgr.parseInt(request, "num");
String itemNum[] = request.getParameterValues("itemnum");
boolean result = mgr.updatePoll(listNum, itemNum);
//out.print(result);
String msg = "투표에 실패";
if(result) msg = "투표에 성공";
%>
<script>
alert("<%=msg%>");
location.href = "pollList.jsp?num=<%=listNum%>";
</script>
pollinsert.jsp
<%@ page contentType="text/html; charset=UTF-8" %>
<html>
<head>
<title>JSP Poll</title>
<link href="style.css" rel="stylesheet" type="text/css">
<script type="text/javascript">
function send() {
f = document.frm;
f.sdate.value = f.sdateY.value+"-"
+ f.sdateM.value+"-"+f.sdateD.value;
f.edate.value = f.edateY.value+"-"
+ f.edateM.value+"-"+f.edateD.value;
f.submit();
}
</script>
</head>
<body bgcolor="#FFFFCC">
<div align="center">
<br />
<h2>Poll Program</h2>
<hr width="600" />
<b>설문작성</b>
<hr width="600" />
<form name="frm" method="post" action="pollInsertProc.jsp">
<table border="1" width="500">
<tr>
<td><b>질문</b></td>
<td colspan="2"><input name="question" size="30"></td>
</tr>
<tr>
<td rowspan="10"><b>항목</b></td>
<%
for (int i = 1; i <= 4; i++) {
out.println("<td>" + (i * 2 - 1)
+ ": <input name='item'></td>");
out.println("<td>" + (i * 2)
+ ": <input name='item'></td>");
out.println("</tr>");
if (i == 9) {
out.println("");
} else {
out.println("<tr>");
}
}//for end
%>
<tr>
<td>시작일</td>
<td colspan="2"><select name="sdateY">
<option value="2023">2023
<option value="2024">2024
</select>년 <select name="sdateM">
<%
for (int i = 1; i <= 12; i++) {
out.println("<option value='" + i + "'>" + i);
}
%>
</select>월 <select name="sdateD">
<%
for (int i = 1; i <= 31; i++) {
out.println("<option value='" + i + "'>" + i);
}
%>
</select>일</td>
</tr>
<tr>
<td>종료일</td>
<td colspan=2><select name="edateY">
<option value="2023">2023
<option value="2024">2024
</select>년 <select name="edateM">
<%
for (int i = 1; i <= 12; i++) {
out.println("<option value='" + i + "'>" + i);
}
%>
</select>월 <select name="edateD">
<%
for (int i = 1; i <= 31; i++) {
out.println("<option value='" + i + "'>" + i);
}
%>
</select>일</td>
</tr>
<tr>
<td>복수투표</td>
<td colspan=2>
<input type="radio" name="type" value="1" checked>yes
<input type="radio" name="type" value="0">no
</td>
</tr>
<tr>
<td colspan=3>
<input type="button" value="작성하기" onclick="send()">
<input type="reset" value="다시쓰기">
<input type="button" value="리스트" onClick="javascript:location.href='pollList.jsp'">
</td>
</tr>
</table>
<input type="hidden" name="sdate">
<input type="hidden" name="edate">
</form>
</div>
</body>
</html>pollInsertProc.jsp
<%@page contentType="text/html; charset=UTF-8"%>
<jsp:useBean id="mgr" class="ch16.PollMgr"/>
<jsp:useBean id="plbean" class="ch16.PollListBean"/>
<jsp:setProperty property="*" name="plbean"/>
<jsp:useBean id="pibean" class="ch16.PollItemBean"/>
<jsp:setProperty property="*" name="pibean"/>
<%
boolean result = mgr.insertPoll(plbean, pibean);
String msg = "설문 추가 실패";
String url = "pollInsert.jsp";
if(result){
msg = "설문 추가 성공";
url = "pollList.jsp";
}
%>
<script>
alert("<%=msg%>");
location.href = "<%=url%>";
</script>
pollList.jsp
<!-- pollList.jsp -->
<%@page import="ch16.PollListBean"%>
<%@page import="java.util.Vector"%>
<%@page contentType="text/html; charset=UTF-8"%>
<jsp:useBean id="mgr" class="ch16.PollMgr"/>
<html>
<head>
<title>JSP Poll</title>
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body bgcolor="#FFFFCC">
<div align="center">
<h2>Poll Program</h2>
<hr width="60%">
<jsp:include page="pollForm.jsp"/>
<b>설문 리스트</b>
<table>
<tr>
<td>
<table border="1">
<tr>
<th width="50">번호</th>
<th width="250" align="left">질문</th>
<th width="200">시작일~종료일</th>
</tr>
<%
Vector<PollListBean> vlist = mgr.getPollList();
for(int i=0;i<vlist.size();i++){
PollListBean plBean = vlist.get(i);
int num = plBean.getNum();
String question = plBean.getQuestion();
String sdate = plBean.getSdate();
String edate = plBean.getEdate();
%>
<tr>
<td align="center"><%=vlist.size()-i%></td>
<td><a href="pollList.jsp?num=<%=num%>"><%=question%></a></td>
<td align="center"><%=sdate+"~"+edate%></td>
</tr>
<%}//---for%>
</table>
</td>
</tr>
<tr>
<td align="center">
<a href="pollInsert.jsp">설문작성하기</a>
</td>
</tr>
</table>
</div>
</body>
</html>
pollView.jsp
<!-- pollview.jsp -->
<%@page import="java.util.Random"%>
<%@page import="ch16.PollItemBean"%>
<%@page import="java.util.Vector"%>
<%@page import="ch16.PollListBean"%>
<%@page import="ch16.UtilMgr"%>
<%@page contentType="text/html; charset=UTF-8"%>
<jsp:useBean id="mgr" class="ch16.PollMgr"/>
<%
int listNum = 0;
if(request.getParameter("num")!=null){
listNum = UtilMgr.parseInt(request, "num");
}
// 어떤 설문에 대한 값
PollListBean plBean = mgr.getPoll(listNum);
Vector<PollItemBean> vlist = mgr.getView(listNum);
// 현재 설문에 sum 투표수
int sumCnt = mgr.sumCount(listNum);
// 현재 설문에 가장 높은 투표수
int maxCnt = mgr.getMaxCount(listNum);
%>
<html>
<head>
<title>JSP Poll</title>
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body bgcolor="#FFFFCC">
<div align="center"><br/>
<h2>투표 결과</h2>
<table border="1" width="400">
<tr>
<td colspan="4"><b>Q : <%=plBean.getQuestion()%></b></td>
</tr>
<tr>
<td colspan="3"><b>총 투표자 : <%=sumCnt%>명</b></td>
<td width="40"><b>count(%)</b></td>
</tr>
<%
Random r = new Random();
for(int i=0;i<vlist.size();i++){
PollItemBean piBean = vlist.get(i);
String item = piBean.getItem()[0];
int count = piBean.getCount();
// 투표수/총투표수*100
int ratio = (int)(Math.round((double)count/sumCnt*100));
// 랜덤한 색상
String rgb = "#"+Integer.toHexString(r.nextInt(255*255*255));
%>
<tr>
<td width="20" align="center"><%=i+1%></td>
<td width="120">
<%if(maxCnt==count){%><font color="red"><b><%}%>
<%=item%>
<%if(maxCnt==count){%></b></font><%}%>
</td>
<td>
<table width="<%=ratio%>"height="15">
<tr>
<td bgcolor="<%=rgb%>">
</td>
</table>
</td>
<td width="40"><%=count%>(<%=ratio%>)</td>
</tr>
<%}//---for%>
</table><br>
<a href="javascript:window.close()">닫기</a>
</div>
</body>
</html>결과 화면
메일 전송
scr/main/java/mail/GmailSend.java
package mail;
import java.util.Properties;
import javax.mail.Address;
import javax.mail.Authenticator;
import javax.mail.Message;
import javax.mail.PasswordAuthentication;
import javax.mail.Session;
import javax.mail.Transport;
import javax.mail.internet.InternetAddress;
import javax.mail.internet.MimeMessage;
import org.apache.catalina.ssi.SSICommand;
public class GmailSend {
private static class SMTPAuthenticator extends Authenticator {
public PasswordAuthentication getPasswordAuthentication() {
return new PasswordAuthentication("sby4006@gmail.com", "dnmhzvteqcdciohb");
}
}
public static void send(String title, String content, String toEmail) {
Properties p = new Properties();
p.put("mail.smtp.starttls.enable", "true");
// 이메일 발송을 처리해줄 SMTP서버
p.put("mail.smtp.host", "smtp.gmail.com");
// SMTP 서버의 인증을 사용한다는 의미
p.put("mail.smtp.auth", "true");
// TLS의 포트번호는 587이며 SSL의 포트번호는 465이다.
p.put("mail.smtp.port", "587");
// soket문제와 protocol문제 해결
p.put("mail.smtp.ssl.trust", "smtp.gmail.com");
p.put("mail.smtp.socketFactory.fallback", "false");
p.put("mail.smtp.ssl.protocols", "TLSv1.2");
try {
Authenticator auth = new SMTPAuthenticator();
Session session = Session.getInstance(p, auth);
session.setDebug(true);
MimeMessage msg = new MimeMessage(session);
String message = content;
msg.setSubject(title);
Address fromAddr = new InternetAddress("sby4006@gmail.com");
msg.setFrom(fromAddr);
Address toAddr = new InternetAddress(toEmail);
msg.addRecipient(Message.RecipientType.TO, toAddr);
msg.setContent(message, "text/html;charset=KSC5601");
Transport.send(msg);
} catch (Exception e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
String title = "제목 테스트1";
String content = "내용 테스트2";
String toEmail = "thalsghks@naver.com";
GmailSend.send(title, content, toEmail);
System.out.println("성공~~~~~~");
}
}
MailSend.java
package mail;
public class MailSend {
public boolean sendPwd(String id, String email) {
boolean flag = false;
MemberMgr mgr = new MemberMgr();
String pwd = mgr.findPwd(id, email);
if(pwd!=null) {
String title = "OOO.com에서 id와 pwd 를 전송합니다.";
String content = "id / pwd : " + id + " / "+pwd;
GmailSend.send(title, content, email);
flag = true;
}
return flag;
}
}
MemberMgr.java
package mail;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class MemberMgr {
private DBConnectionMgr pool;
public MemberMgr() {
pool = DBConnectionMgr.getInstance();
}
public String findPwd(String id, String email) {
Connection con = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
String sql = null;
String pwd = null;
try {
con = pool.getConnection();
sql = "select pwd from tblMember where id=? and email=?";
pstmt = con.prepareStatement(sql);
pstmt.setString(1, id);
pstmt.setString(2, email);
rs = pstmt.executeQuery();
if(rs.next())
pwd = rs.getString(1);
} catch (Exception e) {
e.printStackTrace();
} finally {
pool.freeConnection(con, pstmt, rs);
}
return pwd;
}
}
webapp/mail/mailSend.jsp
<%@ page contentType="text/html; charset=UTF-8" %>
<html>
<head>
<title>JSP Email</title>
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body bgcolor="#FFFFCC">
<div align="center">
<br/><br/>
<table width="400" cellpadding="3">
<tr>
<td bgcolor="#FF3412" height="25" align="center">비밀번호 찾기</td>
</tr>
</table>
<br/>
<form name="postFrm" method="post" action="mailSendProc.jsp" >
<table width="400" cellpadding="3" align="center">
<tr>
<td align=center>
<table align="center">
<tr>
<td width="10%">id</td>
<td width="90%">
<input name="id" size="10" maxlength="8"></td>
</tr>
<tr>
<td>이메일</td>
<td>
<input name="email" size="30" maxlength="30"></td>
</tr>
<tr>
<td colspan="2"><hr/></td>
</tr>
<tr>
<td colspan="2">
<input type="submit" value="SEND">
<input type="reset" value="다시쓰기">
</td>
</tr>
</table>
</td>
</tr>
</table>
</form>
</div>
</body>
</html>mailSendProc.jsp
<!-- mailSendProc.jsp -->
<%@page contentType="text/html; charset=UTF-8"%>
<jsp:useBean id="mgr" class="mail.MailSend"/>
<%
String id = request.getParameter("id");
String email = request.getParameter("email");
boolean result = mgr.sendPwd(id,email);
String msg = "전송실패";
if(result){
msg = "전송성공";
}
%>
<script>
alert("<%=msg%>");
location.href= "mailSend.jsp";
</script>
결과 화면
쇼핑물
Simple Shopping Mail
1. 패키지 및 폴더 명 : shop
2. table.sql
CREATE TABLE tblProduct (
no int(5) auto_increment ,
name varchar(20) NULL ,
price int NULL ,
detail text NULL ,
date varchar(20) NULL ,
stock int NULL ,
image varchar(20) NULL ,
PRIMARY KEY ( no )
);
CREATE TABLE tblOrder (
no int auto_increment ,
productNo int NULL ,
quantity int NULL ,
date varchar(20) NULL ,
state varchar(10) NULL ,
id varchar(10) NULL ,
PRIMARY KEY ( no )
);
CREATE TABLE tblAdmin (
admin_id varchar(20) NOT NULL ,
admin_pwd varchar(20) NOT NULL ,
PRIMARY KEY ( admin_id )
);
CREATE TABLE tblMember (
id char(20) NOT NULL,
pwd char(20) NOT NULL,
name char(20) NOT NULL,
gender char(1) NOT NULL,
birthday char(6) NOT NULL,
email char(30) NOT NULL,
zipcode char(5) NOT NULL,
address char(50) NOT NULL,
hobby char(5) NOT NULL,
job char(20) NOT NULL,
PRIMARY KEY (id)
);
CREATE TABLE tblZipcode (
zipcode char(7) NOT NULL ,
area1 char(10) NULL ,
area2 char(20) NULL ,
area3 char(40) NULL ,
area4 char(20) NULL
);
insert tblProduct(name,price,detail,date,stock,image)
values ('갤럭시 플립3',1200000,'갤럭시 플립3 상세설명',
now(), 100, 'data1.jpg');
insert tblProduct(name,price,detail,date,stock,image)
values ('갤럭시 Z 폴드3',1500000,'갤럭시 Z 폴드3 상세설명',
now(), 100, 'data2.jpg');
insert tblProduct(name,price,detail,date,stock,image)
values ('iPhone 13',1300000,'iPhone 13 상세설명',
now(), 100, 'data3.jpg');-tblProduct, tblOrder, tblAdmin 생성
-tblMember, tblZipcode 기존꺼 사용
- 빈즈 및 풀링
- ProductBean.java
- OrderBean.java
- DBConnectionMgr.java 복사
OrderBean.java
package shop;
public class OrderBean {
private int no;
private int productNo;
private int quantity;
private String date;
private String state;
private String id;
public int getNo() {
return no;
}
public void setNo(int no) {
this.no = no;
}
public int getProductNo() {
return productNo;
}
public void setProductNo(int productNo) {
this.productNo = productNo;
}
public int getQuantity() {
return quantity;
}
public void setQuantity(int quantity) {
this.quantity = quantity;
}
public String getDate() {
return date;
}
public void setDate(String date) {
this.date = date;
}
public String getState() {
return state;
}
public void setState(String state) {
this.state = state;
}
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
}
ProductBean.java
package shop;
public class ProductBean {
private int no;
private String name;
private int price;
private String detail;
private String date;
private int stock;
private String image;
public int getNo() {
return no;
}
public void setNo(int no) {
this.no = no;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public int getPrice() {
return price;
}
public void setPrice(int price) {
this.price = price;
}
public String getDetail() {
return detail;
}
public void setDetail(String detail) {
this.detail = detail;
}
public String getDate() {
return date;
}
public void setDate(String date) {
this.date = date;
}
public int getStock() {
return stock;
}
public void setStock(int stock) {
this.stock = stock;
}
public String getImage() {
return image;
}
public void setImage(String image) {
this.image = image;
}
}
