[07] 성적테이블 목록, 내용보기
[성적테이블 목록보기]
파일명 : sungjukList.jsp
################################################################
<%@ page contentType="text/html; charset=utf-8"%>
<%@ page import="java.sql.DriverManager"%>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.PreparedStatement"%>
<%@ page import="java.sql.ResultSet"%>
<%
request.setCharacterEncoding("utf-8");
//-------------------------------------------------------------
String url = "jdbc:mysql://localhost:3306/mydb?useUnicode=true&characterEncoding=utf8";
String id = "root";
String pass = "1234";
String driver="org.gjt.mm.mysql.Driver";
Class.forName(driver);
//물리적인 클래스 파일명을 인자로 전달해 주면 이에 해당하는 클래스를 반환해 준다.
Connection con = DriverManager.getConnection(url, id, pass);
//------------------------------------------------------------
String sql = " SELECT sno,uname,kor,eng,mat,aver,address ";
sql = sql + " FROM tb_sungjuk ";
sql = sql + " ORDER BY sno DESC";
PreparedStatement pstmt = con.prepareStatement(sql); //쿼리문 생성
ResultSet rs = pstmt.executeQuery(); // SELECT
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-ｅquiv="Content-Type" content="text/html; charset=utf-8" />
<title> /daum/sungjukList.jsp </title>
</head>
<body>
<center>
** 성적 리스트 **<br>
<table border=1>
<tr>
<td>번호</td>
<td>이름</td>
<td>국어</td>
<td>영어</td>
<td>수학</td>
</tr>
<%
if(rs.next()){
do{
int sno=rs.getInt("sno");
String uname=rs.getString("uname");
int kor=rs.getInt("kor");
int eng=rs.getInt("eng");
int mat=rs.getInt("mat");
int aver=rs.getInt("aver");
String address=rs.getString("address");
%>
<tr>
<td><%=sno%></td>
<td><a href="./sungjukRead.jsp?sno=<%=sno%>"><%=uname%></a></td>
<td><%=kor%></td>
<td><%=eng%></td>
<td><%=mat%></td>
</tr>
<%
}while(rs.next());
}
else{
%>
<tr>
<td colspan="5">관련 자료 없음</td>
</tr>
<%
}
%>
</table>
<a href="./sungjukForm.jsp">[성적등록]</a>
</center>
</body>
</html>
<%
//------------------------------------------------
try {
if (rs != null) {
rs.close();
}
} catch (Exception e) {
}
try {
if (pstmt != null) {
pstmt.close();
}
} catch (Exception e) {
}
try {
if (con != null) {
con.close();
}
} catch (Exception e) {
}
//------------------------------------------------
%>
################################################################
[성적테이블 내용보기]
파일명 : sungjukRead.jsp
################################################################
<%@ page contentType="text/html; charset=utf-8"%>
<%@ page import="java.sql.DriverManager"%>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.PreparedStatement"%>
<%@ page import="java.sql.ResultSet"%>
<%
request.setCharacterEncoding("utf-8");
//-------------------------------------------------------------
String url = "jdbc:mysql://localhost:3306/mydb?useUnicode=true&characterEncoding=utf8";
String id = "root";
String pass = "1234";
String driver="org.gjt.mm.mysql.Driver";
Class.forName(driver);
Connection con = DriverManager.getConnection(url, id, pass);
//------------------------------------------------------------
String sql = " SELECT sno,uname,kor,eng,mat,aver,address ";
sql = sql + " FROM tb_sungjuk ";
sql = sql + " WHERE sno=?";
PreparedStatement pstmt = con.prepareStatement(sql); //쿼리문 지정
int sno = Integer.parseInt(request.getParameter("sno"));
pstmt.setInt(1, sno);
ResultSet rs = pstmt.executeQuery(); // SELECT문 실행
rs.next(); //첫번째 레코드 이동
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-ｅquiv="Content-Type" content="text/html; charset=utf-8">
<title>sungjukRead.jsp</title>
<script type="text/javascript">
<!--
function MoveTo(flag,frm){
switch(flag){
case 'E':
frm.action="./sungjukUpdate.jsp";
frm.submit();
break;
case 'D':
frm.action="./sungjukDelete.jsp";
frm.submit();
break;
case 'L':
location.href="./sungjukList.jsp";
}
}
//-->
</script>
</head>
<body>
<form name="myform" method="post">
<input type="hidden" name="sno" value="<%=sno%>">
이름:<input type="text" name="uname" value="<%=rs.getString("uname")%>"><br>
국어:<input type="text" name="kor" value="<%=rs.getInt("kor")%>"><br>
영어:<input type="text" name="eng" value="<%=rs.getInt("eng")%>"><br>
수학:<input type="text" name="mat" value="<%=rs.getInt("mat")%>"><br>
평균:<input type="text" name="aver" value="<%=rs.getInt("aver")%>" readonly><br>
주소:<input type="text" name="address" value="<%=rs.getString("address")%>"><br>
<input type="button" value="수정" onClick="MoveTo('E',this.form)">
<input type="button" value="삭제" onClick="MoveTo('D',this.form)">
<input type="button" value="목록" onClick="MoveTo('L',this.form)">
</form>
</body>
</html>
<%
//------------------------------------------------
try {
if (rs != null) {
rs.close();
}
} catch (Exception e) {
}
try {
if (pstmt != null) {
pstmt.close();
}
} catch (Exception e) {
}
try {
if (con != null) {
con.close();
}
} catch (Exception e) {
}
//------------------------------------------------
%>
################################################################