form_columnbean.java

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

             
             ArrayList tablesList=new ArrayList();//查询表的查询数据,代表多行row
             while(rs.next()){
             	ArrayList rowList=new ArrayList();//查询表的查询数据,代表一行row
             	rowList.add(rs.getString("id"));
             	for(int i=0;i<listColumn.size();i++)
				{
             		Form_columnItem item=(Form_columnItem)listColumn.get(i);
             		rowList.add(rs.getString(item.getField_english_name()));
				}
             	tablesList.add(rowList);//添加一行row
             }
             list.add(tablesList);//添加一行row
             list.add(table_chinese_name);//表名
             
			}catch(SQLException e){
				System.out.print(e.toString());
			}
			finally{
				DBclose();
			}
			return list;
		}

		public List findD_Column(String form_table_id){
			ArrayList listColumn=new ArrayList();
			String table_name="";
			try {
				String sql="select a.*,b.english_name as table_name from "+T.FORM_COLUMN+" as a,"+T.FORM_TABLE+" as b where a.form_table_id=b.id and a.is_show=2 and b.id="+form_table_id+" order by a.sort_id ";
				rs = executeQuery(sql);
	            while(rs.next()){
	            	table_name=Constants.T_FORM_PRE+rs.getString("table_name");
	                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"));
	                listColumn.add(item);
	            }
	            
			}catch(SQLException e){
				System.out.print(e.toString());
			}
			finally{
				DBclose();
			}
			return listColumn;
		}


		public List find(Form_columnItem aItem){
			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");
					filter.append(" "+T.FORM_COLUMN+".column_formula like '%"+fvalue+"%' ");
					b=true;
				}
				
             String sql="select * from "+T.FORM_COLUMN;
             if(b)
               sql+=" where "+filter.toString()+" order by sort_id ";
             else
                 sql+=" order by sort_id ";
             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	KeyId:插入记录时当前记录的id号
		 * @see		获得插入记录时当前记录的id号
		 */
		public int getKey(){
			return keyId;
		}

		/**
		 * @author	Administrator
		 * @param	无
		 * @return	(totalRecord):插入记录时当前记录的id号
		 * @see		获得插入记录时当前记录的id号
		 */
		public int getTotalRecord(){
	        return totalRecord;
	    }

		/**
		 * @author	Administrator
		 * @param	item:要添加的数据对象Form_columnItem
		 * @return	boolean:是否添加成功,如果添加成功返回true,否则返回false
		 * @see		添加一条记录
		 */
		public boolean addItem(Form_columnItem item){
			try{
				StringBuffer sql=new StringBuffer();
				//声名变量
				String table_name="";
				String sql1="select  * from "+T.FORM_TABLE+" where id="+item.getForm_table_id();
				rs=executeQuery(sql1);
				if(rs.next())
				{
					table_name=rs.getString("english_name");
				}
				if(item.getField_type().equals("varchar"))
				{
					sql.append(" alter table "+Constants.T_FORM_PRE+table_name+" add "+item.getField_english_name()+" "+ item.getField_type()+"("+item.getField_width()+") ");
				}
				else
				{
					sql.append(" alter table "+Constants.T_FORM_PRE+table_name+" add "+item.getField_english_name()+" "+ item.getField_type()+" ");
				}
				
				sql.append(" insert into "+T.FORM_COLUMN+"("+
							"form_table_id,"+
							"nodepath,"+
							"field_english_name,"+
							"field_chinese_name,"+
							"sort_id,"+
							"field_type,"+
							"field_width,"+
							"field_is_null,"+
							"field_is_primary,"+
							"field_validate,"+
							"javascript,"+
							"is_query,"+
							"is_show,"+
							"direct_type,"+
							"com_width,"+