news_manager.java

来自「java语言编写的程序」· Java 代码 · 共 63 行

package cn.lab.business;
import java.util.GregorianCalendar;
import cn.lab.dbquery.DataProcess;
public class News_Manager {
	public static void Add_News(String title,String content)
	{
		GregorianCalendar gc= new GregorianCalendar();
		try{
			title = new String(title.getBytes("ISO8859_1"));
			content = new String(content.getBytes("ISO8859_1"));
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		String query = "insert into news(title,content,datetime)values('"+title+
			"','"+content+"','"+gc.getTime().toLocaleString()+"')";
		try {
			DataProcess.ExeQuery(query);
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	
	public static void Edit_News(String title,String content,int id)
	{
		GregorianCalendar gc = new GregorianCalendar();
		try
		{
			title = new String(title.getBytes("ISO8859_1"));
			content = new String(content.getBytes("ISO8859_1"));
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		String query="update news set title='"+title+"',content='"+content+
			"',datetime='"+gc.getTime().toLocaleString()+"'where id="+id;
		try {
			DataProcess.ExeQuery(query);
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	
	public static void Delete_News(int id)
	{
		String deleteStr="delete from news where id="+id;
		try {
			DataProcess.ExeQuery(deleteStr);
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}

}