dao和model

D_StructProp.JAVA

package com.zh.dao;

import android.app.Activity;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

import com.zh.model.M_StructProp;
import com.zh.util.DBHelper;

import java.util.ArrayList;
import java.util.List;

/**
 * Created by Administrator on 2016/11/4.
 */

public class D_StructProp {

    String[] columns = {"prop_id", "input_type", "display_name", "cal_id", "display_order", "prop_remark", "struct_id", "parent_id", "is_delete"};

    public List<M_StructProp> getPropByStructId(Activity activity, String sId) {
        SQLiteDatabase db = DBHelper.openDatabase(activity);
        List<M_StructProp> list = new ArrayList<M_StructProp>();
        Cursor cursor = null;
        if (db != null) {
            cursor = db.query("tb_struct_prop", columns, "struct_id = ?", new String[]{sId}, null, null, "cal_id");
        }
        while (cursor.moveToNext()) {
            M_StructProp i_item = new M_StructProp();

            int prop_id = cursor.getInt(cursor.getColumnIndex("prop_id"));
            int input_type = cursor.getInt(cursor.getColumnIndex("input_type"));
            String display_name = cursor.getString(cursor.getColumnIndex("display_name"));
            int cal_id = cursor.getInt(cursor.getColumnIndex("cal_id"));
            int display_order = cursor.getInt(cursor.getColumnIndex("display_order"));
            String prop_remark = cursor.getString(cursor.getColumnIndex("prop_remark"));
            int struct_id = cursor.getInt(cursor.getColumnIndex("struct_id"));
            int parent_id = cursor.getInt(cursor.getColumnIndex("parent_id"));
            int is_delete = cursor.getInt(cursor.getColumnIndex("is_delete"));

            i_item.setProp_id(prop_id);
            i_item.setInput_type(input_type);
            i_item.setDisplay_name(display_name);
            i_item.setCal_id(cal_id);
            i_item.setDisplay_order(display_order);
            i_item.setProp_remark(prop_remark);
            i_item.setStruct_id(struct_id);
            i_item.setParent_id(parent_id);
            i_item.setIs_delete(is_delete);

            list.add(i_item);

        }
        cursor.close();
        db.close();
        return list;

    }
}

 

package com.zh.model;

/**
 * structure属性表
 */
public class M_StructProp {
   private int prop_id;
   private int input_type;
   private String display_name;//属性名称
   private int cal_id;//控件顺序
   private int display_order;
   private String prop_remark;
   private int struct_id;//structure表id
   private int parent_id;
   private int is_delete;
   
   public int getProp_id() {
      return prop_id;
   }
   public void setProp_id(int prop_id) {
      this.prop_id = prop_id;
   }
   public int getInput_type() {
      return input_type;
   }
   public void setInput_type(int input_type) {
      this.input_type = input_type;
   }
   public String getDisplay_name() {
      return display_name;
   }
   public void setDisplay_name(String display_name) {
      this.display_name = display_name;
   }
   public int getCal_id() {
      return cal_id;
   }
   public void setCal_id(int cal_id) {
      this.cal_id = cal_id;
   }
   public int getDisplay_order() {
      return display_order;
   }
   public void setDisplay_order(int display_order) {
      this.display_order = display_order;
   }
   public String getProp_remark() {
      return prop_remark;
   }
   public void setProp_remark(String prop_remark) {
      this.prop_remark = prop_remark;
   }
   public int getStruct_id() {
      return struct_id;
   }
   public void setStruct_id(int struct_id) {
      this.struct_id = struct_id;
   }
   public int getParent_id() {
      return parent_id;
   }
   public void setParent_id(int parent_id) {
      this.parent_id = parent_id;
   }
   public int getIs_delete() {
      return is_delete;
   }
   public void setIs_delete(int is_delete) {
      this.is_delete = is_delete;
   }
   
}

 

 

 

转载于:https://my.oschina.net/ChrisWolfWu/blog/784997