docker连接springboot和mysql容器方法介绍

docker images：列出所有docker镜像
docker ps：列出所有运行中的容器，-a参数可以列出所有容器，包括停止的
docker stop container_id：停止容器
docker start container_name：启动已被停止的容器
docker rm container_id：删除已经停止的容器，加-f选项可以强制删除正在运行的容器
docker rmi image_id：删除镜像，前提是该镜像没有对应的容器
docker运行mysql容器

FROM ubuntu:14.04
MAINTAINER loveqh
RUN apt-get update
RUN apt-get -y install mysql-server
RUN /etc/init.d/mysql start \
  && mysql -uroot -e "grant all privileges on *.* to 'root'@'%' identified by '123456';" \
  && mysql -uroot -e "grant all privileges on *.* to 'root'@'localhost' identified by '123456';" 

RUN sed -Ei 's/^(bind-address|log)/#&/' /etc/mysql/my.cnf \
  && echo 'skip-host-cache\nskip-name-resolve' | awk '{ print } $1 == "[mysqld]" && c == 0 { c = 1; system("cat") }' /etc/mysql/my.cnf > /tmp/my.cnf \
  && mv /tmp/my.cnf /etc/mysql/my.cnf

EXPOSE 3306 
CMD ["/usr/bin/mysqld_safe"]

docker build -t loveqh/mysql .

docker run -d -P --name docker-mysql loveqh/mysql

0.0.0.0:32770->3306/tcp

mysql -h 0.0.0.0 -P 32770 -uroot -p

spring.datasource.url = jdbc:mysql://localhost:3306/spring
spring.datasource.username = root
spring.datasource.password = 123456
spring.datasource.driverClassName = com.mysql.cj.jdbc.Driver

use spring;
create table if NOT EXISTS user (
  id int PRIMARY KEY NOT NULL auto_increment,
  name VARCHAR(30),
  password VARCHAR(10),
  email VARCHAR(30)
);
-- INSERT INTO user(name, password, email) values("test", "001", "test@163.com");
INSERT INTO user(name, password, email)
SELECT * FROM (SELECT "test", "001", "test@163.com") AS tmp
WHERE NOT EXISTS (
  SELECT name FROM user WHERE name='test' AND email='test@163.com'
) limit 1;

docker build -t loveqh/spring-boot-mysql-docker .

docker run -d -p 8088:8080 –name spring-web –link docker-mysql:mysql loveqh/spring-boot-mysql-docker

spring.datasource.url = jdbc:mysql://mysql:3306/spring

//UserController.java
package com.xxx;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import java.util.List;
/**
 * Created by wangl on 17-5-16.
 */
@Controller
@RequestMapping("/user")
public class UserController {
  @Autowired
  private UserDao userDao;
  @RequestMapping(method = RequestMethod.GET)
  public String index(Model model) {
    model.addAttribute("user", new User());
    return "index";
  }
  @RequestMapping("/list")
  public String list(Model model) {
    Listusers = userDao.findAll();
    model.addAttribute("users", users);
    return "list";
  }
  @RequestMapping(value = "/registry", method = RequestMethod.POST)
  public String registry(@ModelAttribute(value = "user") User user, Model model) {
    boolean flag = userDao.save(user);
    if(flag) {
      Listusers = userDao.findAll();
      model.addAttribute("users", users);
      return "list";
    }
    model.addAttribute("info", "注册失败！");
    return "fail";
  }
}

//UserDao.java
package com.xxx;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.stereotype.Repository;
import java.util.List;
/**
 * Created by wangl on 17-5-16.
 */
@Repository
public class UserDao {
  @Autowired
  private JdbcTemplate jdbcTemplate;
  public ListfindAll() {
    String sql = "select id, name, email from user";
    RowMappermapper = (rs, rowNum) -> {
      User user = new User();
      user.setId(rs.getLong(1));
      user.setName(rs.getString(2));
      user.setEmail(rs.getString(3));
      return user;
    };
    return jdbcTemplate.query(sql, mapper);
  }
  public boolean save(User user) {
    boolean exists = exists(user);
    if(exists) {
      return false;
    }
    String sql = "insert into user(name, password, email) values(?, ?, ?)";
    int count = jdbcTemplate.update(sql, user.getName(), user.getPassword(), user.getEmail());
    return count == 1;
  }
  public boolean exists(User user) {
    String sql = "select count(*) from user where name=?";
    int count = jdbcTemplate.queryForObject(sql, new Object[]{user.getName()},int.class);
    return count != 0;
  }
}

list - 用户列表
 
 id 	 name 	 email 	 stat:index 	 stat:count 	 stat:size 	 stat:current 	 stat:even 	 stat:odd 	 stat:first 	 stat:last 
 id,error 	 name,error 	 email,error 	 error 	 error 	 error 	 error 	 error 	 error 	 error 	 error 

model.addAttribute("user", new User());