CLASS/JSP

#1-2 / database jsp로 연결

hingu 2024. 6. 24. 15:57

정통은 이렇게 쓰진 않는다~ 절대루 ~ 보안👎

걍 해보는거

⚡ user table 연결 후 table로 출력 - idx 내림차순
 
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%
	//db 연결 정보
	String db_driver = "com.mysql.cj.jdbc.Driver";
	String db_url = "jdbc:mysql://localhost:3306/cms";
	String db_user ="hana";
	String db_pass = "hana1234";
	Class.forName(db_driver);
	Connection dbcon = DriverManager.getConnection(db_url,db_user,db_pass);
	
	String sql = "select * from user order by uidx desc";
    //PreparedStatement : DML(select,insert,update,delete에 주로 사용)
	PreparedStatement ps = dbcon.prepareStatement(sql);
	ResultSet rs = ps.executeQuery();
%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>database jsp로 연결</title>
</head>
<body>
	<table border="1">
		<thead>
			<tr>
				<th>아이디</th>
				<th>고객명</th>
				<th>가입일자</th>
			</tr>
		</thead>
		<tbody>
		<%
			while(rs.next()) {
		
		%>
			<tr>
				<td><%=rs.getString("uid")%></td>
				<td><%=rs.getString("uname")%></td>
				<td><%=rs.getString("ujoin")%></td>
			</tr>
		<%
			}
		%>
		</tbody>
	</table>
</body>
</html>
우왕