JDBC链接数据库

BaseDao

package com.bdqn.dao;

import com.bdqn.tools.Const;


import java.sql.*;
import java.util.List;
import java.util.Objects;

public class BaseDao {


    public Connection getConn(){
        Connection conn = null;
        try {
            Class.forName(Const.CONN_DRIVE);
            conn = DriverManager.getConnection(Const.CONN_URL,Const.USER_NAME,Const.USER_PAss);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return conn;
    }

    public ResultSet Query(String sql,Object[] objects){
        ResultSet rs= null;
        Connection conn = getConn();
        try {
            PreparedStatement ps = conn.prepareStatement(sql);
            if (objects!=null){
                for (int i=0;i<objects.length;i++){
                    ps.setObject(i+1,objects[i]);
                }
            }
            rs = ps.executeQuery();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return rs;
    }

    public int Update(String sql, Object[] objects) {
        int num = 0;
        Connection conn = getConn();
        try {
            PreparedStatement ps = conn.prepareStatement(sql);
            if (objects!=null){
                for(int i=0;i<objects.length;i++){
                    ps.setObject(i+1,objects[i]);
                }
            }
            num = ps.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return num;
    }
    public void closeAll(ResultSet rs,PreparedStatement ps,Connection conn){
        try {
            if (rs!=null){
                rs.close();
            }
            if (ps!=null){
                ps.close();
            }
            if (conn!=null){
                conn.close();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

serviceimpl

package com.bdqn.service.impl;

import com.bdqn.entity.ShopCar;

import java.util.List;

public interface DaoServiceImpl{

    public List<ShopCar> findAll();

}

service

package com.bdqn.service;

import com.bdqn.dao.BaseDao;
import com.bdqn.entity.ShopCar;
import com.bdqn.service.impl.DaoServiceImpl;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class DaoService extends BaseDao implements DaoServiceImpl{
    @Override
    public List<ShopCar> findAll() {
        List<ShopCar> list = new ArrayList<>();
        String sql = "select * from shopcar";
        Object[] objects = null;
        ResultSet rs = Query(sql,objects);
        try {
            while(rs.next()){
                int id = rs.getInt("id");
                String name = rs.getString("name");
                int price = rs.getInt("id");
                int sold = rs.getInt("sold");
                ShopCar shopCar = new ShopCar();
                shopCar.setId(id);
                shopCar.setName(name);
                shopCar.setPrice(price);
                shopCar.setSold(sold);
                list.add(shopCar);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        closeAll(rs,null,null);
        return list;
    }
}

servlet

package com.bdqn.servlet;

import com.bdqn.entity.ShopCar;
import com.bdqn.service.DaoService;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.util.List;

@WebServlet(name = "IndexServlet")
public class IndexServlet extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doGet(request,response);
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        DaoService dao = new DaoService();
        List<ShopCar> list = dao.findAll();
        for (ShopCar li : list){
            System.out.print(li.getId());
            System.out.print(li.getName());
            System.out.print(li.getPrice());
            System.out.println(li.getSold());
        }
        String biaoji = request.getParameter("biaojiao");
        if ("".equals(biaoji)||null==biaoji) {
            response.getWriter().print(list);
        }

    }
}