jsp + mysql零售公司销售信息管理系统

import java.io.IOException; import java.io.PrintWriter; import java.sql.ResultSet; import java.sql.SQLException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.sale.database.LinkDatabase; public class UpdateComServlet extends HttpServlet { public UpdateComServlet() { super(); } public void destroy() { super.destroy(); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { LinkDatabase ld = new LinkDatabase(); request.setCharacterEncoding("utf-8"); String option_com_name=request.getParameter("option_com_name"); System.out.println(option_com_name); double update_com_price = Double.parseDouble(request.getParameter("update_com_price")); String sqlStr="update commodity set com_price="+update_com_price+"where com_name='"+option_com_name+"'"; try { ld.update(sqlStr); } catch (Exception e) { response.sendRedirect("/sales/error.jsp"); e.printStackTrace(); } response.sendRedirect("/sales/admin.jsp"); } public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { } public void init() throws ServletException {} }