replybean.java

来自「该系统具体分为2个部分：前台和后台。 1．前台主要用于用户进行浏览和搜索」· Java 代码 · 共 73 行

package ynuBean;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.*;

public class ReplyBean 
{
	public ReplyBean()
	{
		//default
	}
	
	public String insertReply(ReplyEntity aReplyEntity)
	{
		String result="";
		try
		{
			ConnectDataBase aConnect = new ConnectDataBase();
			Connection con = aConnect.getconnection();
			Statement sqlstatement = con.createStatement();
			// 查找该用户的定单
			String insert="insert into replyofuser (title,username,replydate,replycontent)" +
					" values('"+aReplyEntity.getTitle()+"'," +
							"'"+aReplyEntity.getUserName()+"'," +
							"'"+aReplyEntity.getDate()+"'," +
							"'"+aReplyEntity.getReplyContent()+"')";

			sqlstatement.executeUpdate(insert);
			result="发表成功";
			con.close();
		} catch (SQLException e) {
			System.out.println(e.toString());		
		} catch (Exception e) {
			System.out.println(e.toString());
		}
		return result;
	}
	
	public ArrayList getReply(String aTitle)
	{
		ArrayList aArrayList = new ArrayList();
		try
		{
			ConnectDataBase aConnect = new ConnectDataBase();
			Connection con = aConnect.getconnection();
			Statement sqlstatement = con.createStatement();
			// 查找该用户的定单
			String query="select * from replyofuser where title='"+aTitle+"'";
			ResultSet rs = sqlstatement.executeQuery(query);
			
			while(rs.next())
			{
				String username= rs.getString("username");
				String replydate = rs.getString("replydate");
				String replycontent = rs.getString("replycontent");
				
				ReplyEntity aReplyEntity = new ReplyEntity(aTitle,username,replydate,replycontent);
				aArrayList.add(aReplyEntity);
			}
			
			con.close();
		} catch (SQLException e) {
			System.out.println(e.toString());		
		} catch (Exception e) {
			System.out.println(e.toString());
		}
		return aArrayList;
	}
}