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

  %> 

 

SQL Server对数据进行修改

标签：

查看更多关于SQL Server对数据进行修改的详细内容...