2.SSM統合_マルチテーブル_1対1または複数対1の追加削除

1対1と複数対1の構成は同じで、ここでは一緒に置きます.
1.プロファイルは前章のように、ここではあまり書かれていません.主にMapperマッピングファイルです.
複数
インタフェース

public interface NewsMapper {

	public void addNew(News news);
	
	public void delNew(String id);
	
	public void updateNew(News news);
	
	//    
	public List selectNew(String name);
	
	//    
	public List selectAll();
	
	//  id  
	public News selectById(String id);
	
	//       
	public List getCategoryName();
}

ファイルのマッピング

	
	
		insert into t_news(content, title, author, createtime, category_id) 
			value(#{content},#{title},#{author},#{createtime},#{category.id})
	
	
	
		delete from t_news where id = #{id}
	
	 
	
	
		update t_news 
			set 
				content = #{content}, 
				title = #{title}, 
				author = #{author}, 
				createtime = #{createtime}, 
				category_id = #{category.id}
			where
				id = #{id}
	

	
	
	
		
		
		
		
		
		
		
		
		
		
		
		
			
			
			
			
			
			
		
	
	
	
		select t1.id Id, t1.content Content, t1.title Title, t1.author Author, t1.createtime Createtime, 
			   t2.id Categoryid, t2.name Name 
			from t_news t1 
				left join t_category t2 
				on t1.category_id = t2.id 
			where t1.title like "%"#{name}"%"
	
	
	
		
		
		
		select t1.id Id, t1.content Content, t1.title Title, t1.author Author, t1.createtime Createtime, 
			   t2.id Categoryid, t2.name Name 
			from t_news t1 
				left join t_category t2 
				on t1.category_id = t2.id	
	
	
	
	
		
		
		
		
		
		
		
		
		
		
		
		
		
	
	
		select id, name 
			from t_category 
			where id = #{id}
	
	
	
		select t1.id Id, t1.content Content, t1.title Title, t1.author Author, t1.createtime Createtime, t1.category_id category_id 
			from  t_news t1 
			where t1.id = #{id} 
	
	
	
	
	
		select id, name 
			from t_category
	

エンティティークラス

public class News {

	private Integer id;
	private String content;
	private String title;
	private String createtime;
	private Category category;//  
	private String author;
	//  getter setter	
}

1
インタフェース

public interface CategoryMapper {

	public void addCategory(Category category);
	
	public void delCategory(String id);
	
	public void updateCategory(Category cateory);
	
	//  name    
	public List selectCategory(String name);
	
	//    
	public List selectAll();
	
	//  id  
	public Category selectById(String id);
	
	//          
	public List getNewsWithCate(String id);
}

ファイルのマッピング

	
	
		insert into t_category(name, createtime) 
			value(#{name}, #{createtime});
	
	
	
	
		delete from t_category 
			where id = #{id}
	
	
	
	
		update t_category 
			set name = #{name}, createtime = #{createtime} 
			where id = #{id}
	


	
	
		
		
		
		
		
			
			
			
		
	
	
	
	
		select t1.id Id, t1.name Name, t1.createtime Createtime, 
			   t2.id NewId, t2.title Title, t2.author Author 
			from t_category t1 
				left join t_news t2 
				on t1.id = t2.category_id 
			where t1.name like "%"#{name}"%"
	
	
	
		select t1.id Id, t1.name Name, t1.createtime Createtime, 
			   t2.id NewId, t2.title Title, t2.author Author 
			from t_category t1 
				left join t_news t2 
				on t1.id = t2.category_id
	
	
	
	
		
		
		
		
		
		
	
	
		select id, title, author 
			from t_news 
			where category_id = #{id}
	
	
	
		select id, name ,createtime 
			from t_category 
			where id = #{id}
	
	
	
	
		select * 
			from t_news 
			where category_id = #{id}
	

エンティティークラス

public class Category {

	private Integer id;
	private String name;
	private String createtime;
	//     
	private List news;
	//  getter setter