Index.jsp
<%@ page language="java" import="java.sql.*" pageEncoding="gb2312"%> <%@page errorpage ="error.jsp"%>
添加图书信息
书名 | 作者 | 价格 | 管理 |
<%
Class.forName("com.mysql.jdbc.Driver"); Connection con
DriverManager.getConnection("jdbc:mysql://localhost:3307/school","root","ylx"); Statement stmt = con.createStatement(); String s = "Select * FROM book"; ResultSet rs = stmt.executeQuery(s); while(rs.next()) {
int id=rs.getInt(1);
out.println(""+rs.getString(2)+" |
"+rs.getString(3)+" "+rs.getString(4)+"修href='del.jsp?id="+id+"'>删除"); }
rs.close(); stmt.close(); con.close(); %>
Add.jsp <%@ page contentType="text/html;charset=gb2312" errorPage="error.jsp"%>
<%
request.setCharacterEncoding("gb2312");
String submit=request.getParameter("submit"); if(submit!=null&;&;!submit.equals("")) {
String bookname=request.getParameter("bookname"); String author=request.getParameter("author"); String price=request.getParameter("price"); Class.forName("com.mysql.jdbc.Driver"); Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3307/school","root","ylx"); Statement stmt = con.createStatement(); String sql="insert into book(bookname,author,price) values('"+bookname+"','"+author+"',"+price+")"; int i=stmt.executeUpdate(sql); if(i==1) {
out.println("");
response.setHeader("refresh","1;url=index.jsp"); } else{
out.println("");
response.setHeader("refresh","1;url=add.jsp"); }
stmt.close(); con.close(); } %>
Edit.jsp
<%@ page import="java.sql.*" pageEncoding=gb2312" errorPage="error.jsp"%>
<%
request.setCharacterEncoding("gb2312"); Class.forName("com.my
sql.jdbc.Driver"); Connection con
DriverManager.getConnection("jdbc:
mysql://localhost:3307/school","root","ylx"); Statement stmt = con.createStatement(); String id=request.getParameter("id");
ResultSet rs = stmt.executeQuery("select*from book where id="+id); rs.next(); %>
<%
rs.close(); stmt.close(); con.close(); %>
Update.jsp
<%@ page import="java.sql.*" pageEncoding=gb2312" errorPage="error.jsp"%>
<%
request.setCharacterEncoding("gb2312");
String bookname=request.getParameter("bookname"); String author=request.getParameter("author"); String price=request.getParameter("price"); String id=request.getParameter("id"); Class.forName("com.mysql.jdbc.Driver"); Connection con = DriverManager.getC