Previous topicNext topic
 XXXX Help
Help > Modules > database module >

Extend TransactionDataDao and TransactionData Class respectively. An example is shown below.

 

public class TransactionData extends BaseModel {
 private String trace; /* 流水号 */

 private String merchant_name; /* 商户名称 */

 private String merchant_no; /* 商户号 */

 private String terminal_no; /* 终端号 */

 private int func; /* 交易类型 消费,撤销,退货 */

 private String card_number; /* 卡号 */

 private String operatorNo; /* 操作员号 */

 private String exp_date; /* 有效期 */

 private String batch_no; /* 批次号 */

 private String auth_no; /* 授权号 */

 private String date_time; /* 交易时间 */

 private String amount; /* 交易金额 */

 private String ticket_no; /* 票据号 */

 private String referenceNo; /* 参考号 */

 private int status; /* 状态 */
 


 /**
  * @return the trace
  */
 public String getTrace() {
  return trace;
 }

 /**
  * @param trace
  *            the trace to set
  */
 public void setTrace(String trace) {
  this.trace = trace;
 }

 /**
  * @return the merchant_name
  */
 public String getMerchant_name() {
  return merchant_name;
 }

 /**
  * @param merchant_name
  *            the merchant_name to set
  */
 public void setMerchant_name(String merchant_name) {
  this.merchant_name = merchant_name;
 }

 /**
  * @return the merchant_no
  */
 public String getMerchant_no() {
  return merchant_no;
 }

 /**
  * @param merchant_no
  *            the merchant_no to set
  */
 public void setMerchant_no(String merchant_no) {
  this.merchant_no = merchant_no;
 }

 /**
  * @return the terminal_no
  */
 public String getTerminal_no() {
  return terminal_no;
 }

 /**
  * @param terminal_no
  *            the terminal_no to set
  */
 public void setTerminal_no(String terminal_no) {
  this.terminal_no = terminal_no;
 }

 /**
  * @return the func
  */
 public int getFunc() {
  return func;
 }

 /**
  * @param func
  *            the func to set
  */
 public void setFunc(int func) {
  this.func = func;
 }

 /**
  * @return the card_number
  */
 public String getCard_number() {
  return card_number;
 }

 /**
  * @param card_number
  *            the card_number to set
  */
 public void setCard_number(String card_number) {
  this.card_number = card_number;
 }

 /**
  * @return the operatorNo
  */
 public String getOperatorNo() {
  return operatorNo;
 }

 /**
  * @param operatorNo
  *            the operatorNo to set
  */
 public void setOperatorNo(String operatorNo) {
  this.operatorNo = operatorNo;
 }

 /**
  * @return the exp_date
  */
 public String getExp_date() {
  return exp_date;
 }

 /**
  * @param exp_date
  *            the exp_date to set
  */
 public void setExp_date(String exp_date) {
  this.exp_date = exp_date;
 }

 /**
  * @return the batch_no
  */
 public String getBatch_no() {
  return batch_no;
 }

 /**
  * @param batch_no
  *            the batch_no to set
  */
 public void setBatch_no(String batch_no) {
  this.batch_no = batch_no;
 }

 /**
  * @return the auth_no
  */
 public String getAuth_no() {
  return auth_no;
 }

 /**
  * @param auth_no
  *            the auth_no to set
  */
 public void setAuth_no(String auth_no) {
  this.auth_no = auth_no;
 }

 /**
  * @return the date_time
  */
 public String getDate_time() {
  return date_time;
 }

 /**
  * @param date_time
  *            the date_time to set
  */
 public void setDate_time(String date_time) {
  this.date_time = date_time;
 }

 /**
  * @return the amount
  */
 public String getAmount() {
  return amount;
 }

 /**
  * @param amount
  *            the amount to set
  */
 public void setAmount(String amount) {
  this.amount = amount;
 }

 /**
  * @return the ticket_no
  */
 public String getTicket_no() {
  return ticket_no;
 }

 



 

public class TransactionDataDao extends BaseDbManagerDao {

 @Override
 public BaseModel setData(Cursor cursor) {
  // TODO Auto-generated method stub
  if (cursor == null) {
   return null;
  }
  TransactionData datatmp = new TransactionData();
  datatmp.setAmount(getNameByIndex(cursor, "amount"));
  datatmp.setAuth_no(getNameByIndex(cursor, "auth_no"));
  datatmp.setBatch_no(getNameByIndex(cursor, "batch_no"));
  datatmp.setCard_number(getNameByIndex(cursor, "card_number"));
  datatmp.setDate_time(getNameByIndex(cursor, "date_time"));
  datatmp.setExp_date(getNameByIndex(cursor, "exp_date"));
  datatmp.setFunc(Integer.parseInt(getNameByIndex(cursor, "func")));
  datatmp.setMerchant_name(getNameByIndex(cursor, "merchant_name"));
  datatmp.setMerchant_no(getNameByIndex(cursor, "merchant_no"));
  datatmp.setOperatorNo(getNameByIndex(cursor, "operatorNo"));
  datatmp.setReferenceNo(getNameByIndex(cursor, "referenceNo"));
  datatmp.setTerminal_no(getNameByIndex(cursor, "terminal_no"));
  datatmp.setTicket_no(getNameByIndex(cursor, "ticket_no"));
  datatmp.setTrace(getNameByIndex(cursor, "trace"));
  datatmp.setStatus(Integer.parseInt(getNameByIndex(cursor, "status")));
  return datatmp;
 }

 @Override
 public ContentValues getContentValues(BaseModel data) throws BwDatabaseException {
  // TODO Auto-generated method stub
  TransactionData transactionData = (TransactionData)data;
  ContentValues values = new ContentValues();
  values.put("amount", transactionData.getAmount());
  values.put("auth_no", transactionData.getAuth_no());
  values.put("batch_no", transactionData.getBatch_no());
  values.put("card_number", transactionData.getCard_number());
  values.put("date_time", transactionData.getDate_time());
  values.put("exp_date", transactionData.getExp_date());
  values.put("func", String.valueOf(transactionData.getFunc()));
  values.put("merchant_name", transactionData.getMerchant_name());
  values.put("merchant_no", transactionData.getMerchant_no());
  values.put("operatorNo", transactionData.getOperatorNo());
  values.put("referenceNo", transactionData.getReferenceNo());
  values.put("terminal_no", transactionData.getTerminal_no());
  values.put("ticket_no", transactionData.getTicket_no());
  values.put("trace", transactionData.getTrace());
  values.put("status", String.valueOf(transactionData.getStatus()));
  return values;
 }

}

3. Call the methods in TransactionData BaseHandler can achieve the operation of transaction table.