JSP图书管理系统代码

Login.jsp代码：

<%@page language="java"contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

登录图书管理系统

用户名：
密码：

Valid.jsp代码：

<%@page language="java"contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<%@page import="java.sql.*"%>

<%

String user=request.getParameter("username");

String pass=request.getParameter("password");

Class.forName("com.mysql.jdbc.Driver");

Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/bk","root","12345 6");

PreparedStatement ps =con.prepareStatement("select * from t_account where username=? and password=?");

ps.setString(1,user);

ps.setString(2,pass);

ResultSet rs = ps.executeQuery();

if(rs.next()){response.sendRedirect("bookList.jsp");}

else response.sendRedirect("login.jsp");

%>

BookAdd.jsp代码：

<%@page language="java"contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

添加图书信息

书名：
出版社：
价格：

BookDel.jsp代码：

<%@page language="java"contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<%@page import="java.sql.*"%>

<%

//["3","4","6"]

String[] ids = request.getParameterValues("ids");

Class.forName("com.mysql.jdbc.Driver");

Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/bk","root","12345 6");

PreparedStatement ps = con.prepareStatement("delete from t_book where id=?");

for(int i = 0;i

ps.setInt(1,Integer.parseInt(ids[i]));

ps.execute();

}

con.close();

%>

正在删除图书，3秒后自动跳转......

bookEdit.jsp代码：

<%@page language="java"contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<%@page import="java.sql.*"%>

<%String strId = request.getParameter("id");//获取传过来的参数（网络上传输的只能是字符串）

Class.forName("com.mysql.jdbc.Driver");//java的反射

Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/bk","root","12345 6");

PreparedStatement ps =con.prepareStatement("select * from t_book where id=?");

ps.setInt(1,Integer.parseInt(strId));

ResultSet rs=ps.executeQuery();

if(rs.next()){

%>

">

编辑图书信息

书名：	">
出版社：	">
价格：	">

<%

}

con.close();

%>

bookList.jsp代码：

<%@page language="java"contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<%@page import="java.sql.*"%>

<%String strId = request.getParameter("id");//获取传过来的参数（网络上传输的只能是字符串）

Class.forName("com.mysql.jdbc.Driver");//java的反射

Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/bk","root","12345 6");

PreparedStatement ps =con.prepareStatement("select * from t_book where id=?");

ps.setInt(1,Integer.parseInt(strId));

ResultSet rs=ps.executeQuery();

if(rs.next()){

%>

">

编辑图书信息

书名：	">
出版社：	">
价格：	">

<%

}

con.close();

%>

bookSaveAdd.jsp代码：

<%@page language="java"contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<%@page import="java.sql.*"%>

<%

//获取提交参数

String name=request.getParameter("name");

String pub=request.getParameter("publish");

String strPr=request.getParameter("price");

int price=Integer.parseInt(strPr);//数据转换：字符串（数字）转整型

//利用jdbc完成数据库插入操作

Class.forName("com.mysql.jdbc.Driver");//java的反射

Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/bk","root","12345 6");

PreparedStatement ps =con.prepareStatement("insert into t_book(name,publish,price) values(?,?,?)");

ps.setString(1,name);

ps.setString(2,pub);

ps.setInt(3,price);

ps.execute();

con.close();

response.sendRedirect("bookList.jsp");

%>

bookSaveEdit.jsp代码：

<%@page language="java"contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<%@page import="java.sql.*"%>

<%

String strId = request.getParameter("id");

String name=request.getParameter("name");

String pub=request.getParameter("publish");

String strPr=request.getParameter("price");

int price=Integer.parseInt(strPr);//数据转换：字符串（数字）转整型

int id=Integer.parseInt(strId);

//利用jdbc完成数据库插入操作

Class.forName("com.mysql.jdbc.Driver");//java的反射

Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/bk","root","12345 6");

PreparedStatement ps =con.prepareStatement("update t_book set name=?,publish=?,price=? where id=?");

ps.setString(1,name);

ps.setString(2,pub);

ps.setInt(3,price);

ps.setInt(4,id);

ps.execute();

con.close();

response.sendRedirect("bookList.jsp");

%>