lanmumanage.java

来自「新闻发布系统～～ 做的一个小系统 拿出来与大家分想下～」· Java 代码 · 共 54 行

package news_bean;
import java.sql.*;

public class lanmuManage {
	static Conn conn=new Conn();
	private  String sql;
	private  ResultSet rs;
	int i;
	
	public ResultSet showLanmu(){
		sql = "select * from lanmu;";
		rs = conn.executeQuery(sql);
		return this.rs;
			
	}
	public boolean addLanmu(String name){
		sql = "insert into lanmu(l_name) values('"+name+"');";
		i = conn.executeUpdate(sql);
		if(i>0)
		{
			return true;
		}
		return false;
	}
	public boolean deleLanmu(long id){
		wenzhangManage wm = new wenzhangManage();
		if(wm.deleLanmu(id))
		{
			sql = "delete from lanmu where l_id="+id+"";
			System.out.println(sql);
			i = conn.executeUpdate(sql);
			if(i>0)
			{
				return true;
			}
			return false;
		}
		return false;
	}
	public ResultSet showLM(){
		try{
			sql = "select l_id,l_name from lanmu;";
			rs = conn.executeQuery(sql);
			return rs;
		}catch(Exception e)
		{
			e.printStackTrace();
			return null;
		}
	}


}