序号 | |
书号 | |
书名 | |
作者 | |
出版社 | ------请选择------ 清华大学出版社 高等学府出版社 安徽出版社 |
价格 | |
类别 | |
添加后执行功能:
把添加的信息导入数据库
tianxian.jsp
<%@pagelanguage="java"contentType="text/html;charset=utf-8"
pageEncoding="UTF-8"%>
<%@pageimport="java.sql.*"%>
<%
Stringpath=request.getContextPath();
StringbasePath=request.getScheme()+":
//"+request.getServerName()+":
"+request.getServerPort()+path+"/";
%>
DOCTYPEHTMLPUBLIC"-//W3C//DTDHTML4.01Transitional//EN">
">
MyJSP'tianxian.jsp'startingpage
--
-->
<%
request.setCharacterEncoding("utf-8");
Stringid=request.getParameter("bookId");
Stringnum=request.getParameter("bookNumber");
Stringname=request.getParameter("bookName");
Stringauthor=request.getParameter("author");
Stringpub=request.getParameter("chu_ban_she_shi");
Stringprice=request.getParameter("price");
Stringtype=request.getParameter("type");
Connectionconn=null;
PreparedStatementpstm=null;
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Stringurl="jdbc:
sqlserver:
//localhost:
1433;databasename=bookshop";
conn=DriverManager.getConnection(url,"root","1234");
Stringsql="insertintobooks(bookid,booknumber,bookname,author,publish,price,type)values(?
?
?
?
?
?
?
)";
pstm=conn.prepareStatement(sql);
pstm.setString(1,id);
pstm.setString(2,num);
pstm.setString(3,name);
pstm.setString(4,author);
pstm.setString(5,pub);
pstm.setString(6,price);
pstm.setString(7,type);
pstm.executeUpdate();
if(pstm!
=null)
pstm.close();
if(conn!
=null)
conn.close();
response.sendRedirect("/hehehehhehehehe/b/xiancha.jsp");
%>
编辑页面
edit.jsp
<%@pagelanguage="java"import="java.util.*"pageEncoding="utf-8"%>
<%
Stringpath=request.getContextPath();
StringbasePath=request.getScheme()+":
//"+request.getServerName()+":
"+request.getServerPort()+path+"/";
%>
DOCTYPEHTMLPUBLIC"-//W3C//DTDHTML4.01Transitional//EN">
">
MyJSP'edit.jsp'startingpage
--
-->
<%request.setCharacterEncoding("utf-8");%>
序号 | '> |
书号 | '> |
书名 | '> |
作者 | '> |
出版社名称 | '> |
价格 | '> |
类别 | '> |
|
执行编辑功能:
把编辑的数据导入数据库
edit1.jsp
<%@pagelanguage="java"import="java.util.*,java.sql.*"pageEncoding="utf-8"%>
<%
Stringpath=request.getContextPath();
StringbasePath=request.getScheme()+":
//"+request.getServerName()+":
"+request.getServerPort()+path+"/";
%>
DOCTYPEHTMLPUBLIC"-//W3C//DTDHTML4.01Transitional//EN">
">
MyJSP'edit1.jsp'startingpage
--
-->
<%
request.setCharacterEncoding("utf-8");
Stringid=request.getParameter("bookid");
Stringnum=request.getParameter("booknumber");
Stringname=request.getParameter("bookname");
Stringpub=request.getParameter("publish");
Stringauthor=request.getParameter("author");
Stringprice=request.getParameter("price");
Stringtype=request.getParameter("type");
Connectionconn=null;
PreparedStatementpstm=null;
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Stringurl="jdbc:
sqlserver:
//localhost:
1433;databasename=bookshop";
conn=DriverManager.getConnection(url,"root","1234"