jsp+servlet+mysql实现的在线鲜花商城

 

jsp+servlet+mysql实现的在线鲜花商城

JDK：jdk1.8

ida：eclipse

数据库：mysql开发环境：
Eclipse ,MYSQL,JDK1.8,Tomcat 8.5
涉及技术点：
MVC模式、SpringBoot、Mybatis、Redis、HTML、log4j、druid、Bootstrap、
Semantic UI、Thymeleaf、JavaScript、CSS、JQUERY、Ajax等
适合学习J2EE的一段时间的熟手，代码思路清晰，注解详细，数据库用的是mysql5.1，服务器用的tomcat8.5，JDK版本1.8. 编程软件Eclispe J2EE版本。是典型MVC架构，并且前后台分离
主要功能：

代码已经上传github，下载地址： https://github.com/21503882/network-flower

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import com.hr.entity.EASYBUY_PRODUCT;

public class EASYBUY_PRODUCTDao {
    
    
    
    /**
     * 查询所有
     * @return
     */

    public static ArrayList<EASYBUY_PRODUCT> selectAll(){
        ArrayList<EASYBUY_PRODUCT> list = new ArrayList<EASYBUY_PRODUCT>();
        ResultSet rs = null;
        Connection conn = Basedao.getconn();
        PreparedStatement ps = null;
        try {
            ps = conn.prepareStatement("select * from EASYBUY_PRODUCT");
            rs = ps.executeQuery();
            while(rs.next()){
                EASYBUY_PRODUCT p = new EASYBUY_PRODUCT(rs.getInt("EP_ID"),
                                        rs.getString("EP_NAME"), 
                                        rs.getString("EP_DESCRIPTION"),
                                        rs.getInt("EP_PRICE"),
                                        rs.getInt("EP_STOCK"),
                                        rs.getInt("EPC_ID"),
                                        rs.getInt("EPC_CHILD_ID"),
                                        rs.getString("EP_FILE_NAME"));
                list.add(p);
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }finally {
            Basedao.closeall(rs, ps, conn);
        }
        return list;
    }
    

    /**

     * 名字模糊查询
     * @return
     */
    public static ArrayList<EASYBUY_PRODUCT> selectAllByName(String name){
        ArrayList<EASYBUY_PRODUCT> list = new ArrayList<EASYBUY_PRODUCT>();
        ResultSet rs = null;
        Connection conn = Basedao.getconn();
        PreparedStatement ps = null;
        try {
            ps = conn.prepareStatement("select * from EASYBUY_PRODUCT where EP_NAME like ?");
            ps.setString(1, "%"+name+"%");
            rs = ps.executeQuery();
            while(rs.next()){
                EASYBUY_PRODUCT p = new EASYBUY_PRODUCT(rs.getInt("EP_ID"),
                                        rs.getString("EP_NAME"), 
                                        rs.getString("EP_DESCRIPTION"),
                                        rs.getInt("EP_PRICE"),
                                        rs.getInt("EP_STOCK"),
                                        rs.getInt("EPC_ID"),
                                        rs.getInt("EPC_CHILD_ID"),
                                        rs.getString("EP_FILE_NAME"));
                list.add(p);
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }finally {
            Basedao.closeall(rs, ps, conn);
        }
        return list;
    }

    /**
     * 根据id查询单个
     * @param id
     * @return
     */
    public static EASYBUY_PRODUCT selectById(int id){
        EASYBUY_PRODUCT p = null;
        ResultSet rs = null;
        Connection conn = Basedao.getconn();
        PreparedStatement ps = null;
        try {
            ps = conn.prepareStatement("select * from EASYBUY_PRODUCT where EP_ID=?");
            ps.setInt(1, id);
            rs = ps.executeQuery();
            while(rs.next()){
                p = new EASYBUY_PRODUCT(rs.getInt("EP_ID"),
                        rs.getString("EP_NAME"), 
                        rs.getString("EP_DESCRIPTION"),
                        rs.getInt("EP_PRICE"),
                        rs.getInt("EP_STOCK"),
                        rs.getInt("EPC_ID"),
                        rs.getInt("EPC_CHILD_ID"),
                        rs.getString("EP_FILE_NAME"));
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }finally {
            Basedao.closeall(rs, ps, conn);
        }
        return p;
    }
    
    /**
     * 根据fid查询所有
     * @param fid
     * @return
     */
    public static ArrayList<EASYBUY_PRODUCT> selectAllByFid(int fid){
        ArrayList<EASYBUY_PRODUCT> list = new ArrayList<EASYBUY_PRODUCT>();
        ResultSet rs = null;
        Connection conn = Basedao.getconn();
        PreparedStatement ps = null;
        try {
            ps = conn.prepareStatement("select * from EASYBUY_PRODUCT where EPC_ID=?");
            ps.setInt(1, fid);
            rs = ps.executeQuery();
            while(rs.next()){
                EASYBUY_PRODUCT p = new EASYBUY_PRODUCT(rs.getInt("EP_ID"),
                                        rs.getString("EP_NAME"), 
                                        rs.getString("EP_DESCRIPTION"),
                                        rs.getInt("EP_PRICE"),
                                        rs.getInt("EP_STOCK"),
                                        rs.getInt("EPC_ID"),
                                        rs.getInt("EPC_CHILD_ID"),
                                        rs.getString("EP_FILE_NAME"));
                list.add(p);
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }finally {
            Basedao.closeall(rs, ps, conn);
        }
        return list;
    }
    
    /**
     * 根据cid查询所有
     * @param fid
     * @return
     */
    public static ArrayList<EASYBUY_PRODUCT> selectAllByCid(int cid){
        ArrayList<EASYBUY_PRODUCT> list = new ArrayList<EASYBUY_PRODUCT>();
        ResultSet rs = null;
        Connection conn = Basedao.getconn();
        PreparedStatement ps = null;