1.属性配置文件（application.properties）

# type 可以修改连接池类型，默认采用Tomcat的连接池    # spring.datasource.type=com.alibaba.druid.pool.DruidDataSource    spring.datasource.url=jdbc:mysql://localhost:3306/consult    spring.datasource.username=root    spring.datasource.password=123456    spring.datasource.driver-class-name=org.gjt.mm.mysql.Driver

2.pom.xml 配置maven依赖

          
              
      
       mysql
              
      
       mysql-connector-java
          
          
          
              
      
       org.springframework.boot
              
      
       spring-boot-starter-jdbc
          
     

3.Java查询示例

1 import java.sql.ResultSet; 2 import java.sql.SQLException; 3 import java.util.List; 4 import java.util.Map; 5 import org.springframework.beans.factory.annotation.Autowired; 6 import org.springframework.jdbc.core.JdbcTemplate; 7 import org.springframework.jdbc.core.RowMapper; 8 import org.springframework.stereotype.Service; 9 /**10 * service层11 */12 @Service13 public class CommonServiceImpl implements CommonService {14     15     // 注入JdbcTemplate16     @Autowired17     private JdbcTemplate jdbcTemplate;18    19     public List
     
       queryContent(Map map) {20         String sql = "select * from consult_content a where a.state = 0 and a.type = 1 order by a.itemindex";21         return jdbcTemplate.query(sql, new RowMapper
      
       () {22             23             public ConsultContent mapRow(ResultSet rs, int rowNum)24                     throws SQLException {25                 ConsultContent cc = new ConsultContent();26                 cc.setContent(rs.getString("content"));27                 cc.setId(rs.getInt("id"));28                 cc.setItemIndex(rs.getInt("itemIndex"));29                 cc.setState(rs.getInt("state"));30                 cc.setType(rs.getString("type"));31                 return cc;32             }33         });34     }       35 }