【JavaWeb】将普通项目变成ssm项目 02

• 实现用户类的所有方法

package com.stuos.dao;

import java.util.List;

import com.stuos.po.User;


public interface UserDao {
	public void save(User user);
	public void update(User user);
	public User findById(String userAcc);
	public List getAll();
	public void delete(String userAcc);
	public void saveOrupdate(User user);
	public List getAllSecr();
	public List getAllInst();
	public List getAllStu();
	public List getAllProf();
	public List getAllTea();
	public List getAllById(String Id);
}

	
		insert into
		tb_user(userId,userAcc,userPwd,userName,userAge,userSex)
		values(#{userId},#{userAcc},#{userPwd},#{userName},#{userAge},#{userSex})
	

	
		update tb_user set userId =
		#{userId},userPwd = #{userPwd},userName = #{userName},userAge =
		#{userAge},userSex = #{userSex} where userAcc = #{userAcc}
	

	
		select *
		from tb_user where userAcc = #{userAcc}
	
 
4.获得整个表 

	
		select * from tb_user
	

	
		delete from tb_user where
		userAcc = #{userAcc}
	

	
		replace into
		tb_user(userId,userAcc,userPwd,userName,userAge,userSex)
		values(#{userId},#{userAcc},#{userPwd},#{userName},#{userAge},#{userSex})
	

	
		select * from tb_user u where
		find_in_set('6',u.userId)>0
	
 
8.找到所有辅导员对象 

	
		select * from tb_user u where
		find_in_set('5',u.userId)>0
	

	
		select * from tb_user u where
		find_in_set('7',u.userId)>0
	
 
10.找到所有专业人员对象 

	
		select * from tb_user u where
		find_in_set('2',u.userId)>0 or find_in_set('3',u.userId)>0 or
		find_in_set('4',u.userId)>0
	

	
		select * from tb_user u where
		find_in_set('4',u.userId)>0
	
 
12.查找某身份的所有对象 

	
		select * from tb_user u where
		find_in_set('#{Id}',u.userId)>0