[컴퓨터공학]숙명여자대학교 학사 정보 관리 시스템설계
- 등록일 / 수정일
- 페이지 / 형식
- 자료평가
- 구매가격
- 2010.08.03 / 2019.12.24
- 67페이지 / zip (압축파일)
- 평가한 분이 없습니다. (구매금액의 3%지급)
- 3,000원
추천 연관자료
- 목차
-
I. 프로젝트 명
II. 요구사항
1. 데이터 명세
2. 기능 명세
1) 교수
-Use case diagram
2) 학생
-Use case diagram
III. 시스템 설계
1. 클래스 설계
IV. 업무 분담
V. 캡쳐화면
VI. 소스코드
VII. 참고문헌
- 본문내용
-
<%@ page contentType="text/html; charset=EUC-KR" %>
<%@ page import="java.sql.*" %>
<html>
<head></head>
<body>
<%
String dbdriver="oracle.jdbc.driver.OracleDriver";
String dburl="jdbc:oracle:thin:@localhost:1521:SYSTEM";
String user="project";
String passwd="oracle";
Class.forName(dbdriver);
Connection myConn = DriverManager.getConnection (dburl, user, passwd);
Statement stmt = myConn.createStatement();
String mySQL = "select distinct(c_id), c_name from course";
ResultSet rs = stmt.executeQuery(mySQL);
%>
<FORM NAME="FORM" METHOD="POST" ACTION="p_insert_content.jsp" TARGET="inner_content">
<table align="center" border cellpadding="0" cellspacing="0" width="760" bordercolor="gray" bordercolordark="white" bordercolorlight="gray">
<td width="300" bgcolor="#4C6BC0"><p align="center"><font face="굴림" size="2" color="white"><b>강 의 시 간 표 입 력</b></font></td>
<td width="100" bgcolor="#EFEFEF"><p align="center"><font face="굴림" size="2">년도</font></td>
<td width="100"><p align="center"><font face="굴림" size="2" color="blue"><input type="text" name="tyear" value="2010" maxlength="4" size="4"></FONT></TD>
<td width="100" bgcolor="#EFEFEF"><p align="center"><font face="굴림" size="2">학기</font></td>
<td width="100"><p align="center"><font face="굴림" size="2"><select name="tsemester" style="border-width:1px; border-color:gray; border-style:solid;">
<OPTION VALUE="1" SELECTED>1학기</OPTION>
<OPTION VALUE="2">2학기</OPTION>
</SELECT>
</FONT>
</TD>
</TR>
</TABLE>
<table align="center" border cellpadding="2" cellspacing="0" width="760" bordercolor="gray" bordercolordark="white" bordercolorlight="gray">
<tr><td width="80" bgcolor="#EFEFEF"><p align="center"><font face="굴림" size="2">과목선택</font></td>
<td width="460" colspan="5"><p align="center"><font size="2" color="black">
<select name="c_id" style="border-width:1px; border-color:gray; border-style:solid;">
<OPTION VALUE="0" SELECTED>선택해주세요</OPTION>
<%
if (rs != null) {
while (rs.next()) {
String c_id = rs.getString("c_id");
String c_name = rs.getString("c_name");
%>
<OPTION VALUE=<%=c_id%>><%=c_name%></OPTION>
<%
}
}
%>
</SELECT>
</font></td>
<td width="100"><p align="center"><font size="2" color="#2733D5">
<input type="submit" name="SUBMIT_BUTTON" value="확인"></font></td>
</tr></TABLE>
</FORM>
</body>
</html>
P_insert_content.jsp (교수 강의 등록 – 세부 사항 선택)
<%@ page contentType="text/html; charset=EUC-KR" %>
<%@ page import="java.sql.*" %>
<%
String c_id = request.getParameter("c_id");
String dbdriver="oracle.jdbc.driver.OracleDriver";
String dburl="jdbc:oracle:thin:@localhost:1521:SYSTEM";
String user="project";
String passwd="oracle";
Class.forName(dbdriver);
Connection myConn = DriverManager.getConnection (dburl, user, passwd);
Statement stmt = myConn.createStatement();
String mySQL = "select c_id_no from course where c_id='" + c_id + "'";
ResultSet rs = stmt.executeQuery(mySQL);
%>
<html><head><title>수강신청 입력</title></head>
<body>
<table align="center" border cellpadding="0" cellspacing="0" width="760" bordercolor="gray" bordercolordark="white" bordercolorlight="gray">
<FORM method="post" action="p_insert_verify.jsp" >
<tr>
<td width="80" bgcolor="#EFEFEF"><p align="center"><font face="굴림" size="2">분반</font></td>
<td><p align="center"><font face="굴림" size="2"><select name="c_id_no" style="border-width:1px; border-color:gray; border-style:solid;">
<option value="0" selected>선택하세요</option>
<%
if (rs != null) {
while (rs.next()) {
String c_id_no = rs.getString("c_id_no");
%>
<OPTION VALUE=<%=c_id_no%>><%=c_id_no%></OPTION>
<%
}
}
%>
</SELECT>
</font></td>
<td width="80" bgcolor="#EFEFEF"><p align="center"><font face="굴림" size="2">정원</font></td>
<td><div align="center"><input type="text" name="tmax" size="10"></div></td>
<td width="80" bgcolor="#EFEFEF" align="center"><p align="center"><font face="굴림" size="2">강의장소</font></td>
<td colspan="2"><p align="center"><font face="굴림" size="2">
<select name="where" style="border-width:1px; border-color:gray; border-style:solid;">
<OPTION VALUE="myungshin401" SELECTED>myungshin401</OPTION>
<OPTION VALUE="myungshin402">myungshin402</OPTION>
<OPTION VALUE="myungshin403">myungshin403</OPTION>
<OPTION VALUE="myungshin404">myungshin404</OPTION>
<OPTION VALUE="myungshin405">myungshin405</OPTION>
</SELECT>
</FONT>
</TD>
</tr>
<tr>
<td width="80" bgcolor="#EFEFEF" align="center"><p align="center"><font face="굴림" size="2">강의시간</font></td>
<td width="80" align="center"><p align="center"><font face="굴림" size="2"><select name="day1" style="border-width:1px; border-color:gray; border-style:solid;">
<OPTION VALUE="mon" SELECTED>mon</OPTION>
<OPTION VALUE="tue">tue</OPTION>
<OPTION VALUE="wed">wed</OPTION>
<OPTION VALUE="thu">thr</OPTION>
<OPTION VALUE="fri">fri</OPTION>
</SELECT>
</FONT>
</TD>
<td width="80"><p align="
- 참고문헌
-
- <데이터베이스 이론과 실전사이 Oracle9i중심> 심준호 저.
- 성윤정 저.
-이지선 장병옥 저.
- <자바 웹 프로그래밍> 황희정 저.
자료평가
-
아직 평가한 내용이 없습니다.