mariadb 유효성 검사

mariadb 유효성 검사

0개의 답변

Q&A 목록

Question

Mariadb 유효성 검사를 하고 싶은데 코드를 잘 모르겠습니다. <%@ page language="java" contentType="text/html; charset=EUC-KR" pageEncoding="EUC-KR"%> <%@ page import="java.sql.*"%> 게시판 <% Connection conn = null; PreparedStatement pstmt = null; ResultSet rs = null; Class.forName("org.mariadb.jdbc.Driver"); int total = 0; try { conn = DriverManager.getConnection( "jdbc:mariadb://127.0.0.1:3307/board", "root", "1234"); pstmt = conn.prepareStatement(); String sqlCount = "SELECT COUNT(*) FROM board"; rs = pstmt.executeQuery(sqlCount); if (rs.next()) { total = rs.getInt(1); } rs.close(); out.print("총 게시물 : " + total + "개"); String sqlList = "SELECT NUM, USERNAME, TITLE, TIME, HIT from board order by NUM DESC"; rs = pstmt.executeQuery(); %> <% if (total == 0) { %> <% } else { while (rs.next()) { int idx = rs.getInt(1); String name = rs.getString(2); String title = rs.getString(3); String time = rs.getString(4); int hit = rs.getInt(5); %> <% } } rs.close(); pstmt.close(); conn.close(); } catch (Exception e) { e.printStackTrace(); } %>

등록된 글이 없습니다.

"><%=title%>