SpringBoot mysql操作

首先 file -new-SpringStart project  依赖选择 jpa mysql jdbc 和web

配置application.properties 

spring.datasource.url =jdbc:mysql://127.0.0.1:3306/my
spring.datasource.username =root
spring.datasource.password =root
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.jpa.properties.hibernate.hbm2ddl.auto=update//更新数据表
#spring.jpa.properties.hibernate.hbm2ddl.auto=create//启动项目删除原有表新建表

写实体类 

package com.wisely.ch5_2_2;
import javax.persistence.*;

import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
@EnableAutoConfiguration//我的不加这个会不错   Unable to start EmbeddedWebApplicationContext due to missing EmbeddedServletContainerFactory bean. 
@Entity  
@Table(name = "user")  
public class User {  
    @Id  
    @GeneratedValue(strategy = GenerationType.AUTO)  
    private int id;  
  
    @Column(name = "name", nullable = true, length = 30)  
    private String name;  
  
  
    @Column(name = "sex", nullable = true, length = 30)  
    private String sex;  

  
    public User(String name ,String sex) {
    	this.name=name;
    	this.sex=sex;
    }  
  public User(){}//构造函数要加上，不加会报错
    public String getSex() {  
        return sex;  
    }  
  
    public void setSex(String sex) {  
        this.sex = sex;  
    }  

  
    public User(int id) {  
        this.id = id;  
    }  
  
    public int getId() {  
        return id;  
    }  
  
    public void setId(int id) {  
        this.id = id;  
    }  
  
    public String getName() {  
        return name;  
    }  
  
    public void setName(String name) {  
        this.name = name;  
    }  
  
}

抒写操作类

@Transactional  
public interface UserDao extends CrudRepository<User, Integer> {  
    public List<User> findByName(String name); 
    public List<User> findBySex(String sex); 
   // public void save(String name,String sex);
}  

这里只需要继承CrudRepository就可以了 SpringBoot自动实现

CrudRepository 实现方法

http://blog.csdn.net/lw_power/article/details/51296595

Controller 类

package com.wisely.ch5_2_2;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
import org.springframework.stereotype.Controller;  
import org.springframework.web.bind.annotation.RequestMapping;  
import org.springframework.web.bind.annotation.ResponseBody;  
import java.util.List;  
@Controller
@EnableAutoConfiguration 
public class UserController {  
    @Autowired  
    private UserDao userDao;  
    @RequestMapping("/getName")  
    @ResponseBody  
    public String getByName(String name) {  
        List<User> userList = userDao.findByName(name);  
        if (userList != null && userList.size()!=0) {  
            return "The user length is: " + userList.size();  
        }  
        return "user " + name + " is not exist.";  
    }  
    @RequestMapping("/add")  
    @ResponseBody  
    public String add(String name,String sex) { 
    	User user=new User(name,sex);
    	userDao.save(user);
        return "user " + name + " sex "+ sex;  
    }  
    @RequestMapping("/sex")  
    @ResponseBody  
    public String add(String sex) { 
    	 List<User> userList = userDao.findBySex(sex);  
         if (userList != null && userList.size()!=0) {  
             return "The user length is: " + userList.get(0).getName();  
         }  
         return "user "  + " is not exist.";  
    }  
}  

参数会自动获取 

启动类

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
public class MysqlApplication {

	public static void main(String[] args) {
		//SpringApplication.run(User.class, args);
		SpringApplication.run(UserController.class, args);
	}
}

SpringBootApplication 为SpringBoot的入口

启动过后 访问方式 localhost：8080/add?name=zc&sex=b