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