개발 ON
  • [ ETC/정보처리산업기사 ]
    [정보처리산업기사 | 실기] 지역구의원투표 프로그램
    2023년 08월 14일 02시 32분 50초에 업로드 된 글입니다.
    작성자: 이주여이
    DB Connection은 항상 같은 코드이므로 생략한다.

     

     

    header.jsp, footer,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>
</head>
<body>
<jsp:include page="header.jsp"></jsp:include>

<section style="position: fixed; width: 100%; top: 60px; text-align: center; height: 500px">
<h2 style="align-items: center">과정평가형 자격 CBQ</h2>
</section>

<jsp:include page="footer.jsp"></jsp:include>
</body>
</html>

     

    후보조회

    <%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@include file="DB.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>
</head>
<body>
<jsp:include page="header.jsp"></jsp:include>

<section style="position: fixed; width: 100%; top: 60px; text-align: center; height: 500px">
<h2 style="align-items: center">후보조회</h2>
<form action="" style="display: flex; justify-content: center; align-items: center">
<table border="1">
<tr>
<td>후보번호</td>
<td>성명</td>
<td>소속정당</td>
<td>학력</td>
<td>주민번호</td>
<td>지역구</td>
<td>대표전화</td>
</tr>
<%
request.setCharacterEncoding("UTF-8");

try {
	String sql = "select m.p_code, m.m_name, p.p_name, m.p_school, m.m_jumin, m.m_city, p.p_tel1, p.p_tel2, p.p_tel3 " +
					"from tbl_member_202005 m, tbl_party_202005 p " + 
					"where m.p_code = p.p_code " + 
					"order by m.p_code";
	PreparedStatement pstmt = c.prepareStatement(sql);
	ResultSet rs = pstmt.executeQuery();

	while(rs.next()) {
		String code = rs.getString(1).substring(1, 2);
		String tel1 = rs.getString(7);
		String tel2 = rs.getString(8);
		String tel3 = rs.getString(9);
		String resultTel = tel1 + "-" + tel2 + "-" + tel3;
		String school = rs.getString(4);
		String jumin = rs.getString(5).substring(0, 7) + "-" + rs.getString(5).substring(7,13);
		
		switch(school) {
		case("1"):
			school = "고졸";
			break;
		case("2"):
			school = "학사";
			break;
		case("3"):
			school = "석사";
			break;
		case("4"):
			school = "박사";
			break;
		}
%>
<tr>
<td><%=code %></td>
<td><%=rs.getString(2) %></td>
<td><%=rs.getString(3) %></td>
<td><%=school %></td>
<td><%=jumin %></td>
<td><%=rs.getString(6) %></td>
<td><%=resultTel %></td>
</tr>
<%
	}
} catch(Exception e) {
	e.printStackTrace();
}
%>
</table>
</form>
</section>

<jsp:include page="footer.jsp"></jsp:include>
</body>
</html>

     

    투표하기

    <%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@include file="DB.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>
<script type="text/javascript" src="check.js"></script>
</head>
<body>
<jsp:include page="header.jsp"></jsp:include>

<section style="position: fixed; width: 100%; top: 60px; text-align: center; height: 500px">
<h2 style="align-items: center">투표하기</h2>
<form name="frm" action="action.jsp" style="display: flex; justify-content: center; align-items: center">
<table border="1">
<tr>
<td style="text-align: left">주민번호</td>
<td><input type="number" name="v_jumin"> 예: 8906153154726</td>
</tr>
<tr>
<td>성명</td>
<td style="text-align: left"><input type="text" name="v_name"></td>
</tr>
<tr>
<td>투표번호</td>
<td style="text-align: left">
	<select name="m_no">
		<option value="none"></option>
		<option value="1">1. 김후보</option>
		<option value="2">2. 이후보</option>
		<option value="3">3. 박후보</option>
		<option value="4">4. 조후보</option>
		<option value="5">5. 최후보</option>
	</select></td>
</tr>
<tr>
<td>투표시간</td>
<td style="text-align: left"><input type="number" name="v_time"></td>
</tr>
<tr>
<td>투표장소</td>
<td style="text-align: left"><input type="text" name="v_area"></td>
</tr>
<tr>
<td>유권자확인</td>
<td style="text-align: left">
<input type="radio" name="v_confirm" value="Y">확인
<input type="radio" name="v_confirm" value="N">미확인
</td>
</tr>
<tr>
<td colspan="2">
<input type="button" value="투표하기" onclick="check()">
<input type="button" value="다시하기" onclick="reset()">
</td>
</tr>
</table>
</form>
</section>

