jspNo_editForm.jsp
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@ page language="java" contentType="text/html; charset=EUC-KR"
pageEncoding="EUC-KR"%>
<%!
// 문자 셋을 변경하여 한글로 인식하는 메소드 선언
public String a2k(String str){
String result = "";
if(str != null){
try{
result = new String(str.toString().getBytes("KSC5601"),"8859_1");
}
catch(java.io.UnsupportedEncodingException e){
result = "";
}
}
return result;
}
%>
<%
request.setCharacterEncoding("euc-kr");
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=EUC-KR">
<title>jspNo_editForm</title>
</head>
<body>
<center> <!-- </center> -->
<!--
List Page(jspNo.jsp) 에서 넘어 온
id 파라미터 값을 가져오기 -->
<%@ page import="java.sql.*" %>
<%
String id= request.getParameter("id");
String query="Select * From student where id = '"+id +"';";
Connection con = null;
Statement stmt = null;
String driverName = "com.mysql.jdbc.Driver";
String dbURL = "jdbc:mysql://localhost:3306/univdb";
try {
Class.forName(driverName);
con = DriverManager.getConnection(dbURL, "root", "1112");
stmt = con.createStatement();
ResultSet result = stmt.executeQuery(query);
if(result.next()){
%>
<h2><%= result.getString(1)%>님의 정보수정</h2>
<hr width="80%">
</br>
<form name = "editform" method="post" action="jspNo_editOk.jsp">
<table border=2 cellpadding=1>
<tr>
<td align=center><b>아이디</b></td>
<td align=left><b><input type="hidden" name="id" size="20" value="<%= result.getString(1) %>"/><%=result.getString(1)%></b></td>
</tr>
<tr>
<td align=center><b>암호</b></td>
<td align=left><b><input type="password" name="passwd" size="20" value="<%= result.getString(2) %>"/></td>
</tr>
<tr>
<td align=center><b>이름</b></td>
<td align=left><b><input type="text" name="nameT" size="20" value="<%= a2k(result.getString(3)) %>"/></td>
</tr>
<tr>
<td align=center><b>입학년도</b></td>
<td align=left><b><input type="year" name="year" size="20" value="<%= result.getString(4) %>"/></td>
</tr>
<tr>
<td align=center><b>학번</b></td>
<td align=left><b><input type="hakbun" name="hakbun" size="20" value="<%= result.getString(5) %>"/></td>
</tr>
<tr>
<td align=center><b>학과</b></td>
<td align=left><b><input type="major" name="major" size="20" value="<%= a2k(result.getString(6)) %>"/></td>
</tr>
<tr>
<td align=center><b>휴대폰</b></td>
<td align=left><b><input type="text" name="hp1" size="4" value="<%= result.getString(7) %>"/>
- <input type="text" name="hp2" size="9" maxlength="9" value="<%= result.getString(8)%>"/>
</tr>
<tr>
<td align=center><b>주소</b></td>
<td align=left><b><input type="text" name="address" size="50" value="<%= a2k(result.getString(9)) %>"/></td>
</tr>
<tr>
<td align=center><b>이메일</b></td>
<td align=left><b><input type="text" name="email" size="50" value="<%= a2k(result.getString(10)) %>"/></td>
</tr>
<tr>
<td colspan="2">
<input type="submit" value="수정"/>
<input type="reset" value="취소"/>
</td>
</tr>
</table>
</form>
<%
}
}catch(Exception e){
out.println("univdb DataBase Connection has Problem..");
out.println(e.toString());
e.printStackTrace();
}finally{
if(stmt != null)stmt.close();
if(con != null)stmt.close();
}
%>
</center>
</body>
</html>