jsp完成的bbs简单功能

该项目仅适合初学者，完成了发布，预览，列表等功能。 String title = request.getParameter("title"); String cont = request.getParameter("cont"); String sqlMax = "select Max(rootid) from article"; Connection conn = DB.getConnection(); Statement stmt = DB.getStatement(conn); ResultSet rs = DB.getResultSet(stmt, sqlMax); int max = 0; while (rs.next()) { max = rs.getInt(1); } int max1 = max+1; String sqlInsert = "insert into article values (null,0," + max1 + ",'" + title + "','" + cont + "',now(),0)"; int count = stmt.executeUpdate(sqlInsert); DB.close(rs); DB.close(stmt); DB.close(conn); if(count>0) { response.sendRedirect("bbs.jsp"); }else { out.println("插入失败"); return; }