무소의 뿔처럼
(교과목 수정)과정평가형 정보처리산업기사 수강신청 도우미 사이트 본문
*주요
lecturerName을 switch(lecturer)로 값을 넣어줌.
<select name="lecturer">
<option value="1" <%=lecturer.equals("1")?"selected":"" %>> 김교수</option>
</select>
요일항목 라디오체크 : 삼항식으로
<input type="radio" name="week" value="1" <%=week.equals("1")?"checked":"" %>>월
수정버튼 눌렀을때 보내준 majorModify.jsp?id=<%=id%> id 값이 있다.
수정.jsp
더보기
<%@page import="course.dbcon"%>
<%@page import="java.sql.*"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
String count ="";
String id = request.getParameter("id");
String name ="";
String credit ="";
String lecturer="";
String lecturerName="";
String week ="";
String weekName="";
String start_hour ="";
String end_hour ="";
try{
con = dbcon.getConnection();
stmt = con.createStatement();
String sql = "select * from course03 where id = "+id;
rs = stmt.executeQuery(sql);
rs.next();
id = rs.getString("id");
name = rs.getString("name");
credit = rs.getString("credit");
lecturer = rs.getString("lecturer");
lecturerName = "";
switch(lecturer){
case "1" : lecturerName = "김교수"; break;
case "2" : lecturerName = "이교수"; break;
case "3" : lecturerName = "박교수"; break;
case "4" : lecturerName = "우교수"; break;
case "5" : lecturerName = "최교수"; break;
case "6" : lecturerName = "강교수"; break;
case "7" : lecturerName = "황교수"; break;
}
week = rs.getString("week");
weekName ="";
switch(lecturer){
case "1" : weekName = "월"; break;
case "2" : weekName = "화"; break;
case "3" : weekName = "수"; break;
case "4" : weekName = "목"; break;
case "5" : weekName = "금"; break;
}
start_hour = rs.getString("start_hour");
end_hour = rs.getString("end_hour");
if(rs!=null) rs.close();
if(stmt!=null) stmt.close();
if(con!=null) con.close();
}catch(Exception e){
e.printStackTrace();
}
%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<jsp:include page="header.jsp"></jsp:include>
<section>
<h3 class="H3_addpage">교과목 수정</h3>
<form action="majorModifyAction.jsp">
<table>
<tr>
<td>교과목 코드</td>
<td><input name="id" value=<%=id %>></td>
</tr>
<tr>
<td>과목명</td>
<td><input name="name" value=<%=name %>></td>
</tr>
<tr>
<td>담당강사</td>
<td>
<select name="lecturer">
<option value="1" <%=lecturer.equals("1")?"selected":"" %>> 김교수</option>
<option value="2" <%=lecturer.equals("2")?"selected":"" %>> 이교수</option>
<option value="3" <%=lecturer.equals("3")?"selected":"" %>> 박교수</option>
<option value="4" <%=lecturer.equals("4")?"selected":"" %>> 우교수</option>
<option value="5" <%=lecturer.equals("5")?"selected":"" %>> 최교수</option>
<option value="6" <%=lecturer.equals("6")?"selected":"" %>> 강교수</option>
<option value="7" <%=lecturer.equals("7")?"selected":"" %>> 황교수</option>
</select>
</td>
</tr>
<tr>
<td>학점</td>
<td><input name="credit" value="<%=credit%>"></td>
</tr>
<tr>
<td>요일</td>
<td>
<input type="radio" name="week" value="1" <%=week.equals("1")?"checked":"" %>>월
<input type="radio" name="week" value="2" <%=week.equals("2")?"checked":"" %>>화
<input type="radio" name="week" value="3" <%=week.equals("3")?"checked":"" %>>수
<input type="radio" name="week" value="4" <%=week.equals("4")?"checked":"" %>>목
<input type="radio" name="week" value="5" <%=week.equals("5")?"checked":"" %>>금
</td>
</tr>
<tr>
<td>시작</td>
<td><input name="start_hour" value="<%=start_hour%>"></td>
</tr>
<tr>
<td>종료</td>
<td><input name="end_hour" value="<%=end_hour%>"></td>
</tr>
</table>
<div class="majorAddBtn">
<input type="button" value="목록" onclick="location.href='index.jsp'">
<input type="button" value="취소">
<input type="submit" value="완료">
</div>
</form>
</section>
<jsp:include page="footer.jsp"></jsp:include>
</body>
</html>
수정액션.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>
<%
String id = request.getParameter("id");
String name = request.getParameter("name");
String credit = request.getParameter("credit");
String lecturer = request.getParameter("lecturer");
String week = request.getParameter("week");
String start_hour = request.getParameter("start_hour");
String end_hour = request.getParameter("end_hour");
Connection con = null;
PreparedStatement pstmt = null;
try{
con = dbcon.getConnection();
String sql = "update course03 set id = ?, " +
"name = ?, "+
"credit = ?, "+
"lecturer = ?, "+
"week = ?, "+
"start_hour = ?, "+
"end_hour = ? " +
"where id= "+id;
pstmt = con.prepareStatement(sql);
pstmt.setString(1, id);
pstmt.setString(2, name);
pstmt.setString(3, credit);
pstmt.setString(4, lecturer);
pstmt.setString(5, week);
pstmt.setString(6, start_hour);
pstmt.setString(7, end_hour);
pstmt.executeUpdate();
response.sendRedirect("index.jsp");
if(pstmt!=null) pstmt.close();
if(con!=null) con.close();
}catch(Exception e){
e.printStackTrace();
}
%>
</body>
</html>
'과정평가_정산기_기록 > 수강신청 도우미 사이트' 카테고리의 다른 글
| (css)과정평가형 정보처리산업기사 수강신청 도우미 사이트 (0) | 2022.02.13 |
|---|---|
| (삭제)과정평가형 정보처리산업기사 수강신청 도우미 사이트 (0) | 2022.02.13 |
| (교과목 추가)과정평가형 정보처리산업기사 수강신청 도우미 사이트 (0) | 2022.02.13 |
| (목록)과정평가형 정보처리산업기사 수강신청 도우미 사이트 (0) | 2022.02.13 |
'과정평가_정산기_기록/수강신청 도우미 사이트' Related Articles
more
Comments