Java code
request.setCharacterEncoding("UTF-8");
String action = request.getParameter("action");
if (action != null && action.trim().equals("post")) {
String title = request.getParameter("title");
//System.out.println(title);
String cont = request.getParameter("cont");
//System.out.println(cont);
Connection conn = DB.getConn();
boolean autoCommit = conn.getAutoCommit();
conn.setAutoCommit(false);
String sql = "insert into article values(seq_article.nextval,?,?,?,?,sysdate,?)";
PreparedStatement pstmt = DB.prepareStmt(conn, sql,Statement.RETURN_GENERATED_KEYS);
pstmt.setInt(1, 0);
pstmt.setInt(2, 1);
pstmt.setString(3, title);
pstmt.setString(4, cont);
pstmt.setInt(5, 0);
pstmt.executeUpdate();
ResultSet rsKey = pstmt.getGeneratedKeys();
rsKey.next();
int rootId= rsKey.getInt(1);
Statement stmt = DB.createStmt(conn);
stmt.executeUpdate("update article set rootid=" + rootId + " where id="+ rootId);
conn.commit();
conn.setAutoCommit(autoCommit);
DB.close(stmt);
DB.close(pstmt);
DB.close(conn);
response.sendRedirect("article.jsp");
}
%>