Connection conn=DB.getconn();
String sql = "insert into article values (null, ?, ?, ?, ?, now(), ?)";
PreparedStatement pstmt = DB.prepareStmt(conn, sql, Statement.RETURN_GENERATED_KEYS);
pstmt.setInt(1,0);
pstmt.setInt(2,rootid);
pstmt.setString(3,title);
pstmt.setString(4,cont);
pstmt.setInt(5,0);
pstmt.executeUpdate();
ResultSet rekey=pstmt.getGeneratedKeys();
rekey.next();
rootid=rekey.getInt(1);
Statement stmt=DB.createStmt(conn);
stmt.executeUpdate("Update article set rootid="+rootid+ "where id="+rootid);
DB.close(stmt);
DB.close(pstmt);
DB.close(conn);
response.sendRedirect("article.jsp");
}
求高手进来解答啊
