下面介绍一下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> <% } %>