goods_modify_deal.jsp

来自「解压在c盘」· JSP 代码 · 共 42 行

<%@ page contentType="text/html;charset=gb2312"%> 
<%@ page import="java.sql.*"%> 

<% 
String spath="wangye/ec.mdb";   
String dbpath = application.getRealPath(spath);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); 
String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)}; DBQ="+dbpath;
Connection conn= DriverManager.getConnection(url,"",""); 
Statement stmt=conn.createStatement();


 %>
  <%
   int ID=Integer.parseInt(request.getParameter("ID")); 
   String goodsname=request.getParameter("goodsname");
   String zhonglei=request.getParameter("zhonglei");
   int number=Integer.parseInt((String)request.getParameter("number"));
   String introduct=request.getParameter("introduct");
   String pic=request.getParameter("pic");
   int price=Integer.parseInt((String)request.getParameter("price"));
  

%>


<%
 String sql = "update goods set goodsname='"+goodsname+ "',zhonglei='" +zhonglei+ "',number=" + number+",introduct='" + introduct+"',pic='" + pic+"',price="+price+ " where key=" + ID;
     stmt.executeUpdate(sql);
 
%>

<% 
 out.print("更新信息成功");

  %>

<%
stmt.close(); 
conn.close(); 
%>