areamanager.java

应用系统的权限管理

package com.gmdq.user;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.http.HttpServletRequest;

import com.gmdq.connection.SybaseConn;
import com.gmdq.entitybeans.ADArea;

import com.gmdq.util.PageResultSet;

public class AreaManager {
	private HttpServletRequest request;
	private Connection conn;
	private List<ADArea> areaList;
	private String areaName;
	private String cur_page;
	
	public AreaManager(HttpServletRequest request)
	{
		SybaseConn sysbase=new SybaseConn();
		this.request=request;
		conn=sysbase.getConnection();
	}
	public PageResultSet queryArea()
	{
		areaList=new ArrayList<ADArea>();
		areaName=request.getParameter("areaName");
		cur_page=request.getParameter("cur_page");
		if(cur_page==null)
		{
			cur_page="1";
		}
		String sql="select * from adarea where 1=1 ";
		if(areaName!=null)
		{
			if(!areaName.equals(""))
			{
				sql=sql+"and areaname like'%"+areaName+"%'";
			}
		}
		PreparedStatement myPreparedStatement;
		try {
			myPreparedStatement = conn.prepareStatement(sql);
		
		ResultSet myResultSet = myPreparedStatement.executeQuery();
		 while(myResultSet.next())
         {
			ADArea adarea= new ADArea();
			adarea.setAreaid(myResultSet.getInt("areaid"));
			adarea.setAreaName(myResultSet.getString("areaname"));
			adarea.setStatus(myResultSet.getInt("statu"));
			adarea.setX1id(myResultSet.getInt("x1id"));
			adarea.setX1name(myResultSet.getString("x1name"));
			adarea.setX2id(myResultSet.getShort("x2id"));
			adarea.setX2name(myResultSet.getString("x2name"));
			areaList.add(adarea);
			
         }
         }catch (SQLException e) {
 			// TODO Auto-generated catch block
 			e.printStackTrace();
 		}
         PageResultSet dataList = new PageResultSet(areaList, Integer.parseInt(cur_page), 10);
 		 return dataList;
	}
	public void delete(int areaId)
	{
		System.out.println("******"+areaId);
		PreparedStatement myPreparedStatement;
		String sql="delete from adarea where areaid=?";
		try {
			myPreparedStatement=conn.prepareStatement(sql);
			myPreparedStatement.setInt(1, areaId);
			myPreparedStatement.executeUpdate();
			myPreparedStatement.close();
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	public void addArea(HttpServletRequest request)
	{
		
		String areaname=request.getParameter("areaname").trim();
		
		String status=request.getParameter("status").trim();
		String sql="insert  into adarea (areaname,statu) values("+"'"+areaname+"',"+Integer.parseInt(status)+")";
		System.out.println("$$$$$$$$"+sql);
		PreparedStatement myPreparedStatement;
		try {
			myPreparedStatement = conn.prepareStatement(sql);
			myPreparedStatement.executeUpdate();
			myPreparedStatement.close();
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
	public ADArea getAreaByID(int areaId)
	{
		ADArea adarea=new ADArea();
		PreparedStatement myPreparedStatement;
		String sql="select * from adarea where areaid="+areaId;
		System.out.println("&&&&&&&"+sql);
		try {
			myPreparedStatement=conn.prepareStatement(sql);
			
			ResultSet myResultSet = myPreparedStatement.executeQuery();
			while(myResultSet.next())
	         {
	             
	            
				adarea.setAreaName(myResultSet.getString("areaname"));
				adarea.setAreaid(myResultSet.getInt("areaid"));
				adarea.setStatus(myResultSet.getInt("statu"));
				adarea.setX1id(myResultSet.getInt("x1id"));
				adarea.setX1name(myResultSet.getString("x1name"));
				adarea.setX2id(myResultSet.getInt("x2id"));
				adarea.setX2name(myResultSet.getString("x2name"));
	           
	             
	         }
			myPreparedStatement.close();
			
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return adarea;
		
	}
	public void updateArea(HttpServletRequest request)
	{
          String areaname=request.getParameter("areaname").trim();
		
		String status=request.getParameter("status").trim();
		String areaId=request.getParameter("areaid").trim();
		
		String sql="update adarea set areaname='"+areaname+"',statu="+status+" where areaid="+areaId;
		System.out.println("$$$$$$$$"+sql);
		PreparedStatement myPreparedStatement;
		try {
			myPreparedStatement = conn.prepareStatement(sql);
			myPreparedStatement.executeUpdate();
			myPreparedStatement.close();
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	public List<ADArea> getAllArea()
	{
		areaList=new ArrayList();
		String sql="select * from adarea where 1=1";
		PreparedStatement myPreparedStatement;
		try {
			myPreparedStatement = conn.prepareStatement(sql);
		
		ResultSet myResultSet = myPreparedStatement.executeQuery();
		 while(myResultSet.next())
         {
             
            ADArea adarea=new ADArea();
            adarea.setAreaName(myResultSet.getString("areaname"));
			adarea.setAreaid(myResultSet.getInt("areaid"));
			adarea.setStatus(myResultSet.getInt("statu"));
            adarea.setX1id(myResultSet.getInt("x1id"));
            adarea.setX1name(myResultSet.getString("x1name"));
            adarea.setX2id(myResultSet.getInt("x2id"));
            adarea.setX2name(myResultSet.getString("x2name"));
            areaList.add(adarea); 
             
         }
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return areaList;
	}

}