<%@page import = "test.AddBook" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>添加图书到SQL Server数据库</title>
<meta name = "Generator" content = "EditPlus">
<meta name = "Author" content = "">
<meta name = "Keywords" content = "">
<meta name = "Description" content = "">
</head>
<body>
<h2><B>在下面输入图书信息后提交</b></h2></Br>
<form method = "post" action = "/libt/test/AddBook">
图书名称:<input type="text" name="bookname"/><Br>
图书作者:<input type="text" name="bookauthor"/><Br>
图书价格:<input type="text" name="bookprice"/><Br>
图书介绍:<textarea name="bookintroduce" row=6></textarea>><Br>
<input type="submit" value="提交"><input type="reset"value=重填>
</form>
</body>
</html>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>添加图书到SQL Server数据库</title>
<meta name = "Generator" content = "EditPlus">
<meta name = "Author" content = "">
<meta name = "Keywords" content = "">
<meta name = "Description" content = "">
</head>
<body>
<h2><B>在下面输入图书信息后提交</b></h2></Br>
<form method = "post" action = "/libt/test/AddBook">
图书名称:<input type="text" name="bookname"/><Br>
图书作者:<input type="text" name="bookauthor"/><Br>
图书价格:<input type="text" name="bookprice"/><Br>
图书介绍:<textarea name="bookintroduce" row=6></textarea>><Br>
<input type="submit" value="提交"><input type="reset"value=重填>
</form>
</body>
</html>
/libt/libt/test应该是namespace
AddBook 这个是action名称
<!DOCTYPE web-app
PUBLIC "-//Sun Microsystem, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd"><web-app>
<servlet>
<servlet-name>test</servlet-name>
<display-name>test</display-name>
<description>A test Servlet</description>
<servlet-class>test.AddBook</servlet-class>
</servlet> <servlet-mapping>
<servlet-name>test</servlet-name>
<url-pattern>/test</url-pattern>
</servlet-mapping>
</web-app>
<servlet-mapping>
<servlet-name>test</servlet-name>
<url-pattern>/test</url-pattern>
</servlet-mapping>
HTML 中 form 的 action 的值应该和 url-pattern 节点的值相同,即:
<form method = "post" action = "/test">
package test;
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;public class AddBook extends HttpServlet{
public void doPost(HttpServletRequest request,HttpServletResponse response)
throws ServletException,IOException{
String bookName = new String (request.getParameter("bookname").getBytes("8859_1"));
String bookAuthor = new String (request.getParameter("bookauthor").getBytes("8859_1"));
String bookPrice = new String (request.getParameter("bookprice").getBytes("8859_1"));
String bookIntroduce = new String (request.getParameter("bookintroduce").getBytes("8859_1"));
java.sql.Connection conn=null;
java.sql.Statement st=null;
response.setContentType("text/html;charset=gb2312");
PrintWriter out=response.getWriter();
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=library","sa","");
st = conn.createStatement();
st.executeUpdate("insert into bookInfo values('"+bookName+"','"+bookAuthor+"','"+bookPrice+"','"+bookIntroduce+"')");
conn.close();
out.println("图书已经成功添加到数据库!");
}
catch(Exception e){
out.println("发生如下错误:<Br>");
out.println(e.getMessage());
}
}
}