jFinal的model增删该查

来源：互联网发布：得力dl33113的dat数据编辑：程序博客网时间：2024/04/30 23:14
package com.bytech.model;import java.util.List;import com.jfinal.plugin.activerecord.Db;import com.jfinal.plugin.activerecord.Model;public class Customer extends Model<Customer> {public static final Customer dao=new Customer();public Customer() {// TODO Auto-generated constructor stub}public List<Customer> queryCustomerList(){try {String sql="select * from customer ";return dao.find(sql);} catch (Exception e) {e.printStackTrace();return null;}}//根据客户id查出一条数据public Customer queryCustomerById(String CustomerId){try {String sql="select * from customer where CustomerId=?";return dao.findFirst(sql, CustomerId);} catch (Exception e) {e.printStackTrace();return null;}}//public Customer addCustomer(String CustomerName,String Address,String Contact,String Annotate){try{boolean bret = dao.clear().            set("CustomerName",CustomerName).            set("Address",Address).            set("Contact",Contact).            set("Annotate",Annotate).save();//这些数据直接加入数据中//id则自动递增if(bret){int id = dao.getInt("CustomerId");return dao.findById(id);}else{return null;}}catch(Exception ex){ex.printStackTrace();return null;}}//修改public Customer editCustomer(String CustomerId,String CustomerName,String Address,String Contact,String Annotate){try {String update="UPDATE customer set CustomerName=?,"+ "Address=?,Contact=?,Annotate=? where CustomerId=?";int iRet=Db.update(update,CustomerName,Address,Contact,Annotate,CustomerId);if(iRet > 0){return dao.findById(CustomerId);}else{return null;}}catch(Exception ex){ex.printStackTrace();return null;}}//删除public boolean delectCustomer(String CustomerId){try {String delsql="DELETE FROM customer WHERE CustomerId=?";int iRet=Db.update(delsql, CustomerId);if(iRet > 0){return true;}else{return false;}} catch (Exception e) {e.printStackTrace();return false;}}}
0 0