jsp11.html
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>학생정보 검색</title>
</head>
<body>
<h2>학생정보 검색</h2>
<br>
<form action="jsp12.jsp">
<label for="c">학생코드</label>
<input type="text" name="code" required id="c"><br><br>
<input type="submit" value="조회">
</form>
</body>
</html>jsp12.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" import="java.sql.*"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
request.setCharacterEncoding("utf-8");
String code = request.getParameter("code");
Connection conn = null;
ResultSet rs = null;
Statement stmt = null;
try{
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection
("jdbc:mysql://localhost:3306/test","root","mysql");
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from 학생 where 학생번호='"+code+"';");
while(rs.next()){
String department = rs.getString("소속학과");
String name = rs.getString("학생이름");
String grade = rs.getString("학년");
String gender = rs.getString("성별");
String age = rs.getString("나이");
String phone = rs.getString("전화번호");
String address = rs.getString("주소");
request.setAttribute("CODE", code);
request.setAttribute("DEPT", department);
request.setAttribute("NAME", name);
request.setAttribute("GRADE", grade);
request.setAttribute("GENDER", gender);
request.setAttribute("AGE", age);
request.setAttribute("PHONE", phone);
request.setAttribute("ADDRESS", address);
}
}catch(Exception e){
out.print(e.getMessage());}
finally{
if(conn !=null){
try{
conn.close();
}catch(Exception e){
}
if(stmt != null){
try{
stmt.close();
}
catch(Exception e){ }
}
}
}
RequestDispatcher rd = request.getRequestDispatcher("jsp13.jsp");
rd.forward(request, response);
%>
</body>
</html>jsp13.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>
<style type="text/css">
table{
background-color:#FFFAF0;
border-collapse: collapse;
}
input{
border:none;
}
input:hover{
outline:none;
}
td{
background: white;
text-align: center;
}
span{
color:#FFEBCD;
}
#update{color:#48D1CC; font-weight: bolder;}
#cancle{color:#FF1493; font-weight: bolder;}
</style>
</head>
<body>
<h2>학생정보</h2>
<br>
<from action="jsp14.jsp">
<table border="1">
<tr><th>학생번호</th><td><input type="text" name="code" value="${CODE}"></td></tr>
<tr><th>소속학과</th><td><input type="text" name="dept" value="${DEPT}"></td></tr>
<tr><th>학생이름</th><td><input type="text" name="name" value="${NAME}"></td></tr>
<tr><th>학년</th><td><input type="text" name="grade" value="${GRADE}"></td></tr>
<tr><th>성별</th><td><input type="text" name="gender" value="${GENDER}"></td></tr>
<tr><th>나이</th><td><input type="text" name="age" value="${AGE}"></td></tr>
<tr><th>전화번호</th><td><input type="text" name="phone" value="${PHONE}"></td></tr>
<tr><th>주소</th><td><input type="text" name="address" value="${ADDRESS}"></td></tr>
<tr><td colspan="2">
<input id="update" type="submit" value="수정">
<input id="cancle" type="reset" value="취소">
</td></tr>
</table>
<h6>♥수정하려면 내용을 수정 후 수정버튼을 클릭해주세요!</h6>
</from>
</body>
</html>jsp14.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" import="java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
request.setCharacterEncoding("utf-8");
String code=request.getParameter("code");
String dept=request.getParameter("dept");
String name=request.getParameter("name");
String grade=request.getParameter("grade");
String gender=request.getParameter("gender");
String age=request.getParameter("age");
String phone=request.getParameter("phone");
String address=request.getParameter("address");
Connection conn = null;
Statement stmt = null;
String query = "update 학생 set 소속학과='"+dept+"', 학생이름='"+name+"', 학년='"+grade+"', 성별='"+gender+"', 나이='"+age+"', 주소='"+address+"'where 학생번호='"+code;
try{
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection
("jdbc:mysql://localhost:3306/myschool","root","mysql");
stmt = conn.createStatement();
int res = stmt.executeUpdate(query);
if(res<1){
out.print("수정되지 않았습니당");
}
out.print("");
}catch(Exception e){
out.print(e.getMessage());
}finally{
if(conn !=null){
try{
conn.close();
}catch(Exception e){
}
if(stmt != null){
try{
stmt.close();
}catch(Exception e){
}
}
RequestDispatcher rd = request.getRequestDispatcher("jsp15.jsp");
rd.forward(request, response);
%>
</body>
</html>jsp15.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>
<%
request.setCharacterEncoding("utf-8");
String code = request.getParameter("code");
%>
<form action="jsp12.jsp">
<h2>데이터가 수정되었습니당</h2>
<p>수정된 데이터를 확인하시려면 아래를 클릭해주세요</p>
<a href="jsp12.jsp?code=<%=code%>">학생조회</a>
</form>
</body>
</html>'IT 공부 > JSP' 카테고리의 다른 글
| 회원가입 (Controller, Logic) (0) | 2022.08.08 |
|---|---|
| Database 연동1 (0) | 2022.08.03 |
| Taglib (0) | 2022.08.03 |
| EL (표현언어) (0) | 2022.08.02 |
| Session (0) | 2022.08.02 |