java鲜花网站

public String getEmail() { }

return email;

public void setEmail(String email) { this.email = email; }

public String getPassword() { return password; }

public void setPassword(String password) { this.password = password; }

public String getPhone() { return phone;

}

public void setPhone(String phone) { this.phone = phone; }

public int getRoleId() { return roleId; }

public void setRoleId(int roleId) { this.roleId = roleId; }

public int getStatus() { return status;

}

public void setStatus(int status) { this.status = status; }

public int getUserId() { return userId;

}

public void setUserId(int userId) { this.userId = userId; }

public String getUserName() { return userName; }

public void setUserName(String userName) { this.userName = userName; }

}

界面：

留言列表的实现代码如下：

public List findByPage(Pager pager,String keyword) { \+

\messageTitle like '%\+keyword+\and messageId not in (\+

\+

(pager.getCurrentPage()-1)*pager.getPageSize()+\tbl_message where messageTitle like '%\+keyword+\order by messageId) order by messageId desc\; \+

\+ \+

(pager.getCurrentPage()-1)*pager.getPageSize()+\tbl_message order by messageId) order by messageId desc\;

}

PreparedStatement pstmt = null; ResultSet rs = null; Message message = null; Connection conn = null; }else{

sql = \+pager.getPageSize()+\String sql = \;

if(keyword!=null&&!\.equals(keyword)){

sql = \+pager.getPageSize()+\List list = new ArrayList();

}

try {

}

e.printStackTrace();

super.closeAll(conn, pstmt, rs);

message.setMessageDate(rs.getDate(\)); list.add(message); conn = super.getConn();

pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); while(rs.next()){

message=new Message();

AccountDao dao=new AccountDao();

message.setMessageId(rs.getInt(\)); message.setUserId(rs.getInt(\));

Account user=dao.findUserByUserId(message.getUserId()); message.setUser(user);

message.setMessageTitle(rs.getString(\));

message.setMessageContent(rs.getString(\));

} catch (SQLException e) { } finally { }

return list;

留言删除

留言删除的实现代码如下： Javascript:

function deleteMessage(o){

if(window.confirm(\确认删除该留言?\)){

location.href=\+o; } }

function deleteSelect(){ }

JavaBean:

public int deleteMessage(int messageId){ int reg=0;

Connection conn = null;

PreparedStatement pstmt = null;

String sql = \; try{

conn=super.getConn();

pstmt=conn.prepareStatement(sql); pstmt.setInt(1, messageId); reg=pstmt.executeUpdate(); e.printStackTrace();

var obj = document.fom.elements; var flag = 0;

for (var i=0;i

if(flag==0){

}

if(flag==1){

if(confirm(\确定删除所选留言吗?\)){

document.getElementById(\).action }

document.getElementById(\).submit(); alert(\请选中要删除的留言\); return ;

if (obj[i].name == \){ }

if (obj[i].checked==true){ flag = 1; break; }

=\;

}

}catch (SQLException e) {