smbms项目准备

1. 创建一个Maven项目

2. 添加web结构

3. 配置Tomcat

4. 测试项目是否能够跑起来

5. 导入jar包

一开始应该导入servlet，mysql，jsp包

<dependencies>
        <!--servlet包-->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>4.0.1</version>
        </dependency>
        <!--jsp包-->
        <dependency>
            <groupId>javax.servlet.jsp</groupId>
            <artifactId>javax.servlet.jsp-api</artifactId>
            <version>2.3.3</version>
        </dependency>
        <!--mysql包-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
        </dependency>
    </dependencies>

6.创建项目包结构

dao：主要写有关于数据库的java代码

Filter：编写过滤器代码

pojo：编写实体类代码，OMG映射：表和类的映射

service：业务代码

servlet：servlet代码，主要用于取参数

7.编写实体类（表和类的映射）

public class Bill {
    private Integer id;
    private String billCode;
    private String productName;
    private String productDesc;
    private String productUnit;
    private String productCount;
    private String totallPrice;
    private Integer isPayment;
    private Integer createBy;
    private Date createDate;
    private String modifyBy;
    private String modifyDate;
    private Integer providerId;
 
    public Bill(Integer id, String billCode, String productName, String productDesc, String productUnit, String productCount, String totallPrice, Integer isPayment, Integer createBy, Date createDate, String modifyBy, String modifyDate, Integer providerId) {
        this.id = id;
        this.billCode = billCode;
        this.productName = productName;
        this.productDesc = productDesc;
        this.productUnit = productUnit;
        this.productCount = productCount;
        this.totallPrice = totallPrice;
        this.isPayment = isPayment;
        this.createBy = createBy;
        this.createDate = createDate;
        this.modifyBy = modifyBy;
        this.modifyDate = modifyDate;
        this.providerId = providerId;
    }
 
    public Bill() {
    }
 
    public Integer getId() {
        return id;
    }
 
    public void setId(Integer id) {
        this.id = id;
    }
 
    public String getBillCode() {
        return billCode;
    }
 
    public void setBillCode(String billCode) {
        this.billCode = billCode;
    }
 
    public String getProductName() {
        return productName;
    }
 
    public void setProductName(String productName) {
        this.productName = productName;
    }
 
    public String getProductDesc() {
        return productDesc;
    }
 
    public void setProductDesc(String productDesc) {
        this.productDesc = productDesc;
    }
 
    public String getProductUnit() {
        return productUnit;
    }
 
    public void setProductUnit(String productUnit) {
        this.productUnit = productUnit;
    }
 
    public String getProductCount() {
        return productCount;
    }
 
    public void setProductCount(String productCount) {
        this.productCount = productCount;
    }
 
    public String getTotallPrice() {
        return totallPrice;
    }
 
    public void setTotallPrice(String totallPrice) {
        this.totallPrice = totallPrice;
    }
 
    public Integer getIsPayment() {
        return isPayment;
    }
 
    public void setIsPayment(Integer isPayment) {
        this.isPayment = isPayment;
    }
 
    public Integer getCreateBy() {
        return createBy;
    }
 
    public void setCreateBy(Integer createBy) {
        this.createBy = createBy;
    }
 
    public Date getCreateDate() {
        return createDate;
    }
 
    public void setCreateDate(Date createDate) {
        this.createDate = createDate;
    }
 
    public String getModifyBy() {
        return modifyBy;
    }
 
    public void setModifyBy(String modifyBy) {
        this.modifyBy = modifyBy;
    }
 
    public String getModifyDate() {
        return modifyDate;
    }
 
    public void setModifyDate(String modifyDate) {
        this.modifyDate = modifyDate;
    }
 
    public Integer getProviderId() {
        return providerId;
    }
 
    public void setProviderId(Integer providerId) {
        this.providerId = providerId;
    }
}

8.编写基础公共类

8.1编写数据库公共类

public class baseDao {
    private static String driver;
    private static String url;
    private static String username;
    private static String password;
    static{
        Properties ps = new Properties();
        //通过类加载器读取对应的资源
        InputStream rs = baseDao.class.getClassLoader().getResourceAsStream("db.properties");
        try {
            ps.load(rs);
 
        } catch (IOException e) {
            e.printStackTrace();
        }
        driver=ps.getProperty("driver");
        url=ps.getProperty("url");
        username=ps.getProperty("username");
        password=ps.getProperty("password");
    }
    //编写连接数据库
    public static Connection getConnection(){
        Connection connection=null;
        try {
            Class.forName(driver);
            connection = DriverManager.getConnection(url, username, password);
 
        } catch (Exception throwables) {
            throwables.printStackTrace();
        }
        return connection;
    }
    //编写查询公共类
    public static ResultSet Query(Connection connection,String sql,Object[] params){
        ResultSet resultSet=null;
        try {
            PreparedStatement preparedStatement = connection.prepareStatement(sql);
            for (int i = 0; i <params.length ; i++) {
                preparedStatement.setObject(i+1,params[i]);
            }
            resultSet = preparedStatement.executeQuery();
 
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
        return resultSet;
    }
    //编写增删改公共类
    public static int update(Connection connection,String sql,Object[] params) throws Exception {
        PreparedStatement preparedStatement = connection.prepareStatement(sql);
        for (int i = 0; i < params.length; i++) {
            preparedStatement.setObject(i+1,params[i]);
        }
        int updateRows = preparedStatement.executeUpdate();
        return updateRows;
    }
    //关闭资源
    public static Boolean closeResult(Connection connection,PreparedStatement preparedStatement,ResultSet resultSet) {
        boolean flag = true;
        if (resultSet != null) {
            try {
                resultSet.close();
                //GC回收
                resultSet = null;
            } catch (SQLException throwables) {
                throwables.printStackTrace();
                flag = false;
            }
        }
        if (preparedStatement != null) {
            try {
                preparedStatement.close();
                //GC回收
                preparedStatement = null;
            } catch (SQLException throwables) {
                throwables.printStackTrace();
                flag = false;
            }
        }
        if (connection != null) {
            try {
                connection.close();
                //GC回收
                connection = null;
            } catch (SQLException throwables) {
                throwables.printStackTrace();
                flag = false;
            }
        }
        return flag;
    }
}

8.2编写字符过滤器

public class characterEncodingFilter implements Filter {
 
    public void init(FilterConfig filterConfig) throws ServletException {
 
    }
 
    public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain filterChain) throws IOException, ServletException {
        servletRequest.setCharacterEncoding("utf-8");
        servletResponse.setCharacterEncoding("utf-8");
        servletResponse.setContentType("text/html;charset=UTF-8");
        filterChain.doFilter(servletRequest,servletResponse);
    }
 
    public void destroy() {
 
    }
}

9导入网页静态资源

https://gitee.com/git_baboben/smbms?_from=gitee_search

准备工作完成