1. create문

create table tableboard_ ( id varchar(20) not null, ilsi datetime not null, article varchar(200) not null);

2.board.jsp

<%@ page contentType = "text/html; charset=euc-kr" %>
<%@ page import ="java.sql.*" %>
<%
try{
Class.forName("com.mysql.jdbc.Driver");
Connection cc = DriverManager.getConnection("jdbc:mysql://localhost:3306/aaa","root","mysql");
PreparedStatement pp = cc.prepareStatement("select * from tableboard_ order by ilsi desc");
ResultSet rr = pp.executeQuery();
%>
<h1>게시판</h1>
<table border = "1">
<%
while(rr.next()){
	%><tr>
		<td><strong><%=rr.getString("id") %></strong><br><font size="0.5em" color="grey"><%=rr.getString("ilsi") %></td></font><td><%=rr.getString("article") %></td>
	</tr>
<%}%>
</table>
<form method="post" action="post.jsp">
아이디 : <input type="text" name="boardId"> <br>
<textarea name="boardArticle" cols="40" rows="10" placeholder="메세지를 입력하세요" style="overflow:hidden" ></textarea><br>
<input type="submit" value="확인">
</form>

<%
}catch(SQLException ex){
out.print("죄송합니다. DB 문제가 발생했어요. <p>오류메세지: " +
ex.getMessage() );
}
%>

2-2. post.jsp

<%@ page contentType = "text/html; charset=euc-kr" %>
<%@ page import ="java.sql.*" %>
<%
try{
	request.setCharacterEncoding("euc-kr");
	String id = request.getParameter("boardId");
	String article = request.getParameter("boardArticle");
Class.forName("com.mysql.jdbc.Driver");
Connection cc = DriverManager.getConnection("jdbc:mysql://localhost:3306/aaa","root","mysql");
PreparedStatement pp = cc.prepareStatement("insert into tableboard_ values(?,sysdate(),?)");
pp.setString(1, id);
pp.setString(2,article);
pp.executeUpdate();

response.sendRedirect("Board.jsp");
}catch(SQLException ex){
out.print("죄송합니다. DB 문제가 발생했어요. <p>오류메세지: " +
ex.getMessage() );
}
%>