quanxian.java

新闻发布系统

package com.Bean;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;

import com.DB.DBConnection;

public class Quanxian 
{
	private int quanxianID;
	private String quanxianName;
	public int getQuanxianID() {
		return quanxianID;
	}
	public void setQuanxianID(int quanxianID) {
		this.quanxianID = quanxianID;
	}
	public String getQuanxianName() {
		return quanxianName;
	}
	public void setQuanxianName(String quanxianName) {
		this.quanxianName = quanxianName;
	}
	//添加权限
	public boolean addQuanxian()
	{
		String str="insert into quanxian values(?,?)";
		DBConnection db=new DBConnection();
		Connection c=db.getCon();
		try {
			db.ps=c.prepareStatement(str);
			db.ps.setInt(1, this.quanxianID);
			db.ps.setString(2, this.quanxianName);
			db.ps.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return false;
		}
		return true;
	}
	//删除
	public boolean delQuanxian(String sid)
	{
		String str="delete from quanxian where quanxianID="+sid;
		DBConnection db=new DBConnection();
		db.getCon();
		try {
			db.st.executeUpdate(str);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return false;
		}
		return true;
	}
	//更新
	public boolean upQuanxian(String sid)
	{
		String str="update quanxian set quanxianName=? where quanxianID="+sid;
		DBConnection db=new DBConnection();
		Connection c=db.getCon();
		try {
			db.ps=c.prepareStatement(str);
			db.ps.setString(1, this.quanxianName);
			db.ps.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return false;
		}
		
		return true;
	}
	//查询
	public ArrayList selQuanxian()
	{
		ArrayList arr=new ArrayList();
		String str="select * from quanxian";
		Quanxian q=null;
		DBConnection db=new DBConnection();
		db.getCon();
		try {
			db.rs=db.st.executeQuery(str);
			while(db.rs.next())
			{
				q=new Quanxian();
				q.setQuanxianID(db.rs.getInt(1));
				q.setQuanxianName(db.rs.getString(2));
				arr.add(q);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}
		return arr;
	}
}