updateadvnewsbean.java

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

package ynuBean;

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

public class UpdateAdvNewsBean 
{
	private String msg;
	GetDate aDate = new GetDate();
	public UpdateAdvNewsBean()
	{
		//default
	}
	
	public String addAdvice(String content,String adminname)
	{
		try
		{
			ConnectDataBase aConnect = new ConnectDataBase();
			Connection con = aConnect.getconnection();
			Statement sqlstatement = con.createStatement();
			//查找用户的余额
			if(!content.equals(""))
			{	
				String insert = "insert into Advice (content,date,adminname) " +
					"values('"+content+"','"+aDate.getYearAndMonthAndDay()+"','"+adminname+"')";
				sqlstatement.executeUpdate(insert);	
				msg="发布成功";
			}
			else
			{
				msg="没有输入发布内容";
			}
			con.close();
		}
		catch (SQLException e) 
    	{
      		System.out.println(e.toString());
      		msg="发布失败";
    	}
    	catch (Exception e) 
    	{
    		System.out.println(e.toString());
    		msg="发布失败";
    	}
    	
		return msg;
	}
	
	public String addNews(String title,String content,String adminname)
	{
		try
		{
			ConnectDataBase aConnect = new ConnectDataBase();
			Connection con = aConnect.getconnection();
			Statement sqlstatement = con.createStatement();
			if(!title.equals("")&&!content.equals(""))
			{
				String insert = "insert into News (title,content,reportdate,adminname) " +
					"values('"+title+"','"+content+"','"+aDate.getYearAndMonthAndDay()+"'," +
							"'"+adminname+"')";
				sqlstatement.executeUpdate(insert);
				msg="发布成功";
			}
			else if(title.equals(""))
			{
				msg="没有输入标题";
			}
			else if(content.equals(""))
			{
				msg="没有输入发布内容";
			}
			
			con.close();
		}
		catch (SQLException e) 
    	{
      		System.out.println(e.toString());
      		msg="发布失败";
    	}
    	catch (Exception e) 
    	{
    		System.out.println(e.toString());
    		msg="发布失败";
    	}
    	
		return msg;
	}
	
	public String DeleteNews(String title)
	{
		try
		{
			ConnectDataBase aConnect = new ConnectDataBase();
			Connection con = aConnect.getconnection();
			Statement sqlstatement = con.createStatement();
			String delete = "delete from news where title='"+title+"'";
			sqlstatement.executeUpdate(delete);
			msg="删除成功";
			con.close();
		}
		catch (SQLException e) 
    	{
      		System.out.println(e.toString());
      		msg="删除失败";
    	}
    	catch (Exception e) 
    	{
    		System.out.println(e.toString());
    		msg="删除失败";
    	}
    	
		return msg;
	}
	
	public String DeleteAdvice(int advicenum)
	{
		try
		{
			ConnectDataBase aConnect = new ConnectDataBase();
			Connection con = aConnect.getconnection();
			Statement sqlstatement = con.createStatement();
			String delete = "delete from advice where advicenum='"+advicenum+"'";
			sqlstatement.executeUpdate(delete);
			msg="删除成功";
			con.close();
		}
		catch (SQLException e) 
    	{
      		System.out.println(e.toString());
      		msg="删除失败";
    	}
    	catch (Exception e) 
    	{
    		System.out.println(e.toString());
    		msg="删除失败";
    	}
    	
		return msg;
	}
	
	public Advice getAdvice(int advicenum)
	{
		Advice aAdvice=null;
		try
		{
			ConnectDataBase aConnect = new ConnectDataBase();
			Connection con = aConnect.getconnection();
			Statement sqlstatement = con.createStatement();
			String query = "select * from advice where advicenum='"+advicenum+"'";
			ResultSet rs = sqlstatement.executeQuery(query);
			
			while(rs.next())
			{
				int num = rs.getInt("advicenum");
				String content = rs.getString("content");
				String datetime = rs.getString("date");
				String adminname = rs.getString("adminname");
				aAdvice = new Advice(num,content,datetime,adminname);
			}
			
			con.close();
		}
		catch (SQLException e) 
    	{
      		System.out.println(e.toString());
    	}
    	catch (Exception e) 
    	{
    		System.out.println(e.toString());
    	}
    	
    	return aAdvice;
	}
}