[Error] 빈 화면

2024/10/23

P1

글 입력이 되지않고 빈 화면이 나옴

java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; 
check the manual that corresponds to your MySQL server version for the right syntax to use near 
'vlaues (7,'board','0dcb492f1544495d84dafeb466551c80','sql',now())' at line 3

콘솔창 확인

public int insertFile(Connection conn, BoardFile bf) throws Exception {
		int row = 0;
		String sql = """
					insert into board_file(
						article_no,origin_filename,filename,file_ext,createdate
					) values (?,?,?,?,now())
				""";
		PreparedStatement stmt = conn.prepareStatement(sql);
		stmt.setInt(1, bf.getArticleNo());
		stmt.setString(2, bf.getOriginFilename());
		stmt.setString(3, bf.getFilename());
		stmt.setString(4, bf.getFileExt());
		row=stmt.executeUpdate();
		return row;
	}

sql 쿼리에서 오타 발견

vlaues -> values 수정

글 입력 성공!

정상적으로 작동!