德鲁伊使用

1.连接池

public class JDBCUtils {
    //获取连接池对象
    private static DataSource ds;

    static {
        try {
            Properties Pro = new Properties();
            //1.获取druid里面的数据
            InputStream is = JDBCUtils.class.getClassLoader().getResourceAsStream("druid.properties");
            //2.初始化连接池对象
            Pro.load(is);
            ds = DruidDataSourceFactory.createDataSource(Pro);
            System.out.println("连接成功");
        } catch (IOException e) {
            e.printStackTrace();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
        //3.获取连接池对象
    public static DataSource getDataSource(){
        return ds;
    }
        //4.获取连接对象
    public static Connection getConnection() throws SQLException {
        return  ds.getConnection();
    }
}

2.文件pro

driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql:///day15?useSSL=false
username=root
password=123456

3.jdbtemplate的具体使用

package com.anbo.dao;

import com.anbo.domain.Commodityall;
import com.anbo.domain.Commoditycart;
import com.anbo.util.JDBCUtils;
import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;

import java.util.List;

public class Shoppingdao {
    private JdbcTemplate jdbcTemplate = new JdbcTemplate(JDBCUtils.getDataSource());
    public List<Commodityall> SelectAll(){
        try {
            String sql = "select * from commodityall LIMIT 8";
            List<Commodityall> query = jdbcTemplate.query(sql, new BeanPropertyRowMapper<Commodityall>(Commodityall.class));
            return query;
        } catch (DataAccessException e) {
            return null;
        }
    }
    public List<Commodityall> Selectcenter(){
        try {
            String sql = "select * from commodityall LIMIT 8,4";
            List<Commodityall> query = jdbcTemplate.query(sql, new BeanPropertyRowMapper<Commodityall>(Commodityall.class));
            return query;
        } catch (DataAccessException e) {
            return null;
        }
    }
    public List<Commodityall> Selectcbottom(){
        try {
            String sql = "select * from commodityall LIMIT 12,4";
            List<Commodityall> query = jdbcTemplate.query(sql, new BeanPropertyRowMapper<Commodityall>(Commodityall.class));
            return query;
        } catch (DataAccessException e) {
            return null;
        }
    }
    public List<Commodityall> SelectcID(Commodityall commodityall){
        try {
            String sql = "select * from commodityall where id=?";
            List<Commodityall> query = jdbcTemplate.query(sql, new BeanPropertyRowMapper<Commodityall>(Commodityall.class),commodityall.getId());
            if(query.size()==0){
                return null;
            }else{
                return query;
            }
        } catch (DataAccessException e) {
            return null;
        }
    }
    public int intert(Commoditycart commoditycart){
        try {
            String sql = "insert into shoppingcart (username,price,Stylei,synopsis,i)values(?,?,?,?,?)";
            int update = jdbcTemplate.update(sql, commoditycart.getUsername(), commoditycart.getPrice(), commoditycart.getStylei(), commoditycart.getSynopsis(),commoditycart.getI());
            return update;
        } catch (DataAccessException e) {
            return 0;
        }
    }

    public List<Commoditycart> SelectcUname(Commoditycart commoditycart){
        try {
            String sql = "select * from shoppingcart where username=?";
            List<Commoditycart> query = jdbcTemplate.query(sql, new BeanPropertyRowMapper<Commoditycart>(Commoditycart.class),commoditycart.getUsername());
            if(query.size()==0){
                return null;
            }else{
                return query;
            }
        } catch (DataAccessException e) {
            return null;
        }
    }

}