SQL Server對數據進行修改，修改數據庫中的數據。
<table border=1px style="width:500px;height:200px;text-align:center;margin: 0 auto"> <tr style="background:red"> <td>編號</td> <td>書名</td> <td>價格</td> <td>喜愛度</td> <td>作者</td> <td>刪除</td> <td>修改</td> </tr> <% //引用連接數據庫方法 sqlServer sq=new sqlServer(); //得到數據庫連接 Connection con = sq.getConnection(); //編寫sql語句 String sql="select * from Dog"; //得到數據庫對象操作 Statement st=con.createStatement(); // 得到查詢的結果 ResultSet rs = st.executeQuery(sql); while(rs.next()){ %> <tr> <td> <%out.PRint(rs.getInt(1) + "/t"); %></td> <td> <%out.print(rs.getString(2) + "/t"); %></td> <td> <%out.print(rs.getInt(3) + "/t"); %></td> <td> <%out.print(rs.getInt(4)+"%" + "/t"); %></td> <td> <%out.println(rs.getString(5)+ "/t"); %></td> <td> <a href="Delect.jsp?id=<%out.print(rs.getInt(1) + "/t"); %>">刪除</a></td> <td> <a href="Update.jsp?id=<%out.print(rs.getInt(1) + "/t"); %>">修改</a></td> </tr><% } //釋放資源 sq.ShiFang(rs,st,con); %> </table><%@ page language="java" import="java.util.*" pageEncoding="utf-8"%><html><head><title>更新書的信息</title></head><body> <form action="update_Dog.jsp" method="post"> <table align="center"> <tr> <td>請輸入編號：</td> <td><input type="text" name="id" readonly="readonly" value=" <%=request.getParameter("id") %>"></td> </tr> <tr> <td>請輸入新的的書名：</td> <td><input type="text" name="name" ></td> </tr> <tr> <td>請輸入書的價格：</td> <td><input type="text" name="health" ></td> </tr> <tr> <td>請輸入書的喜愛度：</td> <td><input type="text" name="love" ></td> </tr> <tr> <td>請輸入書的作者：</td> <td><input type="text" name="strain" ></td> </tr> <tr colspan=2> <td><input type="submit" value="提交"></td> <td><input type="reset" value="重置"></td> </tr> </table> </form></body></html><%@ page language="java" import="java.util.*" pageEncoding="utf-8"%><%@page import="java.sql.PreparedStatement"%><%@page import="jdbc.sqlServer"%><%@page import="java.sql.Connection"%><%@page import="java.sql.ResultSet"%><%String id = request.getParameter("id");String name = request.getParameter("name");name = new String(name.getBytes("ISO-8859-1"),"utf-8");String health = request.getParameter("health");String love = request.getParameter("love");String strain = request.getParameter("strain");strain = new String(strain.getBytes("ISO-8859-1"),"utf-8"); //引用連接數據庫方法 sqlServer sq=new sqlServer(); //得到數據庫連接 Connection con = sq.getConnection(); //編寫sql語句 String sql="update Dog set name=?, health=? ,love=?, strain=? where id=?"; //得到數據庫操作對象 PreparedStatement st=null; st =con.prepareStatement(sql); st.setString(1,name); st.setString(2,health); st.setString(3,love); st.setString(4,strain); st.setString(5,id); // 得到查詢的結果if(st.executeUpdate()>0){ %> <script type="text/Javascript"> alert("更新成功"); location="showLog.jsp"; </script> <% }else{ %> <script type="text/javascript"> alert("更新失敗"); location="showLog.jsp"; </script> <% } %>新聞熱點
疑難解答
