当前位置：Gxlcms > 数据库问题 > SQL Server对数据进行修改

SQL Server对数据进行修改

时间：2021-07-01 10:21:17 帮助过：5人阅读

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对数据进行修改

人气教程排行