upnum2.jsp

来自「jsp时间的一些小例子」· JSP 代码 · 共 48 行

JSP
48
字号
<%@page info="database handler" language="java" import="java.sql.*" import="java.util.*" import="java.io.*"%>
<%@page import="javax.servlet.*"%>
<%@page import="javax.servlet.http.*"%>
<%@page contentType="text/html;charset=gb2312"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">
<!--
body {
	
}
-->
</style></head>

<body bgcolor="#CCCCCC">
<p> 
  <%String xinghao=request.getParameter("xinghao");
	String nu=request.getParameter("num");
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	String url="jdbc:odbc:c";
	Connection con=DriverManager.getConnection(url,"","");
	Statement st=con.createStatement();
	String strSql="select * from buy where xinghao='"+xinghao+"'";
	ResultSet rs=st.executeQuery(strSql);
	if(!rs.next())
	return;
	else if(nu.equals(""))
	{
	out.println("请填写完整信息<p><a href=gouwuche.jsp>返回商品修改页</a></p>");
	return;}%>
    <%
	Statement aa=con.createStatement();
 	String sql="update buy set nu='"+nu+"'where xinghao='"+xinghao+"'";
 	aa.executeUpdate(sql);
	aa.close();
	%> 
<%rs.close();
st.close();
response.setHeader("Refresh","1");
response.sendRedirect("gouwuche.jsp");
%>
</p>
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?