userlimitone.java

jsp编程的源代码

package com.mybean;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.PreparedStatement;
import java.sql.Connection;
import java.util.ArrayList;
import com.myopdb.*;

public class UserLimitOne {

	UserInfo user=new UserInfo();
	private ResultSet rs = null;

	private Statement stmt = null;

	private Connection con = null;

	private PreparedStatement prestmt = null;

	DBCon dbc = new DBCon();

	private ArrayList<Object> lst;

	private int limitid;

	private int userid;

	private String limittext;

	private String typename;

	private String limitservlet;

	private String inputtype;

	public String getInputtype() {
		return inputtype;
	}

	public void setInputtype(String inputtype) {
		this.inputtype = inputtype;
	}

	public int getLimitid() {
		return limitid;
	}

	public void setLimitid(int limitid) {
		this.limitid = limitid;
	}

	public String getLimitservlet() {
		return limitservlet;
	}

	public void setLimitservlet(String limitservlet) {
		this.limitservlet = limitservlet;
	}

	public String getLimittext() {
		return limittext;
	}

	public void setLimittext(String limittext) {
		this.limittext = limittext;
	}

	public String getTypename() {
		return typename;
	}

	public void setTypename(String typename) {
		this.typename = typename;
	}

	public int getUserid() {
		return userid;
	}

	public void setUserid(int userid) {
		this.userid = userid;
	}

	// 得到某个用户的权限
	/**
	 * @param userid
	 * @return lst
	 */
	public ArrayList getUserPower(int userid) {

		UserLimitOne uo = new UserLimitOne();
		lst = new ArrayList<Object>();
		String sql = "select inputtype,typename,limitservlet,limittext from UserLimitOne where userid=?";
		if (this.con == null) {
			this.con = dbc.getCon();
		}
		if (this.con != null) {
			try {
				prestmt = con.prepareStatement(sql,
						ResultSet.TYPE_SCROLL_INSENSITIVE,
						ResultSet.CONCUR_UPDATABLE);
				prestmt.setInt(1, userid);
				rs = prestmt.executeQuery();
				while (rs.next()) {
					uo.setInputtype(rs.getString(1));// 控件的类型
					uo.setTypename(rs.getString(2));// 控件的名字
					uo.setLimitservlet(rs.getString(3));// 相应控件的servlert名字
					uo.setLimittext(rs.getString(4));// 增/删/改/查的文本
					lst.add(uo);
				}
			} catch (SQLException e) {
				// TODO 自动生成 catch 块
				e.printStackTrace();
				return null;
			}

		}
		return lst;
	}
	//更新某个用户的权限
	public boolean updateUserlimit(UserLimitOne uo)
	{
		String sql="update userlimitone set limittext='"+uo.getLimittext()+"' where userid="+uo.getUserid()+"";
		if(this.con==null)
		{
			this.con=dbc.getCon();
		}
		try {
			stmt=con.createStatement();
			stmt.executeUpdate(sql);
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
			return false;
		}
		
		
		
		return true;
		
	}
	public boolean deleteUserlimit(UserLimitOne uo)
	{
		String sql="delete from userlimitone where userid="+uo.getUserid()+"";
		if(this.con==null)
		{
			this.con=dbc.getCon();
		}
		try {
			stmt=con.createStatement();
			stmt.executeUpdate(sql);
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
			return false;
		}
		return true;
		
	}
	public boolean insertUserLimit()
	{
		int userid=user.selectUserid();
		String sql="insert into userlimitone values("+userid+",'null','text','oneservlet','button')";
		if(this.con==null)
		{
			this.con=dbc.getCon();
		}
		try {
			stmt=con.createStatement();
			stmt.executeUpdate(sql);
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
			return false;
		}
		return true;
	}
}