Struts2+oracle enable administrators to view user-submitted comment features

Talk about requirements: This function is similar to the mail function, when the user submits some suggestions and comments in the site. In the background, it is stored in the Oracle database. The administrator then logs in to the site and sees comments and suggestions that have not been read and read, and is able to mark unread comments and suggestions as read.

Following. This is the administrator's viewing interface:

Click Read to switch to this interface:

The following starts the code to be posted.

First we need a tab switch tab, CSS code such as the following:

. TabPanel ul{height:30px;border-bottom:1px solid #aaa;}. TabPanel ul li{float:left;margin:0 2px 0 0;border:1px solid #aaa; Font-size:14px;height:29px;line-height:30px;width:111px;text-align:center;cursor: pointer;text-shadow:0 1px 0 #fff; border-radius:4px 4px 0 0;box-shadow:inset 0 1px 0 rgba (255, 255, 255, 0.5); background: #ddd; background:-moz-lin Ear-gradient (Top, #eee, #ddd), background:-webkit-gradient (linear, left top, left bottom, from (#eee), to (#ddd));}. TabPanel. hit{border-bottom:1px solid #fff; cursor:pointer;color:black;text-shadow:0 1px 0 #fff; background: #fff; background:-webkit-gradient (linear, left top, left bottom, from (#e1e1e1), to (#fff)); Background:-moz-linear-gradient (Top, #e1e1e1, #fff);}. pane{border:1px solid #aaa; Border-top:0;min-height:100px;background-color: #fff;d isplay:none;}. Pane p{padding:15px 15px 0 10px;}. Pane h4{padding:15px 15px 0 10px;font-size:18px;font-weight:bold;}

Also need a small section of JS to control the Tab tab, give it hit the class and remove hits the class has finished clicking Toggle Effect:

<script type= "Text/javascript" >$ (function () {$ ('. TabPanel ul li '). Click (function () {$ (this). addclass (' hit '). Siblings (). Removeclass (' hit '), $ ('. Panes>div:eq (' +$ (This). Index () + ') '). Show (). siblings (). Hide ();})}) </script>

This part is found on the Internet and you can write a suitable one yourself.

The HTML template code for the tab is as follows:

<div class= "TabPanel" ><ul><li class= "hit" >Tab1</li><li>Tab2</li><li> Tab3</li></ul><div class= "panes" ><div class= "Pane" style= "Display:block;" >

The front end part is roughly finished!
Then write backstage.
First, let's look at the table structure of the database:

Then write the action code based on this table field. In this case, we have two main operations, one is to query out all the data in the table and then put it in two tab options, and the second is to mark the information you have seen as read. Here I just write an action class that uses the Flag field to infer which action to take. The first action occurs when Flag=1, and a second operation when Flag=3.
So my action class code such as the following:
Package Com.cn.useraction;import Java.sql.connection;import Java.sql.drivermanager;import Java.sql.preparedstatement;import Java.sql.resultset;import Java.sql.sqlexception;import java.util.ArrayList; Import Java.util.list;import Java.util.map;//import Javax.servlet.http.httpservletrequest;import Org.apache.commons.logging.log;import Org.apache.commons.logging.logfactory;import Com.opensymphony.xwork2.actioncontext;import Com.opensymphony.xwork2.actionsupport;import Com.cn.beans.UserBean; Import com.cn.util.DBConnection; @SuppressWarnings ({"Serial", "unused"}) public class Admincommentaction extends Actionsupport {private static log log = Logfactory.getlog (admincommentaction.class);p rivate list<userbean> Userlist;private string Commentid;private string flag;static int i = 0;public string Getcommentid () {return commentid;} public void Setcommentid (String commentid) {this.commentid = Commentid;} Public String Getflag () {return flag;} public void Setflag (String flag) {This.flag = flag;} PuBlic list<userbean> getuserlist () {return userlist;} public void Setuserlist (list<userbean> userlist) {this.userlist = userlist;} /** * View User comments and Suggestions * * @return list<userbean> List */private list<userbean> admincomment () {log.info ("get admin Comment info ... "); list<userbean> list = new arraylist<userbean> (); UserBean user; String Sql=null; Connection conn = Dbconnection.getconn (); sql = "SELECT * from Ts_comment ORDER by create_date Desc"; PreparedStatement pstmt;try {pstmt = conn.preparestatement (sql); ResultSet rs = Pstmt.executequery (); while (Rs.next ()) {user = new UserBean (); User.setusername (rs.getstring ("username") ), User.setcontact (rs.getstring ("Contact")), User.setcomment (rs.getstring ("commented")), User.setcommentid ( Rs.getstring ("comment_id")), User.setadminflag (rs.getstring ("Admin_flag")), User.setdate (rs.getstring ("Create_ Date ")); List.add (user);}} catch (SQLException e) {e.printstacktrace ();} return list;} /** * Administrator Tag Read * * @return i */private static int aDminflagupdate (String commentid) {Connection conn = Dbconnection.getconn (); String sql=null;sql = "Update ts_comment set admin_flag=1 where comment_id= '" +commentid+ ""; PreparedStatement pstmt;try {pstmt = conn.preparestatement (sql); i = Pstmt.executeupdate (); System.out.println ("Update resutl:" + i);p stmt.close (); Conn.close ();} catch (SQLException e) {e.printstacktrace ();} return i;} Public String admin_comment () throws Exception {log.info ("admin_comment.action ..."), if (Flag.equals ("3")) {//tag read System.out.println (Commentid), Adminflagupdate (Commentid), if (i==0) {return "error";} else {return "Success_read";}} else {userlist = Admincomment (), if (userlist.size () > 0) {return "success";} else {return "error";}}}

Userbean I will not post, just a few get and set.
The foreground code that triggers this action, such as the following (that is, jumping from one interface to the interface):
<input style= "cursor:pointer;border-radius:4px 4px 4px 4px;padding:5px;width:100%;margin:2px 0;" type= "button" onclick= "window.location.href= ' admin_comment.action?flag=0 '" value= "View User opinion suggestions" >

In addition, here is a small trick, that is, I clicked "marked as read" after the direct page refresh, display the results of the operation, without jumping to other interfaces. It's a struts2 action. Jumps to the function that has an action, that is, after the action of the second action is completed, jumps to the action of the first action. In this, Struts.xml should be configured like this:
<action name= "admin_comment" class= "com.cn.useraction.AdminCommentAction" method= "Admin_comment" ><result Name= "Success" >/admin_comment.jsp</result><result name= "Success_read" type= "Redirectaction" >/ Admin_comment.action?flag=1</result><result name= "Error" >/error.jsp</result></action>

End of background.
Finally, the front end is displayed.
I am from the background to the unread data and read data (in the database Admin_flag each equal 0 and 1) are queried out, in front of the need to classify the display, this time to use the STRUTS2 <s:if> tag, that is, admin_flag=0 data put into the unread, Data equal to 1 is placed in the read.
Finally, add some CSS effects to form the above look.
This part of the front-end code such as the following (replace the template Code above tab tab):
<div class= "TabPanel" style= "width:900px;margin:30px auto;" ><ul style= "List-style:none;" ><li class= "hit" > Unread </li><li> Read </li></ul><div class= "panes" ><div class= " Pane "style=" Display:block; " >

This completes the whole process from front to back and back to front. The effect is still good!
 
Struts2+oracle enable administrators to view user-submitted comment features