SQL Server对数据进行修改

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>
   <%
             
          }
 

%>

 

posted on 2015-05-24 13:05  梦之航  阅读(1205)  评论(0)  编辑  收藏  举报

导航