毕业论文目录及正文等(10)

毕业论文（设计）

}

public int updateCount(String messageID){

int count=0;

String sql=\try{

conn = this.getConn();

29

}

public Message selectMessageByID(String messageID) {

Message message = null;

String sql = \try { }

return message;

conn = this.getConn();

pstmt = conn.prepareStatement(sql); pstmt.setString(1, messageID); rs = pstmt.executeQuery(); if (rs.next()) { }

e.printStackTrace(); this.closeAll(conn, pstmt, rs);

message = new Message();

message.setMessageID(rs.getInt(\message.setTitle(rs.getString(\message.setContent(rs.getString(\message.setWriter(rs.getString(\message.setWriteDate(rs.getString(\message.setCount(rs.getInt(\

} catch (Exception e) { } finally {

毕业论文（设计）

}

（4） 网站后台登录界面

}

}

return count;

pstmt = conn.prepareStatement(sql); pstmt.setString(1, messageID); count=pstmt.executeUpdate(); e.printStackTrace();

}catch(Exception e){

代码实现如下： package s2jsp.bysj.dao;

import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import java.util.List;

import s2jsp.bysj.entity.Users;

30

毕业论文（设计）

public class UserDao extends BaseDao {

31

private Connection conn; private PreparedStatement pstmt; private ResultSet rs; /**

* 根据用户名和密码，查找相关用户信息 *

* @param userName * @param password * @return 用户对象 */

public Users findUsers(String userName, String password) {

Users user = null;

String sql = \try {

conn = this.getConn();

pstmt = conn.prepareStatement(sql); pstmt.setString(1, userName); pstmt.setString(2, password); rs = pstmt.executeQuery(); if (rs.next()) {

user = new Users();

user.setUserID(rs.getInt(%user.setUserName(userName); user.setPassword(password); user.setStatus(rs.getInt(\