jizhemanage.java

新闻发布系统～～ 做的一个小系统 拿出来与大家分想下～

package news_bean;
import java.sql.*;

import news_bean.Conn;

public class jizheManage {
	static Conn conn=new Conn();
	private  String sql;
	private  ResultSet rs;
	private int i;
	
	public int deleJizhe(long id )
	{
		try{
			sql = "delete from jizhe where j_id ="+id+" ;";
			i = conn.executeUpdate(sql);
			return i;
		}catch(Exception e)
		{
			e.printStackTrace();
			return -1;
		}
		
		
	}
	public int addJizhe(long id)
	{
		try{
			sql = "UPDATE jizhe SET j_pizhun="+true+" where j_id='"+id+"';";
			i = conn.executeUpdate(sql);
			return i;
		}catch(Exception e)
		{
			e.printStackTrace();
			return -1;
		}
	}
	
}