📄 updata.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>修改商品信息</title>
</head>
<body>
<% String sql;
Connection con=null;
String id=request.getParameter("id");
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:sell","","");//建立与数据库的连接
Statement stmt=con.createStatement();
sql="select * from production where id="+id+"";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
%>
<h1 align="center">修改商品信息</h1>
<form name="form1" method="post" action="updatasave.jsp?id=<%=id%>">
<table width="399" border="1" align="center">
<tr>
<td width="168">商品编码:</td>
<td width="215"><input type="text" name="bm" value=<%=rs.getString("bm")%>></td>
</tr>
<tr>
<td>商品名称:</td>
<td><input type="text" name="mc" value=<%=rs.getString("mc")%>></td>
</tr>
<tr>
<td>商品价格:</td>
<td><input type="text" name="jg" value=<%=rs.getString("jg")%>></td>
</tr>
<tr>
<td colspan="2">
<input type="submit" name="Submit" value="提交">
<input type="reset" name="Submit2" value="重置"></td>
</tr>
</table>
</form>
<%
}
rs.close();
stmt.close();
con.close();
}
catch(Exception e){
out.println(e);
}
%>
<p align="center"> </p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -