package com.mybean;

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

public class UserLimitTwo {
	private ResultSet rs = null;

	private Statement stmt = null;

	private Connection con = null;

	private PreparedStatement prestmt = null;
	
UserInfo user=new UserInfo();
	DBCon dbc=new DBCon();
	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;
	}
	
	public ArrayList getUserPower(int userid) {

		UserLimitTwo uo = new UserLimitTwo();
		ArrayList<Object>lst = new ArrayList<Object>();
		String sql = "select inputtype,typename,limitservlet,limittext from UserLimitTwo 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(UserLimitTwo ut)
	{
		System.out.println(ut.getLimittext());
		String sql="update userlimittwo set limittext='"+ut.getLimittext()+"'where userid="+ut.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(UserLimitTwo ut)
	{
		String sql="delete from userlimittwo where userid="+ut.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 userlimittwo 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;
	}
}