📄 upnum2.jsp

📁 jsp时间的一些小例子

💻 JSP

字号:

<%@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 + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -