언어/Servlet&Jsp
DB연동 jsp
NIGHT_LOVE
2020. 5. 19. 17:37
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<%
String dept_id =request.getParameter("dept_id");
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@localhost:1521:company";
Connection conn = DriverManager.getConnection(url, "scott", "1234");
String strSql="select * from dept where dept_id=?";
PreparedStatement stmt = conn.prepareStatement(strSql);
stmt.setString(1, dept_id);
ResultSet rs =stmt.executeQuery();
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
while(rs.next()){
%>
<table border ="1">
<tr>
<td>부서번호</td><td><%=rs.getString("dept_id")%> </td>
</tr>
<tr>
<td>부서명</td><td><%=rs.getString("dept_name") %> </td>
</tr>
<tr>
<td>위치코드</td><td><%=rs.getString("loc_id") %> </td>
</tr>
</table>
<% }%>
<br>
<a href="">수정</a> <a href="list.jsp">목록</a> <a href="delete.jsp?dept_id=<%=dept_id%>">삭제</a>
</body>
</html><%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<%
String dept_id=request.getParameter("dept_id");
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@localhost:1521:company";
Connection conn = DriverManager.getConnection(url, "scott", "1234");
String strSql="delete from dept where dept_id =?";
PreparedStatement stmt = conn.prepareStatement(strSql);
stmt.setInt(1,Integer.parseInt(dept_id));
stmt.executeUpdate();
stmt.close();
response.sendRedirect("list.jsp");
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>삭제하기</title>
</head>
<body>
</body>
</html><%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<%
String dept_id=request.getParameter("dept_id");
String dept_name=request.getParameter("dept_name");
String loc_id=request.getParameter("loc_id");
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@localhost:1521:company";
Connection conn = DriverManager.getConnection(url, "scott", "1234");
String strSql="insert into dept values(?,?,?)";
PreparedStatement stmt = conn.prepareStatement(strSql);
stmt.setInt(1,Integer.parseInt(dept_id));
stmt.setString(2,dept_name);
stmt.setInt(3,Integer.parseInt(loc_id));
stmt.executeUpdate();
stmt.close();
conn.close();
//out.print("Saved item");
response.sendRedirect("list.jsp");
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
</body>
</html><%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>DEPT INSERT</title>
</head>
<body>
<form action="insertProcess.jsp" method ="get">
부서번호 :<input type = "text" name="dept_id"><br>
부서명 :<input type = "text" name="dept_name"><br>
위치코드 :<input type = "text" name="loc_id"><br>
<input type="submit" value="저장">
<input type="reset" value="다시입력">
</form>
</body>
</html><%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<%
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@localhost:1521:company";
Connection conn = DriverManager.getConnection(url, "scott", "1234");
String strSql="select * from dept order by dept_id desc";
PreparedStatement stmt = conn.prepareStatement(strSql);
ResultSet rs =stmt.executeQuery();
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>DEPT LIST</title>
</head>
<body>
<a href ="insert.jsp">추가</a>
<table border=1>
<tr>
<td> 부서번호 </td> <td>부서명</td><td>위치코드</td> <td>유무</td>
</tr>
<%
while(rs.next()){
%>
<tr>
<td><%=rs.getInt("DEPT_ID") %></td>
<td><a href="view.jsp?dept_id=<%=rs.getInt("DEPT_ID") %>">
<%=rs.getString("DEPT_NAME") %>
</a></td>
<td><%=rs.getInt("LOC_ID") %></td>
<td><a href="delete.jsp?dept_id=<%=rs.getInt("DEPT_ID") %>">삭제</a></td>
</tr>
<%}
rs.close();
conn.close();
%>
</table>
</body>
</html>