java set增删改查_Java的增删改查

增删改一般没有返回值，查询全部一般是list ,根据id查询是返回User对象，

insert into table表 (字段名1，字段名2... )values (值1，值2...);

delete from table表

update table表 set 字段名='要改的值' where 条件...

// 分页查询

PageInfo findByPage(String companyId, int pageNum, int PageSize);

//查询所有部门

List findAll(String companyId);

//保存

void save(User user);

//更新

void update(User user);

//删除

void delete(String id);

//根据id查询

User findById(String id);

用xml方式写sql语句的话：

select * from pe_user where company_id=#{companyId}

select * from pe_user where user_id = #{id}

delete from pe_user where user_id = #{id}

insert into pe_user (user_id, dept_id, email, user_name, password, state, company_id,

company_name, dept_name, manager_id, join_date, salary, birthday,

gender, station, telephone, degree, remark, order_no)

values (#{id}, #{deptId}, #{email}, #{userName}, #{password}, #{state}, #{companyId},

#{companyName}, #{deptName}, #{managerId}, #{joinDate}, #{salary}, #{birthday},

#{gender}, #{station}, #{telephone}, #{degree}, #{remark}, #{orderNo})

update pe_user

set dept_id = #{deptId},

email = #{email},

user_name = #{userName},

password = #{password},

state = #{state},

company_id = #{companyId},

company_name = #{companyName},

dept_name = #{deptName},

manager_id = #{managerId},

join_date = #{joinDate},

salary = #{salary},

birthday = #{birthday},

gender = #{gender},

station = #{station},

telephone = #{telephone},

degree = #{degree},

remark = #{remark},

order_no = #{orderNo}

where user_id = #{id}