📄 addbook.jsp~5~
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!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=gb2312">
<title>addbook</title>
<style type="text/css">
<!--
.style7 {font-size: 2}
-->
</style>
</head>
<body>
<form name="form1" method="post" action="">
<table width="80%" border="0" align="center" cellpadding="4" cellspacing="1" id="table">
<tr>
<td width="45%" align="right"><span class="style7">serial number:</span></td>
<td><input name="serialnumber" type="text" id="serialnumber" size="10" maxlength="8"></td>
</tr>
<tr>
<td width="45%" align="right"><span class="style7">sort number:</span></td>
<td><input name="sortnumber" type="text" id="sortnumber" size="8" maxlength="4"></td>
</tr>
<tr>
<td width="45%" align="right"><span class="style7">title:</span></td>
<td><input name="title" type="text" id="title" size="10" maxlength="8"></td>
</tr>
<tr>
<td width="45%" align="right"><span class="style7">author1:</span></td>
<td><input name="author1" type="text" id="author1" size="10" maxlength="8"></td>
</tr>
<tr>
<td width="45%" align="right">author2:</td>
<td><input name="author2" type="text" id="author2" size="10" maxlength="7"></td>
</tr>
<tr>
<td width="45%" align="right"><span class="style7">author3:</span></td>
<td><input name="author3" type="text" id="author3" size="10" maxlength="7"></td>
</tr>
<tr>
<td width="45%" align="right"><span class="style7">cover:</span></td>
<td><input name="cover" type="text" id="cover" size="35" maxlength="30"></td>
</tr>
<tr>
<td width="45%" align="right"><span class="style7">bookconcern:</span></td>
<td><input name="bookconcern" type="text" id="bookconcern" size="10" maxlength="8"></td>
</tr>
<tr>
<td width="45%" align="right"><span class="style7">publicday:</span></td>
<td><input name="publicday" type="text" id="publicday" size="15" maxlength="10"></td>
</tr>
<tr>
<td width="45%" align="right">ISBN:</td>
<td><input name="isbn" type="text" id="isbn" size="8" maxlength="5"></td>
</tr>
<tr>
<td width="45%" align="right"><span class="style7">Times:</span></td>
<td><input name="times" type="text" id="times" size="5" maxlength="3"></td>
</tr>
<tr>
<td width="45%" align="right"><span class="style7">Prize:</span></td>
<td><input name="prize" type="text" id="prize" size="5" maxlength="3"></td>
</tr>
<tr>
<td width="45%" align="right"><span class="style7">Innumber</span></td>
<td><input name="innumber" type="text" id="innumber" size="5" maxlength="3"></td>
</tr>
<tr align="center">
<td colspan="2"><span class="style7">
<input name="enter" type="submit" id="enter" value="enter">
<input name="reset" type="reset" id="reset" value="reset">
</span></td>
</tr>
</table>
</form>
<jsp:useBean id="Library" scope="page" class="login.Library">
</jsp:useBean>
<center>
<%
try{
if(request.getParameter("enter")!=null){
Connection conn=Library.getConn();
Statement stmt=conn.createStatement();
String serialnumber = request.getParameter("serialnumber");
String sortnumber = request.getParameter("sortnumber");
String title = request.getParameter("title");
String author1 = request.getParameter("author1");
String author2 = request.getParameter("author2");
String author3 = request.getParameter("author3");
String cover = request.getParameter("cover");
String bookconcern = request.getParameter("bookconcern");
long publicday =Integer.parseInt(request.getParameter("publicday"));
String isbn = request.getParameter("isbn");
int times = Integer.parseInt(request.getParameter("times"));
int prize = Integer.parseInt(request.getParameter("prize"));
int innumber = Integer.parseInt(request.getParameter("innumber"));
String insertStr = "insert into book(serialnumber,sortnumber,title,author1,author2,author3,cover,bookconcern,publicday,isbn,times,prize,innumber,outnumber) values('" + serialnumber + "','" + sortnumber + "','" + title + "','" + author1 + "','" + author2 + "','" + author3 + "','" + cover + "','" + bookconcern + "','" + publicday + "','" + isbn + "','" + times + "','" + prize + "','" + innumber + "','0')";
stmt.execute(insertStr);
response.sendRedirect("success.jsp");
}
}catch (Exception ex) {
response.sendRedirect("fail.jsp");
ex.printStackTrace();}
%>
</center>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -