📄 update.jsp

📁 sql server 2005书中11到16章的全部代码

💻 JSP

字号:

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.util.*;" errorPage=""%>
<html>
<head>
<title>修改记录</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div align="center"><font color="#000000" size="5">修改数据库中的记录</font> </div>
<hr>
<%!	String changkuhao,url,sql,sex; %>
<%!	Connection conn; %>
<%!	ResultSet rs; %>
<%!	Statement stmt; %>
<%
  changkuhao=request.getParameter("changkuhao").trim();
  try{
      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
     String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=company";
	 Connection conn=DriverManager.getConnection(url,"aspnet1","123");//建立与数据库的连接
	stmt=conn.createStatement();
	sql="select * from 仓库 where 仓库号='"+changkuhao+"'"; 
	rs=stmt.executeQuery(sql);
	while(rs.next()){
%>
<form name="form1" method="post" action="update_do.jsp?changkuhao=<%=rs.getObject(1)%>">
  <table width="35%" border="1" cellspacing="1" cellpadding="1" align="center">
    <tr> 
      <td width="46%" align="center">仓库号 </td>
      <td width="54%"> &nbsp;&nbsp;&nbsp;<%=rs.getObject(1)%></td>
    </tr>
    <tr> 
      <td width="46%" align="center">城市 </td>
      <td width="54%"> &nbsp;&nbsp;&nbsp;<input type="text" name="city" size="8" value=<%=rs.getObject(2)%>></td>
    </tr>
    <tr> 
      <td width="46%" align="center">面积</td>
      <td width="54%"> &nbsp;&nbsp;&nbsp;<input type="text" name="mj" size="8" value=<%=rs.getObject(3)%>></td>
    </tr>
    <tr align="center"> 
      <td colspan="2" align="center"> 
        <input type="submit" name="Submit" value="提交">&nbsp;&nbsp;&nbsp; 
        <input type="reset" name="reset" value="清空">
      </td>
    </tr>
  </table>
</form>
<%
	}
	rs.close();
	stmt.close();
	conn.close();
  }
  catch(Exception e){
    out.println(e);
  }
%>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -