下面介紹一下SQL Server如何往數據庫中加入數據。

 <!-- 添加主人信息 -->         <form action="add_Admin.jsp" method="post" >  <table  align="center">   <tr>    <td>添加書籍：</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="提交" style="margin-left:0px;color:red;background:#8D0023"></td>           <td><input type="reset" value="重置" style="margin-left:50px;color:red;background:#8D0023"></td>              </tr>      </table>   </form>     

處理提交的語句：

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%><%@page import="jdbc.sqlServer"%><%@page import="java.sql.Connection"%><%@page import="java.sql.ResultSet"%><%@page import="java.sql.PReparedStatement"%><%       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="insert into Dog values (?,?,?,?)";                    //得到數據庫操作對象                PreparedStatement st =con.prepareStatement(sql);         st.setString(1,name);         st.setString(2,health);         st.setString(3,request.getParameter("love"));         st.setString(4,strain);                 // 得到查詢的結果                               if(st.executeUpdate()>0){          %>              <script type="text/Javascript">                alert("添加成功");                location="showLog.jsp";            </script>          <%                   }else{                            %>              <script type="text/javascript">                alert("添加失敗");                location="showLog.jsp";            </script>          <%                               }                   %>