<jsp:include page="footer.jsp"></jsp:include>
</body>
</html>

     

    투표검수조회

    <%@page import="java.text.SimpleDateFormat"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@include file="DB.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>
</head>
<body>
<jsp:include page="header.jsp"></jsp:include>

<section style="position: fixed; width: 100%; top: 60px; text-align: center; height: 500px">
<h2 style="align-items: center">투표검수조회</h2>
<form action="" style="display: flex; justify-content: center; align-items: center">
<table border="1">
<tr>
<td>성명</td>
<td>생년월일</td>
<td>나이</td>
<td>성별</td>
<td>후보번호</td>
<td>투표시간</td>
<td>유권자확인</td>
</tr>
<%
request.setCharacterEncoding("UTF-8");

try {
	String sql = "select v_name, v_jumin, " +
					"to_number(to_char(sysdate,'yyyy'))-to_number('19'||substr(v_jumin,1,2)) v_age, " +
					"m_no, v_time, v_confirm " +
					"from tbl_vote_202005 " +
					"where v_area = '제1투표장'";
	PreparedStatement pstmt = c.prepareStatement(sql);
	ResultSet rs = pstmt.executeQuery();

	while(rs.next()) {
		String jumin = "19" + rs.getString(2).substring(0,2) + "년" + rs.getString(2).substring(2, 4) + "월" + rs.getString(2).substring(4, 6) + "일생";
		String age = "만 " + rs.getString(3) + "세";	
		String gender = rs.getString(2).substring(6, 7);
		String time = rs.getString(5).substring(0, 2) + ":" + rs.getString(5).substring(2,4);
		String result = rs.getString(6);
		if(gender.equals("1")) {
			gender = "남자";
		} else if(gender.equals("2")) {
			gender = "여자";
		}
		if(result.equals("N")) {
			result = "미참여";
		} else if(result.equals("Y")) {
			result = "참여";
		}
%>
<tr>
<td><%=rs.getString(1) %></td>
<td><%=jumin %></td>
<td><%=age %></td>
<td><%=gender %></td>
<td><%=rs.getString(4) %></td>
<td><%=time %></td>
<td><%=result %></td>
</tr>
<%
	}
} catch(Exception e) {
	e.printStackTrace();
}
%>
</table>
</form>
</section>

<jsp:include page="footer.jsp"></jsp:include>
</body>
</html>

     

    후보자등수

    <%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@include file="DB.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>
</head>
<body>
<jsp:include page="header.jsp"></jsp:include>

<section style="position: fixed; width: 100%; top: 60px; text-align: center; height: 500px">
<h2 style="align-items: center">후보자등수</h2>
<form action="" style="display: flex; justify-content: center; align-items: center">
<table border="1">
<tr>
<td>후보번호</td>
<td>성명</td>
<td>총투표건수</td>
</tr>
<%
request.setCharacterEncoding("UTF-8");
try {
	String sql = "select m.m_no, m.m_name, count(v.m_no) lank " +
					"from tbl_member_202005 m, tbl_vote_202005 v " +
					"where v.m_no = m.m_no and v.v_confirm = 'Y' " +
					"group by m.m_no, m.m_name " +
					"order by lank desc";
	PreparedStatement pstmt = c.prepareStatement(sql);
	ResultSet rs = pstmt.executeQuery();
	while(rs.next()) {
%>
<tr>
<td><%=rs.getString(1) %></td>
<td><%=rs.getString(2) %></td>
<td><%=rs.getString(3) %></td>
</tr>
<%
	}
} catch(Exception e) {
	e.printStackTrace();
}
%>
<tr>
</tr>
</table>
</form>
</section>

<jsp:include page="footer.jsp"></jsp:include>
</body>
</html>

     

    저작자표시 비영리 동일조건

    'ETC > 정보처리산업기사' 카테고리의 다른 글

    [정보처리산업기사 | 실기] 백신예약 프로그램  (0) 2023.08.16
    [정보처리산업기사 | 실기] war  (0) 2023.08.15
    [정보처리산업기사 | 필기] pdf  (0) 2023.08.10
    [정보처리산업기사 | 실기] 골프연습장 회원관리 프로그램  (0) 2023.08.10
    [정보처리산업기사 | 실기] 성적관리 프로그램  (0) 2023.08.09
      댓글

    티스토리툴바