Spring + Mybatis J2SE small example summary
package dao;import java.util.List;import model.User;public interface UserDao {public User getUser(int i);public List
getAllUser();public int insertUser(User u);public int updateUser(User u);public int deleteUser(int i);}
select * from t_user where id=#{id}
select * from t_user
delete from t_user where id=#{id}
update t_user set username=#{username}, password=#{password} where id=#{id}
insert into t_user(username,password) values(#{username},#{password})
package model;import org.springframework.context.annotation.Scope;import org.springframework.stereotype.Component;@Component@Scope("prototype")public class User {private int id;private String username;private String password;public User() {super();}public User(String username, String password) {super();this.username = username;this.password = password;}public int getId() {return id;}public void setId(int id) {this.id = id;}public String getUsername() {return username;}public void setUsername(String username) {this.username = username;}public String getPassword() {return password;}public void setPassword(String password) {this.password = password;}}
package service;import java.util.List;import model.User;public interface IUserSrv {public User getUser(int i);public List
getAllUser();public int insertUser(User u);public int updateUser(User u);public int deleteUser(int i);}
Package service; import java. util. list; import javax. annotation. resource; import org. springframework. stereotype. component; import org. springframework. transaction. annotation. transactional; import dao. userDao; import model. user; @ Component @ Transactionalpublic class UserSrv implements IUserSrv {@ Resourceprivate UserDao userDao; @ Overridepublic User getUser (int I) {// TODO automatically generated method stub return userDao. getUser (I) ;}@ Overridepublic List
GetAllUser () {// method stub automatically generated by TODO return userDao. getAllUser () ;}@ Overridepublic int insertUser (User u) {// method stub automatically generated by TODO return userDao. insertUser (u) ;}@ Overridepublic int updateUser (User u) {// TODO automatically generated method stub return userDao. updateUser (u) ;}@ Overridepublic int deleteUser (int I) {// method stub automatically generated by TODO return userDao. deleteUser (I );}}
package test;import javax.annotation.Resource;import org.springframework.stereotype.Component;import model.User;import service.IUserSrv;import util.BeanHelper;@Componentpublic class Test {@Resourceprivate User user;public static void main(String[] args) {IUserSrv userSrv = (IUserSrv) BeanHelper.getBean("userSrv");System.out.println(userSrv.getUser(1).getUsername());Test t = (Test) BeanHelper.getBean("test");t.user.setUsername("dd");t.user.setPassword("xxx");System.out.println(userSrv.insertUser(t.user));}}
package util;import org.springframework.context.ApplicationContext;import org.springframework.context.support.ClassPathXmlApplicationContext;public class BeanHelper {private BeanHelper(){}private static ApplicationContext ac = new ClassPathXmlApplicationContext("spring.xml"); public static Object getBean(String beanName){return ac.getBean(beanName);}}