如题,运行Addbooks.java时无法跳转到txt.jsp获取数据
package src.web;
import java.io.PrintWriter;
import java.io.IOException;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import src.dao.Newbooks;
import src.dao.SelectbooksDao;
import src.dao.addDao;
import src.model.Books;
@WebServlet("/Addbooks")
public class Addbooks extends HttpServlet {
public Addbooks() {
super();
}
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request,response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
String bid=request.getParameter("bid");
String bname=request.getParameter("bname");
String bwritename=request.getParameter("bwritename");
String bpress=request.getParameter("bpress");
String bpages=request.getParameter("bpages");
String bnumber=request.getParameter("bnumber");
String blast=request.getParameter("blast");
Books u=new Books();
u.setBid(bid);
u.setBname(bname);
u.setBwritename(bwritename);
u.setBpress(bpress);
u.setBpages(bpages);
u.setBnumber(bnumber);
u.setBlast(blast);
addDao udao=new addDao();
int n=udao.add(u);
if(n>0) {
out.println("tian success");
}
else
{
out.println("添加失败");
}
out.println(" </BODY>");
out.println("</HTML>");
out.flush();
out.close();
}
public void init() throws ServletException {
// Put your code here
}
}
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
<form name="frm1" action="Addbooks">
<p>商品编号:
<label for="textfield"></label>
<input type="text" name="bid" id="textfield" />
</p>
<p>商品名字:
<input type="text" name="bname" id="textfield2" />
</p>
<p>商品品牌:
<input type="text" name="bwritename" id="textfield3" />
</p>
<p>商品产地:
<input type="text" name="bpress" id="textfield4" />
</p>
<p>生产厂家:
<input type="text" name="bpages" id="textfield5" />
</p>
<p>备注:
<input type="text" name="bnumber" id="textfield5" />
</p>
<p> </p>
<input type="submit" value="确定"/>
</form>
</body>
</html>
package src.dao;
import java.sql.*;
import java.util.List;
import src.model.Books;
import src.util.DBUtil;
import java.util.ArrayList;
public class addDao {
public int add(Books u)
{
int n=0;
try {
// 创建连接 testdb是数据库名称
Connection conn=DBUtil.getConn();
// Books adbooks=new Books();
// 创建声明SQL对象
Statement stm = conn.createStatement();
// 执行SQL语句,得到结果集,结果集放到ResultSet对象中
String sql = "insert into books values(null,'"+u.getBname()+"','"+u.getBwritename() +"','"+u.getBpress() +"','"+u.getBpages() +"','"+u.getBnumber() +"','"+u.getBnumber() +"');";
n=stm.executeUpdate(sql);
} catch (SQLException e) {
System.out.println("数据库操作出错" + e.getMessage());
}
return n;
}
}