Servlet+Javabean+Html实现简单的查询.删除.修改.添加四个功能

package cn.com.yong.Utils;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;public class DBConnection {    PRivate String url="jdbc:MySQL://localhost:3306/guimei";    private String user="root";    private String passWord="666888";    private Connection con=null;    //构造方法私有化    private DBConnection(){        try {            Class.forName("com.mysql.jdbc.Driver");            con=DriverManager.getConnection(url, user, password);        } catch (ClassNotFoundException e) {            e.printStackTrace();        } catch (SQLException e) {            e.printStackTrace();        }    }    //创建一个私有化对象    private static DBConnection jdbc=new DBConnection();    //实例    public static DBConnection getDBConnectionInstance(){        return jdbc;    }    public Connection getDBConnection() {        return con;    }}

package cn.com.yong.Pojo;import java.sql.Date;public class Order_table {    private Integer order_id;//订单号    private String order_address;//订单发货地址    private Integer order_user_id;//订单人的id    private Integer order_sum_price;//订单总金额    private Date order_date;//下单日期：符合2004-12-12格式    private Integer order_status;//订单状态:1表示订单“待审核”：表示您的订单等待审核中。2表示订单“已确认”：表示您的订单已审核通过。3表示订单“备货中”：表示您的订单已打印，我们正在为您备货。4表示订单“已发货”：表示您的订单已出仓库，您可在网上跟踪配送情况。5表示订单“已完成”：表示您的订单已完成签收。值只能取1-5。    private Integer payment_id;//支付明细表    public Order_table(){}    public Order_table(Integer order_id, String order_address,            Integer order_user_id, Integer order_sum_price, Date order_date,            Integer order_status, Integer payment_id) {        this.order_id = order_id;        this.order_address = order_address;        this.order_user_id = order_user_id;        this.order_sum_price = order_sum_price;        this.order_date = order_date;        this.order_status = order_status;        this.payment_id = payment_id;    }    public Integer getOrder_id() {        return order_id;    }    public void setOrder_id(Integer order_id) {        this.order_id = order_id;    }    public String getOrder_address() {        return order_address;    }    public void setOrder_address(String order_address) {        this.order_address = order_address;    }    public Integer getOrder_user_id() {        return order_user_id;    }    public void setOrder_user_id(Integer order_user_id) {        this.order_user_id = order_user_id;    }    public Integer getOrder_sum_price() {        return order_sum_price;    }    public void setOrder_sum_price(Integer order_sum_price) {        this.order_sum_price = order_sum_price;    }    public Date getOrder_date() {        return order_date;    }    public void setOrder_date(Date order_date) {        this.order_date = order_date;    }    public Integer getOrder_status() {        return order_status;    }    public void setOrder_status(Integer order_status) {        this.order_status = order_status;    }    public Integer getPayment_id() {        return payment_id;    }    public void setPayment_id(Integer payment_id) {        this.payment_id = payment_id;    }}

package cn.com.yong.Dao;import java.util.List;import cn.com.yong.Pojo.Order_table;public interface Order_tableDao {    public boolean addOrder_table(Order_table ot);    public boolean deleteOrder_table(int id);    public List<Order_table> selectOrder_table();    public boolean updateOrder_table(Order_table ot);}

package cn.com.yong.DaoImplement;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.ArrayList;import java.util.List;import cn.com.yong.Dao.Order_tableDao;import cn.com.yong.Pojo.Order_table;import cn.com.yong.Utils.DBConnection;public class Order_tableDaoImplement implements Order_tableDao{        boolean bn=false;    Statement sta=null;    ResultSet rs=null;    PreparedStatement ps=null;    Connection con=null;    public boolean addOrder_table(Order_table ot) {        con=DBConnection.getDBConnectionInstance().getDBConnection();        String sql="insert into order_table value(?,?,?,?,?,?,?)";        try {            ps=con.prepareStatement(sql);            ps.setInt(1, ot.getOrder_id().intValue());            ps.setString(2, ot.getOrder_address());            ps.setInt(3, ot.getOrder_user_id().intValue());            ps.setInt(4, ot.getOrder_sum_price().intValue());            ps.setDate(5,ot.getOrder_date());            ps.setInt(6, ot.getOrder_status().intValue());            ps.setInt(7, ot.getPayment_id().intValue());            ps.executeUpdate();        } catch (SQLException e) {            e.printStackTrace();        }                return false;    }    public boolean deleteOrder_table(int id) {        con=DBConnection.getDBConnectionInstance().getDBConnection();        String sql="delete from order_table where order_id=?";        try {            ps=con.prepareStatement(sql);            ps.setInt(1, id);            int i=ps.executeUpdate();            if(i>0){                return true;            }        } catch (SQLException e) {            e.printStackTrace();        }                return false;    }    public List<Order_table> selectOrder_table() {        con=DBConnection.getDBConnectionInstance().getDBConnection();        List<Order_table> list=new ArrayList<Order_table>();        try {            sta=con.createStatement();            String sql="select order_id,order_address,order_user_id,order_sum_price,order_date,order_status,payment_id from order_table";            rs=sta.executeQuery(sql);            while(rs.next()){                Order_table od=new Order_table();                od.setOrder_id(rs.getInt("order_id"));                od.setOrder_address(rs.getString("order_address"));                od.setOrder_user_id(rs.getInt("order_user_id"));                od.setOrder_sum_price(rs.getInt("order_sum_price"));                od.setOrder_date(rs.getDate("order_date"));                od.setOrder_status(rs.getInt("order_status"));                od.setPayment_id(rs.getInt("payment_id"));                list.add(od);            }        } catch (SQLException e) {            e.printStackTrace();        }        return list;    }    public static void main(String[] args) {        List<Order_table> list=new Order_tableDaoImplement().selectOrder_table();        System.out.println(list);    }    public boolean updateOrder_table(Order_table ot) {        con=DBConnection.getDBConnectionInstance().getDBConnection();        String sql="update order_table set order_sum_price=? where order_id=?";        try {            ps=con.prepareStatement(sql);            ps.setInt(1, ot.getOrder_sum_price().intValue());            ps.setInt(2, ot.getOrder_id().intValue());            ps.executeUpdate();        } catch (SQLException e) {            e.printStackTrace();        }                return false;    }
}

package cn.com.yong.Servlet;import java.io.IOException;import java.util.List;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 cn.com.yong.DaoImplement.Order_tableDaoImplement;import cn.com.yong.Pojo.Order_table;@WebServlet("/Order_tableSelectAllServlet")public class Order_tableSelectAllServlet extends HttpServlet {        private static final long serialVersionUID = 1L;    public void doGet(HttpServletRequest request, HttpServletResponse response)            throws ServletException, IOException {        doPost(request, response);    }        public void doPost(HttpServletRequest request, HttpServletResponse response)            throws ServletException, IOException {        String url=null;        Order_tableDaoImplement otd=new Order_tableDaoImplement();        List<Order_table> list=otd.selectOrder_table();                if(list.size()>0){            url="Order_tableSelectAll.jsp";            request.setAttribute("lit", list);        }else{            url="loser.jsp";        }        request.getRequestDispatcher(url).forward(request, response);    }}

<%@page import="cn.com.yong.Pojo.Order_table"%><%@page import="cn.com.yong.DaoImplement.Order_tableDaoImplement"%><%@ page language="java" import="java.util.*" pageEncoding="utf-8"%><%String path = request.getContextPath();String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html>  <head>    <base href="<%=basePath%>">        <title>My JSP 'Order_tableSelectAll.jsp' starting page</title>        <meta http-equiv="pragma" content="no-cache">    <meta http-equiv="cache-control" content="no-cache">    <meta http-equiv="expires" content="0">        <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">    <meta http-equiv="description" content="This is my page">    <!--    <link rel="stylesheet" type="text/CSS" href="styles.css">    -->  </head>    <body>    <table border="1" cellpadding="1" cellspacing="1" align="center" width="80%">        <tr>            <th>订单号</th>            <th>订单发货地址</th>            <th>订单id</th>            <th>订单总金额</th>            <th>下单日期</th>            <th>订单状态</th>            <th>支付明细</th>            <th>操作</th>        </tr>        <%                List<Order_table> list=(List<Order_table>)request.getAttribute("lit");        for(Order_table ot:list){%>            <tr>            <td><%=ot.getOrder_id()%></td>            <td><%=ot.getOrder_address()%></td>            <td><%=ot.getOrder_user_id()%></td>            <td><%=ot.getOrder_sum_price()%></td>            <td><%=ot.getOrder_date()%></td>            <td><%=ot.getOrder_status()%></td>            <td><%=ot.getPayment_id()%></td>            <td><a href="Order_tableDelServlet?order_id=<%=ot.getOrder_id()%>">删除</a>||            <a href="Order_tableUpdateServlet?order_id=<%=ot.getOrder_id()%>">修改</a></td>            </tr>        <%} %>                <h3><a href="Order_tableAdd.jsp">添加</a></h3>    </table>  </body></html>

package cn.com.yong.Servlet;import java.io.IOException;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 cn.com.yong.Dao.Order_tableDao;import cn.com.yong.DaoImplement.Order_tableDaoImplement;@WebServlet("/Order_tableDelServlet")public class Order_tableDelServlet extends HttpServlet {    private static final long serialVersionUID = 1L;    public void doGet(HttpServletRequest request, HttpServletResponse response)            throws ServletException, IOException {        doPost(request, response);    }    public void doPost(HttpServletRequest request, HttpServletResponse response)            throws ServletException, IOException {        String url=null;        int id=Integer.parseInt(request.getParameter("order_id"));                Order_tableDao otd=new Order_tableDaoImplement();        boolean bn=otd.deleteOrder_table(id);       System.out.println(bn);        if(bn){            url="Order_tableSelectAllServlet";        }else{            url="loser.jsp";        }        response.sendRedirect(url);    }}

 1 <%@page import="cn.com.yong.Pojo.Order_table"%> 2 <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> 3 <% 4 String path = request.getContextPath(); 5 String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; 6 %> 7  8 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> 9 <html>10   <head>11     <base href="<%=basePath%>">12     13     <title>My JSP 'Order_tableUpdate.jsp' starting page</title>14     15     <meta http-equiv="pragma" content="no-cache">16     <meta http-equiv="cache-control" content="no-cache">17     <meta http-equiv="expires" content="0">    18     <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">19     <meta http-equiv="description" content="This is my page">20     <!--21     <link rel="stylesheet" type="text/css" href="styles.css">22     -->23 24   </head>25   26   <body>27       <%Order_table ot=(Order_table)request.getAttribute("ot"); %>28     <form action="Order_tableUpdateServlet2" method="post">29         <p>订单号：<input name="order_id" type="text" readonly="readonly" value=<%=ot.getOrder_id()%>></p>30         <p>订单发货地址：<input name="order_address" type="text" value=<%=ot.getOrder_address()%>></p>31         <p>订单人的id：<input name="order_user_id" type="text" value=<%=ot.getOrder_user_id()%>></p>32         <p>订单金额：<input name="order_sum_price" type="text" value=<%=ot.getOrder_sum_price()%>></p>33         <p>下单日期：<input name="order_date" type="text" value=<%=ot.getOrder_date()%>></p>34         <p>订单状态：<input name="order_status" type="text" value=<%=ot.getOrder_status()%>></p>35         <p>支付明细表：<input name="payment_id" type="text" value=<%=ot.getPayment_id()%>></p>36         <p><input type="submit" value="修改"/></p>37     </form>38   </body>39 </html>

 1 import java.io.IOException; 2 import java.sql.Date; 3 import java.text.ParseException; 4 import java.text.SimpleDateFormat; 5  6 import javax.servlet.ServletException; 7 import javax.servlet.annotation.WebServlet; 8 import javax.servlet.http.HttpServlet; 9 import javax.servlet.http.HttpServletRequest;10 import javax.servlet.http.HttpServletResponse;11 12 import cn.com.yong.DaoImplement.Order_tableDaoImplement;13 import cn.com.yong.Pojo.Order_table;14 @WebServlet("/Order_tableUpdateServlet2")15 public class Order_tableUpdateServlet2 extends HttpServlet {16 17     private static final long serialVersionUID = 1L;18 19     public void doGet(HttpServletRequest request, HttpServletResponse response)20             throws ServletException, IOException {21         doPost(request, response);22     }23 24     public void doPost(HttpServletRequest request, HttpServletResponse response)25             throws ServletException, IOException {26         Order_tableDaoImplement otd=new Order_tableDaoImplement();27         Order_table ot=new Order_table();28         29         int order_id=Integer.parseInt(request.getParameter("order_id"));30         String order_address=request.getParameter("order_address");31         int order_user_id=Integer.parseInt(request.getParameter("order_user_id"));32         int order_sum_price=Integer.parseInt(request.getParameter("order_sum_price"));33         Date order_date=null;34         try {35             order_date=new Date(new SimpleDateFormat("yyyy-MM-dd").parse(request.getParameter("order_date")).getTime());36         } catch (ParseException e) {37             e.printStackTrace();38         }39         int order_status=Integer.parseInt(request.getParameter("order_status"));40         int payment_id=Integer.parseInt(request.getParameter("payment_id"));41         42         ot.setOrder_id(order_id);43         ot.setOrder_address(order_address);44         ot.setOrder_user_id(order_user_id);45         ot.setOrder_sum_price(order_sum_price);46         ot.setOrder_date(order_date);47         ot.setOrder_status(order_status);48         ot.setPayment_id(payment_id);49         50         boolean bn=otd.updateOrder_table(ot);51         String url=null;52         if(bn){53             url="Order_tableSelectAllServlet";54         }else{55             url="loser.jsp";56         }57         response.sendRedirect(url);58     }59 60 }

 1  <head> 2     <title>Order_tableAdd.html</title> 3      4     <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> 5     <meta http-equiv="description" content="this is my page"> 6     <meta http-equiv="content-type" content="text/html; charset=UTF-8"> 7      8     <!--<link rel="stylesheet" type="text/css" href="./styles.css">--> 9 10   </head>11   12   <body>13     <form action="Order_tableAddServlet" method="post">14         <p>订单号：<input name="order_id" type="text"></p>15         <p>订单发货地址：<input name="order_address" type="text" ></p>16         <p>订单人的id：<input name="order_user_id" type="text" ></p>17         <p>订单金额：<input name="order_sum_price" type="text" ></p>18         <p>下单日期：<input name="order_date" type="text" ></p>19         <p>订单状态：<input name="order_status" type="text" ></p>20         <p>支付明细表：<input name="payment_id" type="text"></p>21         <p><input type="submit" value="添加"/></p>22     </form>23   </body>

 1 import java.io.IOException; 2 import java.sql.Date; 3 import java.text.ParseException; 4 import java.text.SimpleDateFormat; 5  6 import javax.servlet.ServletException; 7 import javax.servlet.annotation.WebServlet; 8 import javax.servlet.http.HttpServlet; 9 import javax.servlet.http.HttpServletRequest;10 import javax.servlet.http.HttpServletResponse;11 12 import cn.com.yong.DaoImplement.Order_tableDaoImplement;13 import cn.com.yong.Pojo.Order_table;14 @WebServlet("/Order_tableAddServlet")15 public class Order_tableAddServlet extends HttpServlet {16 17     private static final long serialVersionUID = 1L;18 19     public void doGet(HttpServletRequest request, HttpServletResponse response)20             throws ServletException, IOException {21         doPost(request, response);22     }23 24     public void doPost(HttpServletRequest request, HttpServletResponse response)25             throws ServletException, IOException {26         Order_tableDaoImplement otd=new Order_tableDaoImplement();27         Order_table ot=new Order_table();28         29         int order_id=Integer.parseInt(request.getParameter("order_id"));30         String order_address=request.getParameter("order_address");31         int order_user_id=Integer.parseInt(request.getParameter("order_user_id"));32         int order_sum_price=Integer.parseInt(request.getParameter("order_sum_price"));33         Date order_date=null;34         try {35             order_date=new Date(new SimpleDateFormat("yyyy-MM-dd").parse(request.getParameter("order_date")).getTime());36         } catch (ParseException e) {37             e.printStackTrace();38         }39         int order_status=Integer.parseInt(request.getParameter("order_status"));40         int payment_id=Integer.parseInt(request.getParameter("payment_id"));41         42         ot.setOrder_id(order_id);43         ot.setOrder_address(order_address);44         ot.setOrder_user_id(order_user_id);45         ot.setOrder_sum_price(order_sum_price);46         ot.setOrder_date(order_date);47         ot.setOrder_status(order_status);48         ot.setPayment_id(payment_id);49         50         51         boolean bn=otd.addOrder_table(ot);52         String url=null;53         if(bn){54             url="Order_tableSelectAllServlet";55         }else{56             url="loser.jsp";57         }58         response.sendRedirect(url);59     }60 61 }