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 " %> 
 <%  @page  import = "jdbc.sqlServer" %> 
 <%  @page  import = "java.sql.Connection" %> 
 <%  @page  import = "java.sql.PreparedStatement" %> 
 <%  
String id   =   request.getParameter("id");
id   =  new String(id.getBytes("ISO -  8859  -  1 "),"utf -  8  ");



     //  引用连接数据库方法
  sqlServer sq  =  new sqlServer();
      //  得到数据库连接
   Connection con   =   sq.getConnection();
      //  编写sql语句
 String sql  = " delete    from   Dog   where  id = "  +  id  +   "";
    
    //  得到数据库操作对象

  PreparedStatement st   =  con.prepareStatement(sql);

       //   得到查询的结果
  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对数据进行删除的详细内容...