form_columnbean.java

来自「java开发的办公系统 1.系统管理 (地区管理,部门管理,菜单管理,用户管理」· Java 代码 · 共 1,391 行 · 第 1/4 页

package com.vere.form.bean;

	import java.sql.*;
	import java.util.*;
	import com.vere.db.*;
	import com.vere.form.item.*;


	public class Form_columnBean
	{
		private ResultSet rs=null;
		private int keyId;
		private int totalRecord;
		private Access access = null;

		public Form_columnBean()
		{
			try {
				access=new Access();
			}
			catch(Exception e) {
				System.out.println(e.toString());
			}
		}

		/**
		 * @author	Administrator
		 * @param	无
		 * @return	ArrayList:Form_columnItem 对象的 ArrayList 数组
		 * @see		取出 form_column 表中的所有记录,每一条记录存储在一个 Form_columnItem 对象中
		 */
		public List find(){
			ArrayList list=new ArrayList();
			try {
				String sql="select * from "+T.FORM_COLUMN;
				rs = executeQuery(sql);
				while(rs.next()){
					Form_columnItem item=new Form_columnItem();
					item.setId(rs.getString("id"));
					item.setForm_table_id(rs.getString("form_table_id"));
					item.setNodepath(rs.getString("nodepath"));
					item.setField_english_name(rs.getString("field_english_name"));
					item.setField_chinese_name(rs.getString("field_chinese_name"));
					item.setSort_id(rs.getString("sort_id"));
					item.setField_type(rs.getString("field_type"));
					item.setField_width(rs.getString("field_width"));
					item.setField_is_null(rs.getString("field_is_null"));
					item.setField_is_primary(rs.getString("field_is_primary"));
					item.setField_validate(rs.getString("field_validate"));
					item.setJavascript(rs.getString("javascript"));
					item.setIs_query(rs.getString("is_query"));
					item.setIs_show(rs.getString("is_show"));
					item.setDirect_type(rs.getString("direct_type"));
					item.setCom_width(rs.getString("com_width"));
					item.setCom_height(rs.getString("com_height"));
					item.setCom_type(rs.getString("com_type"));
					item.setEdit_type(rs.getString("edit_type"));
					item.setAuto_value(rs.getString("auto_value"));
					item.setGet_value_type(rs.getString("get_value_type"));
					item.setFix_value(rs.getString("fix_value"));
					item.setFix_table(rs.getString("fix_table"));
					item.setFix_column_value(rs.getString("fix_column_value"));
					item.setRow_formula(rs.getString("row_formula"));
					item.setColumn_formula(rs.getString("column_formula"));
					list.add(item);
				}
			}catch(SQLException e){
				System.out.print(e.toString());
			}
			finally{
				DBclose();
			}
			return list;
		}

		/**
		 * @author	Administrator
		 * @param	无
		 * @return	ArrayList:Form_columnItem 对象的 ArrayList 数组
		 * @see		取出 form_column 表中的所有记录,每一条记录存储在一个 Form_columnItem 对象中
		 */
		public List findByIds(String ids){
			ArrayList list=new ArrayList();
			try {
				String sql="select * from "+T.FORM_COLUMN+" where id in ("+ids+")";
				rs = executeQuery(sql);
				while(rs.next()){
					Form_columnItem item=new Form_columnItem();
					item.setId(rs.getString("id"));
					item.setForm_table_id(rs.getString("form_table_id"));
					item.setNodepath(rs.getString("nodepath"));
					item.setField_english_name(rs.getString("field_english_name"));
					item.setField_chinese_name(rs.getString("field_chinese_name"));
					item.setSort_id(rs.getString("sort_id"));
					item.setField_type(rs.getString("field_type"));
					item.setField_width(rs.getString("field_width"));
					item.setField_is_null(rs.getString("field_is_null"));
					item.setField_is_primary(rs.getString("field_is_primary"));
					item.setField_validate(rs.getString("field_validate"));
					item.setJavascript(rs.getString("javascript"));
					item.setIs_query(rs.getString("is_query"));
					item.setIs_show(rs.getString("is_show"));
					item.setDirect_type(rs.getString("direct_type"));
					item.setCom_width(rs.getString("com_width"));
					item.setCom_height(rs.getString("com_height"));
					item.setCom_type(rs.getString("com_type"));
					item.setEdit_type(rs.getString("edit_type"));
					item.setAuto_value(rs.getString("auto_value"));
					item.setGet_value_type(rs.getString("get_value_type"));
					item.setFix_value(rs.getString("fix_value"));
					item.setFix_table(rs.getString("fix_table"));
					item.setFix_column_value(rs.getString("fix_column_value"));
					item.setRow_formula(rs.getString("row_formula"));
					item.setColumn_formula(rs.getString("column_formula"));
					list.add(item);
				}
			}catch(SQLException e){
				System.out.print(e.toString());
			}
			finally{
				DBclose();
			}
			return list;
		}

		/**
		 * @author	Administrator
		 * @param	id: 当前要修改记录的id号
		 * @return	Form_columnItem
		 * @see		取出 form_column 表中的指定id号的一条记录存储在一个 Form_columnItem 对象中
		 */
		public Form_columnItem find(String id){
			try {
				String sql="select  "+T.FORM_COLUMN+".* ,"+T.FORM_TABLE+".chinese_name as  "+T.FORM_TABLE+"_chinese_name  from   "+T.FORM_COLUMN+" ,"+T.FORM_TABLE+"  where "+T.FORM_COLUMN+".form_table_id = "+T.FORM_TABLE+".id  and   "+T.FORM_COLUMN+".id="+id;
				rs = executeQuery(sql);
				Form_columnItem item=new Form_columnItem();
				if(rs.next()){
					item.setId(rs.getString("id"));
					item.setForm_table_id(rs.getString("form_table_id"));
					item.setNodepath(rs.getString("nodepath"));
					item.setField_english_name(rs.getString("field_english_name"));
					item.setField_chinese_name(rs.getString("field_chinese_name"));
					item.setSort_id(rs.getString("sort_id"));
					item.setField_type(rs.getString("field_type"));
					item.setField_width(rs.getString("field_width"));
					item.setField_is_null(rs.getString("field_is_null"));
					item.setField_is_primary(rs.getString("field_is_primary"));
					item.setField_validate(rs.getString("field_validate"));
					item.setJavascript(rs.getString("javascript"));
					item.setIs_query(rs.getString("is_query"));
					item.setIs_show(rs.getString("is_show"));
					item.setDirect_type(rs.getString("direct_type"));
					item.setCom_width(rs.getString("com_width"));
					item.setCom_height(rs.getString("com_height"));
					item.setCom_type(rs.getString("com_type"));
					item.setEdit_type(rs.getString("edit_type"));
					item.setAuto_value(rs.getString("auto_value"));
					item.setGet_value_type(rs.getString("get_value_type"));
					item.setFix_value(rs.getString("fix_value"));
					item.setFix_table(rs.getString("fix_table"));
					item.setFix_column_value(rs.getString("fix_column_value"));
					item.setRow_formula(rs.getString("row_formula"));
					item.setColumn_formula(rs.getString("column_formula"));
					Form_tableItem form_tableItem=new Form_tableItem();
					form_tableItem.setChinese_name(rs.getString(T.FORM_TABLE+"_chinese_name"));
					item.setForm_tableItem(form_tableItem);
				}
				return item;
			}catch(SQLException e){
				System.out.print(e.toString());
				return null;
			}
			finally{
				DBclose();
			}
		}

		/**
		 * @author	Administrator
		 * @param	aItem: 查询的数据对象,page: 翻页时的当前页,pageSize: 翻页的每页显示的记录条数
		 * @return	ArrayList:Form_columnItem 对象的 ArrayList 数组
		 * @see		查出 form_column 表中的指定数据,页号,页大小的每一条记录存储在一个 Form_columnItem 对象中
		 */
		public List find(Form_columnItem aItem,int page,int pageSize){
			int nextPageSize=pageSize*(page-1);
			ArrayList list=new ArrayList();
			try {
				boolean b=false;
				StringBuffer filter=new StringBuffer();
				String fvalue=null;
				fvalue=aItem.getForm_table_id();
				if(fvalue!=null &&   fvalue.length()>0)
				{
					if(b) filter.append(" and");
					filter.append(" "+T.FORM_COLUMN+".form_table_id ="+fvalue+" ");
					b=true;
				}
				fvalue=aItem.getNodepath();
				if(fvalue!=null &&   fvalue.length()>0)
				{
					if(b) filter.append(" and");
					filter.append(" "+T.FORM_COLUMN+".nodepath like '%"+fvalue+"%' ");
					b=true;
				}
				fvalue=aItem.getField_english_name();
				if(fvalue!=null &&   fvalue.length()>0)
				{
					if(b) filter.append(" and");
					filter.append(" "+T.FORM_COLUMN+".field_english_name like '%"+fvalue+"%' ");
					b=true;
				}
				fvalue=aItem.getField_chinese_name();
				if(fvalue!=null &&   fvalue.length()>0)
				{
					if(b) filter.append(" and");
					filter.append(" "+T.FORM_COLUMN+".field_chinese_name like '%"+fvalue+"%' ");
					b=true;
				}
				fvalue=aItem.getSort_id();
				if(fvalue!=null &&   fvalue.length()>0)
				{
					if(b) filter.append(" and");
					filter.append(" "+T.FORM_COLUMN+".sort_id ="+fvalue+" ");
					b=true;
				}
				fvalue=aItem.getField_type();
				if(fvalue!=null &&   fvalue.length()>0)
				{
					if(b) filter.append(" and");
					filter.append(" "+T.FORM_COLUMN+".field_type like '%"+fvalue+"%' ");
					b=true;
				}
				fvalue=aItem.getField_width();
				if(fvalue!=null &&   fvalue.length()>0)
				{
					if(b) filter.append(" and");
					filter.append(" "+T.FORM_COLUMN+".field_width like '%"+fvalue+"%' ");
					b=true;
				}
				fvalue=aItem.getField_is_primary();
				if(fvalue!=null &&   fvalue.length()>0)
				{
					if(b) filter.append(" and");
					filter.append(" "+T.FORM_COLUMN+".field_is_primary ="+fvalue+" ");
					b=true;
				}
				fvalue=aItem.getField_validate();
				if(fvalue!=null &&   fvalue.length()>0)
				{
					if(b) filter.append(" and");
					filter.append(" "+T.FORM_COLUMN+".field_validate like '%"+fvalue+"%' ");
					b=true;
				}
				fvalue=aItem.getJavascript();
				if(fvalue!=null &&   fvalue.length()>0)
				{
					if(b) filter.append(" and");
					filter.append(" "+T.FORM_COLUMN+".javascript like '%"+fvalue+"%' ");
					b=true;
				}
				fvalue=aItem.getIs_query();
				if(fvalue!=null &&   fvalue.length()>0)
				{
					if(b) filter.append(" and");
					filter.append(" "+T.FORM_COLUMN+".is_query ="+fvalue+" ");
					b=true;
				}
				fvalue=aItem.getIs_show();
				if(fvalue!=null &&   fvalue.length()>0)
				{
					if(b) filter.append(" and");
					filter.append(" "+T.FORM_COLUMN+".is_show ="+fvalue+" ");
					b=true;
				}
				fvalue=aItem.getDirect_type();
				if(fvalue!=null &&   fvalue.length()>0)
				{
					if(b) filter.append(" and");
					filter.append(" "+T.FORM_COLUMN+".direct_type like '%"+fvalue+"%' ");
					b=true;
				}
				fvalue=aItem.getCom_width();
				if(fvalue!=null &&   fvalue.length()>0)
				{
					if(b) filter.append(" and");
					filter.append(" "+T.FORM_COLUMN+".com_width like '%"+fvalue+"%' ");
					b=true;
				}
				fvalue=aItem.getCom_height();
				if(fvalue!=null &&   fvalue.length()>0)
				{
					if(b) filter.append(" and");
					filter.append(" "+T.FORM_COLUMN+".com_height like '%"+fvalue+"%' ");
					b=true;
				}
				fvalue=aItem.getCom_type();
				if(fvalue!=null &&   fvalue.length()>0)
				{
					if(b) filter.append(" and");
					filter.append(" "+T.FORM_COLUMN+".com_type like '%"+fvalue+"%' ");
					b=true;
				}
				fvalue=aItem.getEdit_type();
				if(fvalue!=null &&   fvalue.length()>0)
				{
					if(b) filter.append(" and");
					filter.append(" "+T.FORM_COLUMN+".edit_type ="+fvalue+" ");
					b=true;
				}
				fvalue=aItem.getGet_value_type();
				if(fvalue!=null &&   fvalue.length()>0)
				{
					if(b) filter.append(" and");
					filter.append(" "+T.FORM_COLUMN+".get_value_type ="+fvalue+" ");
					b=true;
				}
				fvalue=aItem.getFix_value();
				if(fvalue!=null &&   fvalue.length()>0)
				{
					if(b) filter.append(" and");
					filter.append(" "+T.FORM_COLUMN+".fix_value like '%"+fvalue+"%' ");
					b=true;
				}
				fvalue=aItem.getFix_table();
				if(fvalue!=null &&   fvalue.length()>0)
				{
					if(b) filter.append(" and");
					filter.append(" "+T.FORM_COLUMN+".fix_table like '%"+fvalue+"%' ");
					b=true;
				}
				fvalue=aItem.getFix_column_value();
				if(fvalue!=null &&   fvalue.length()>0)
				{
					if(b) filter.append(" and");
					filter.append(" "+T.FORM_COLUMN+".fix_column_value like '%"+fvalue+"%' ");
					b=true;
				}
				fvalue=aItem.getRow_formula();
				if(fvalue!=null &&   fvalue.length()>0)
				{
					if(b) filter.append(" and");
					filter.append(" "+T.FORM_COLUMN+".row_formula like '%"+fvalue+"%' ");
					b=true;
				}
				fvalue=aItem.getColumn_formula();
				if(fvalue!=null &&   fvalue.length()>0)
				{
					if(b) filter.append(" and");