jieshou.jsp

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

<%@ 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"); 
String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+dbpath;
Connection conn= DriverManager.getConnection(url,"",""); 
Statement stmt=conn.createStatement(); 


if(request.getParameter("ID")!=""){
	int ID=Integer.parseInt(request.getParameter("ID"));
	String sql="update order1 set doo=1 where id="+ID;
    stmt.executeUpdate(sql);
	
		out.println("<script language='javascript'>alert('订单执行成功！');window.location.href='ordermanage.jsp';</script>");
		
}
stmt.close(); 
conn.close();
%>