81,092
社区成员
发帖
与我相关
我的任务
分享
while(rs.next()){
%>
<td align="center"><%=rs.getString("aid")%> </td>
<td align="center"><%=rs.getString("bname")%> </td>
<td align="center"><%=rs.getString("bnumber")%> </td>
<td align="center"><%=rs.getString("bbz")%> </td>
<td align="center"><a href="update.jsp">修改</a> <a href="del.jsp">删除</a></td>
</tr>
<%
<%
request.setCharacterEncoding("utf-8");
String aid=request.getParameter("aid");
String bname=request.getParameter("bname");
String bnumber=request.getParameter("bnumber");
String bbz=request.getParameter("bbz");
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url="jdbc:sqlserver://localhost:1433;databaseName=school";
String user="sa";
String userpassword="123456";
Connection conn= DriverManager.getConnection(url,user,userpassword);
Statement stmt=conn.createStatement();
String sql="update t_bulding set bname='"+bname+"', aid='"+aid+"', bnumber='"+bnumber+"', bbz='"+bbz+"' ";
stmt.executeUpdate(sql) ;
stmt.close();
conn.close();
%>