messageoraretion.java

来自「实现论坛的三层架构的监控房间的撒开了地方」· Java 代码 · 共 109 行

package Sms.db;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.sql.Connection;
import Sms.bean.Message;
public class Messageoraretion {

	public Messageoraretion() {}
	/**
	 * 更新数据
	 * @param id
	 * @return
	 */
	public int updateMege(int id){
		int i=1;
		Connection com;
    	PreparedStatement pst;
    	try{
    		String str="update Message ReadSign='2' where id="+id;
    		com=mydb.dbCn();
    		pst=com.prepareStatement(str);
    		pst.setInt(1, id);
    		pst.executeUpdate();
    		i=0;
    	}catch(Exception e){
    		System.out.print(e);
    	}
    	return i;
	}
	
	/**
	 * 删除相关留言
	 * @param id
	 * @return
	 */
	public int delMege(int id){
		int i=1;
		Connection com;
    	PreparedStatement pst;
    	try{
    		String str="delete from Message where id=?";
    		com=mydb.dbCn();
    		pst=com.prepareStatement(str);
    		pst.setInt(1, id);
    		pst.executeUpdate();
    		i=0;
    	}catch(Exception e){
    		System.out.print(e);
    	}
    	return i;
	}
	/**
	 * 添加相关信息
	 * @param message
	 * @return
	 */
	public int addMege(Message message){
		int i=1;
		Connection com;
    	PreparedStatement pst;
    	try{
    		String str="insert into Message (note,sendUname,receiveUname,postTime,readSign) values(?,?,?,?,?)";
    		com=mydb.dbCn();
    		pst=com.prepareStatement(str);
    		pst.setString(1, message.getNote());
    		pst.setString(2, message.getSendUname());
    		pst.setString(3, message.getReceiveUname());
    		pst.setString(4, message.getPostTime());
    		pst.setInt(5, message.getReadSign());
    		pst.executeUpdate();
    		i=0;
    	}catch(Exception e){
    		System.out.print(e);
    	}
    	return i;
	}
	/**
	 * 查询信息
	 * @return
	 */
    public ArrayList findMege(){
    	Connection com;
    	PreparedStatement pst;
    	ResultSet rs;
    	ArrayList<Message>list=new ArrayList<Message>();
    	
    	try{
    		String str="select * from Message order by id desc";
    		com=mydb.dbCn();
    		pst=com.prepareStatement(str);
    		rs=pst.executeQuery();
    		while(rs.next()){
    			Message message=new Message();
    			message.setId(rs.getInt(1));
    			message.setNote(rs.getString(2));
    			message.setSendUname(rs.getString(3));
    			message.setReceiveUname(rs.getString(4));
    			message.setPostTime(rs.getString(5));
    			message.setReadSign(rs.getInt(6));
    			list.add(message);
    		}
    	}catch(Exception e){
    		System.out.print(e);
    	}
    	return list;
    }
}