库名bookstore,表名book
插入页面
<form action="InsertRequire.jsp">
书号:<input type="text" name="BookId"><br>
书名:<input type="text" name="BookName"><br>
售价: <input type="text" name="BookSale"><br>
出版社:<input type="text" name="BookPublish"><br>
<input type="submit" name="提交">
</form>
插入反应页面
<%int id=Integer.parseInt((String)request.getParameter("BookId")); %>
<%String name=(String)request.getParameter("BookName");%>
<%int sale=Integer.parseInt((String)request.getParameter("BookSale"));%>
<%String publish=(String)request.getParameter("BookPublish");%>
<%Class.forName("com.mysql.jdbc.Driver");%>
<%Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/bookstore?useSSL=false&serverTimezone=UTC", "root","mysql"); %>
<%String sql="insert into bookinfo(id,name,sale,publish) value(?,?,?,?)"; %>
<% PreparedStatement pre=conn.prepareStatement(sql);%>
<% pre.setInt(1, id); %>
<% pre.setString(2, name); %>
<% pre.setInt(3, sale); %>
<% pre.setString(4, publish); %>
<% int i=pre.executeUpdate(); %>
<% if(i>0) %>
<%="插入成功" %>
<% pre.close(); %>
<%conn.close(); %>