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;
}
}
}
jFinal的model增删该查
最新推荐文章于 2021-03-12 02:47:25 发布