Springboot搭建简单的ssm框架
使用idea新建Sringboot项目,选择web模块和Mybatis、jdbc,使用Mysql数据库也可以选择Mysql驱动模块
//新增
@Insert("insert into user_info(id, name) values (seq_user_info.nextval, #{name})")
void add(String name);
//删除
@Delete("delete from user_info where id = #{id}")
void del(Long id);
//修改
@Update("update user_info set name = #{name} where id = #{id}")
void update(User user);
//查询
@Select("select * from user_info where id = #{id}")
User get(Long id);
//查询所有
@Select("select * from user_info")
List<User> list();
注意:需要加上***@Mapper***和***@Repository***这两个注解
@Autowired
private UserDao userDao;
@Override
public void add(String name) {
userDao.add(name);
}
@Override
public void del(Long id) {
userDao.del(id);
}
@Override
public void update(User user) {
userDao.update(user);
}
@Override
public User get(Long id) {
return userDao.get(id);
}
@Override
public List<User> list() {
return userDao.list();
}
注意:加上***@Transactional***和***@Service***注解
@Autowired
private UserService userService;
@RequestMapping("/add")
public String add(String name){
userService.add(name);
return "add success";
}
@RequestMapping("/del")
public String del(Long id){
userService.del(id);
return "del success";
}
@RequestMapping("/update")
public String update(){
User user = new User();
user.setName("小明明");
user.setId(Long.valueOf(2));
userService.update(user);
return "update success";
}
@RequestMapping("/get")
public User get(Long id){
User user = userService.get(id);
return user;
}
@RequestMapping("/list")
public List<User> list(){
List<User> list = userService.list();
return list;
}
注意加上***@RestController***注解
#数据源配置
spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver
spring.datasource.url=
spring.datasource.username=
spring.datasource.password=
#mybatis配置
mybatis.type-aliases-package=com.dylan.ssm.domain
#日志配置
logging.level.com.dylan.ssm.dao=debug
使用oracle数据库需要添加pom依赖:
<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc6</artifactId>
<version>11.2.0.3</version>
</dependency>
最后启动类需要加上事务***@EnableTransactionManagement(proxyTargetClass=true)***