【web应用系统实践】第四章作业

创作不易，如果你觉得有用不妨点个赞~
代码可以自由复制、转载。

建立数据库 lianxi，在该数据库下建立一个图书表 book，图书包含信息：图书号、图书名、作者、价格、备注字段。设计一应用程序，完成图书信息的管理。主要完成图书信息的添加、查询、删除、修改等操作。

(1个数据库建表语句 + 1个Java类 + 5个页面 )

1. 数据库建表语句

create database if not exists lianxi;
use lianxi;
drop table if exists book;
create table book(
    id       int auto_increment primary key,
    bookName varchar(30)  default ''   not null,
    author   varchar(20)  default ''   not null,
    price    float(8, 2)  default 0.00 not null,
    message  varchar(100) default ''   not null
);

INSERT INTO lianxi.book ( bookName, author, price, message) VALUES ( '《作业好难》', 'yourself', 30, '做完了吗？');

2. DBBean.java（数据库连接类）

package book.bean;
import java.sql.*;
public class DBBean {
    private String driverStr="com.mysql.cj.jdbc.Driver";
    private String url1="jdbc:mysql://localhost:3306/lianxi";
    private String url2="?user=root&password=123456";
    private String url3="&useUnicode=true&characterEncoding=UTF-8";
    private String connStr;
    private Connection conn=null;
    private Statement stmt=null;
    public DBBean(){
        connStr=url1+url2+url3;
        try{
            Class.forName(driverStr);
            conn = DriverManager.getConnection(connStr);
            stmt = conn.createStatement();
        }catch(Exception ex){
            System.out.println("无法同数据库建立连接！");
        }
    }
    public int executeUpdate(String s){
        int result=0;
        try{
            result=stmt.executeUpdate(s);
        }catch(Exception ex){
            System.out.println("执行更新错误！");
        }
        return result;
    }
    public ResultSet executeQuery(String s){
        ResultSet rs=null;
        try{
            rs=stmt.executeQuery(s);
        }
        catch(Exception ex){
            System.out.println("执行查询错误！");
        }
        return rs;
    }
    public void close(){
        try{
            stmt.close();
            conn.close();
        }
        catch(Exception e){}
    }
}

3. https://blog.csdn.net/qq_35760825/article/details/index.jsp（首页）

<%@ page import="java.sql.*" pageEncoding="UTF-8" %>


    图书系统


增加图书信息

");
	  }
	  resultSet.close();
	  db.close();
	  %>

    
        书名
        作者
        价格
        操作
        备注
            
                <%
	  String s="select * from book";
	  ResultSet resultSet=db.executeQuery(s);
	  while(resultSet.next()){
	    int id=resultSet.getInt(1);
	    out.println("
"+resultSet.getString(2)+" "+resultSet.getString(3)+" "+resultSet.getString(4)+" 删除 修改 "+resultSet.getString(5)+"

4. https://blog.csdn.net/qq_35760825/article/details/addBook.jsp（添加图书页面）

<%@ page contentType="text/html; charset=gb2312"  %>

添加图书


    
        添加图书
        
            书名：
            
        
        
            作者：
            
        
        
            价格：
             元
        
        
            备注：
            
        
        
            
                
                
            
        
    



<%
    request.setCharacterEncoding("gb2312");
    String submit = request.getParameter("submit");
    if (submit != null && !submit.equals("")) {
        String b = request.getParameter("bookName");
        String m  = request.getParameter("message");
        String p    = request.getParameter("price");
        String a   = request.getParameter("author");
        String sql      = "insert into book(bookName,author,price,message) values('" + b + "','" + a + "'," + p + ",'" + m + "')";
        int    i        = db.executeUpdate(sql);
        if (i == 1) {
            out.println("");
            response.setHeader("refresh", "1;url=https://blog.csdn.net/qq_35760825/article/details/index.jsp");
        } else {
            out.println("");
            response.setHeader("refresh", "1;url=https://blog.csdn.net/qq_35760825/article/details/addBook.jsp");
        }
        db.close();
    }
%>

添加图书
书名：
作者：
价格：	元
备注：

5. editBook.jsp（编辑图书页面）

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

修改图书


<%
  request.setCharacterEncoding("gb2312");
  String id=request.getParameter("id");
  ResultSet resultSet =db.executeQuery("select * from book where id="+id);
  resultSet.next();
%>

  
    修改图书
    
      书名：
      
        
    
    
      作者：
      
    
    
      价格：
      元
    
    
      备注：
      
    
    
      
        
        
        
      
    
  

<%
  db.close();
%>

修改图书
书名：
作者：
价格：	元
备注：

6. update.jsp（更新操作）

<%@ page  contentType="text/html; charset=gb2312" %>


    update



<%
    request.setCharacterEncoding("gb2312");
    String b = request.getParameter("bookName");
    String a = request.getParameter("author");
    String p = request.getParameter("price");
    String id = request.getParameter("id");
    String m = request.getParameter("message");
    String sql = "update book set bookName='" + b + "',author='" + a + "',price=" + p + ",message='" + m + "' where id=" + id;
    int i = db.executeUpdate(sql);
    if (i == 1) {
        out.println("");
        response.setHeader("refresh", "1;url=https://blog.csdn.net/qq_35760825/article/details/index.jsp");
    }
    db.close();
%>

7. dropBook.jsp（删除图书操作）

<%@ page contentType="text/html; charset=gb2312" %>


删除


<%
  String id=request.getParameter("id");
  request.setCharacterEncoding("gb2312");
  int i=db.executeUpdate("delete from book where id="+id);
  if(i==1)
  {out.println("");
    response.setHeader("refresh","1;url=https://blog.csdn.net/qq_35760825/article/details/index.jsp");
  }
  else{
    out.println("");
    response.setHeader("refresh","1;url=dropBook.jsp");
  }
  db.close();
%>

（结束）

设计一个简单的网上名片管理系统，实现名片的增、删、改、查等操作。该名片管理系统包括如下功能。

(1) 用户登录与注册

用户登录：在登录时，如果用户名和密码正确，进入系统页面。

用户注册：新用户应该先注册，然后再登录该系统。

(2) 名片管理

增加名片：以仿真形式（按常用的名片格式）增加名片信息。

修改名片：以仿真形式（按常用的名片格式）修改名片信息。

查询名片：以模糊查询的方式查询名片。

删除名片：名片的删除有两种方式，即把名片移到回收站，把名片彻底删除。

(3) 回收站管理

还原：把回收站中的名片还原回收。

彻底删除：把名片彻底从回收站删除。

浏览/查询：可以模糊查询、浏览回收站中的名片。

(1个数据库建表语句 + 1个Java类 + 10个页面 )

1. 数据库建表语句

create database if not exists lianxi;
use lianxi;
drop table if exists user;
create table user(
                     id int primary key auto_increment,
                     username varchar(30) not null unique ,
                     password varchar(30) not null default '123456'
                         comment '默认密码都是123456'
);

# 管理员账号admin，密码123456
insert into user(username, password) values ('admin','123456');

drop table if exists card;
create table card(
                     id int primary key auto_increment,
                     name varchar(50) not null ,
                     age int,
                     sex char(1),
                     work varchar(50),
                     logicDelete int default 0
);
insert into card( name, age, sex, work) values ('张三',22,'男','职员'),
                                               ('李四',20,'女','经理');

2. DBBean.java（数据库连接类）

package book.bean;
import java.sql.*;
public class DBBean {
    private String driverStr="com.mysql.cj.jdbc.Driver";
    private String url1="jdbc:mysql://localhost:3306/lianxi";
    private String url2="?user=root&password=123456";
    private String url3="&useUnicode=true&characterEncoding=UTF-8";
    private String connStr;
    private Connection conn=null;
    private Statement stmt=null;
    public DBBean(){
        connStr=url1+url2+url3;
        try{
            Class.forName(driverStr);
            conn = DriverManager.getConnection(connStr);
            stmt = conn.createStatement();
        }catch(Exception ex){
            System.out.println("无法同数据库建立连接！");
        }
    }
    public int executeUpdate(String s){
        int result=0;
        try{
            result=stmt.executeUpdate(s);
        }catch(Exception ex){
            System.out.println("执行更新错误！");
        }
        return result;
    }
    public ResultSet executeQuery(String s){
        ResultSet rs=null;
        try{
            rs=stmt.executeQuery(s);
        }
        catch(Exception ex){
            System.out.println("执行查询错误！");
        }
        return rs;
    }
    public void close(){
        try{
            stmt.close();
            conn.close();
        }
        catch(Exception e){}
    }
}

3. https://blog.csdn.net/qq_35760825/article/details/index.jsp（首页、登录页面）

<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=UTF-8" %>


    名片管理系统
    



    
        用户名：
        密码 ：
        

        
        

        没有账号，立即注册？
    
    



<%
    request.setCharacterEncoding("gb2312");
    String submit = request.getParameter("submit");
    if (submit != null && !submit.equals("")) {
        String    username = request.getParameter("username");
        String    password = request.getParameter("password");
        String    sql      = "select count(*) from user where username = '" + username + "' and password = '" + password + "'";
        ResultSet rs       = db.executeQuery(sql);
        int       count    = 0;
        // 判断是否登录
        if (rs.next()) {
            count = rs.getInt(1);
        }
        if (count == 1) {
            Cookie cookie = new Cookie("login", username);
            response.addCookie(cookie);
            Cookie cookie2 = new Cookie("key", "");
            response.addCookie(cookie2);
            response.setHeader("refresh", "1;url=https://blog.csdn.net/qq_35760825/article/details/card.jsp");

        } else {
            out.println("");
            response.setHeader("refresh", "1;url=https://blog.csdn.net/qq_35760825/article/details/index.jsp");
        }
        db.close();
    } %>

4. https://blog.csdn.net/qq_35760825/article/details/register.jsp（注册页面）

<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    注册
    



    
        用户名：
        密码 ：
        

        
        

    
    



<%
    request.setCharacterEncoding("gb2312");
    String submit = request.getParameter("submit");
    if (submit != null && !submit.equals("")) {
        String u = request.getParameter("username");
        String p = request.getParameter("password");
        String s      = "insert into user(username,password) values('" + u + "','" + p + "')";
        try {
            int n = db.executeUpdate(s);
            if (n > 0) {
                out.println("");
                response.setHeader("refresh", "1;url=https://blog.csdn.net/qq_35760825/article/details/index.jsp");
            } else {
                out.println("");
                response.setHeader("refresh", "1;url=https://blog.csdn.net/qq_35760825/article/details/register.jsp");
            }
        } catch (Exception e) {
            out.println("");
            response.setHeader("refresh", "1;url=https://blog.csdn.net/qq_35760825/article/details/index.jsp");
        }
        db.close();
    }
%>

5. https://blog.csdn.net/qq_35760825/article/details/card.jsp（名片页面）

<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    名片管理系统
    


<%
    // 获取所有的cookie
    Cookie[] cookies = request.getCookies();
    String key = "";
    for (int i = 0; i < cookies.length; i++) {
        if (cookies[i].getName().equals("login")) {
            out.println("欢迎你，" + cookies[i].getValue() + "！");
        }
        if (cookies[i].getName().equals("key")) {
            key = cookies[i].getValue();
        }
    }
%>

    添加名片
      回收站
      退出登录


    姓名：
    

");
	  }
	  rs.close();
	  db.close();
	  %>

    
        姓名
        年龄
        性别
        职位
        操作
            
                <%
	  String s="select * from card where logicDelete=0 and name like '%"+key+"%'";
	  ResultSet rs=db.executeQuery(s);
	  while(rs.next()){
	    int id=rs.getInt(1);
	    out.println("
"+rs.getString(2)+" "+rs.getString(3)+" "+rs.getString(4)+" "+rs.getString(5)+" 删除 修改

6. https://blog.csdn.net/qq_35760825/article/details/addCard.jsp（添加名片页面）

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


    添加名片
    


返回首页

    
        姓名：
        
年龄：
        性别：男 
            女
        职位：
        

        
        

    
    这是头像



<%
    request.setCharacterEncoding("gb2312");
    String submit = request.getParameter("submit");
    if (submit != null && !submit.equals("")) {
        String n = request.getParameter("name");
        String a   = request.getParameter("age");
        String s    = request.getParameter("sex");
        String w  = request.getParameter("work");
        String sql      = "insert into card(name,age,sex,work) values('" + n + "'," + a + ",'" + s + "','" + w + "')";
        int    i        = db.executeUpdate(sql);
        if (i == 1) {
            out.println("");
            response.setHeader("refresh", "1;url=https://blog.csdn.net/qq_35760825/article/details/addCard.jsp");
        } else {
            out.println("");
            response.setHeader("refresh", "1;url=https://blog.csdn.net/qq_35760825/article/details/addCard.jsp");
        }
        db.close();
    }
%>

7. editCard.jsp（名片编辑页面）

<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    Title
    



<%
    request.setCharacterEncoding("gb2312");
    String id=request.getParameter("id");
    ResultSet resultSet =db.executeQuery("select * from card where id="+id);
    resultSet.next();
%>
返回首页

    
        姓名：
        
年龄：
        性别：男 
            女
        职位：
        

        
        
        

    这是头像

8. updateCard.jsp（名片更新操作）

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


    update



<%
    request.setCharacterEncoding("gb2312");
    String n = request.getParameter("name");
    String a = request.getParameter("age");
    String s = request.getParameter("sex");
    String w = request.getParameter("work");
    String id = request.getParameter("id");
    String sql = "update card set name='" + n + "',age=" + a + ",sex='" + s + "',work ='"+ w +"' where id=" + id;
    int i = db.executeUpdate(sql);
    if (i == 1) {
        out.println("");
        response.setHeader("refresh", "1;url=https://blog.csdn.net/qq_35760825/article/details/card.jsp");
    }
    db.close();
%>

9. delCard.jsp（删除名片，逻辑删除）

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>


delete


<%
    request.setCharacterEncoding("gb2312");
    String id=request.getParameter("id");
    int i=db.executeUpdate("update card set logicDelete = 1 where id="+id);
    if(i==1)
    {out.println("");
        response.setHeader("refresh","1;url=https://blog.csdn.net/qq_35760825/article/details/card.jsp");
    }
    else{
        out.println("");
        response.setHeader("refresh","1;url=https://blog.csdn.net/qq_35760825/article/details/card.jsp");
    }
    db.close();
%>

10. https://blog.csdn.net/qq_35760825/article/details/cycleCard.jsp（名片回收站）

<%@ page import="java.sql.*" %>
<%@ page import="com.sun.jdi.*" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    回收站
    



    返回首页
    
        关键词：
        
    
    ");
	  }
	  rs.close();
	  db.close();
	  %>
    
        
            姓名
            年龄
            性别
            职位
            操作
                
                    <%
                     String key = "";
                      Cookie[] cookies = request.getCookies();
                     for (int i = 0; i < cookies.length; i++) {
        if (cookies[i].getName().equals("key2")) {
            key = cookies[i].getValue();
        }
    }
	  String s="select * from card where logicDelete=1 and name like '%"+key+"%'";
	  ResultSet rs=db.executeQuery(s);
	  while(rs.next()){
	    int id=rs.getInt(1);
	    out.println("
"+rs.getString(2)+" "+rs.getString(3)+" "+rs.getString(4)+" "+rs.getString(5)+" 恢复 "+"彻底删除

11. recoverCard.jsp（恢复操作）

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


    Title



<%
    request.setCharacterEncoding("gb2312");
    String id=request.getParameter("id");
    int i=db.executeUpdate("update card set logicDelete = 0 where id="+id);
    if(i==1)
    {out.println("");
        response.setHeader("refresh","1;url=https://blog.csdn.net/qq_35760825/article/details/cycleCard.jsp");
    }
    else{
        out.println("");
        response.setHeader("refresh","1;url=https://blog.csdn.net/qq_35760825/article/details/cycleCard.jsp");
    }
    db.close();
%>

12. dropCard.jsp（彻底删除名片，物理删除）

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


  drop



<%
  request.setCharacterEncoding("gb2312");
  String id=request.getParameter("id");
  int i=db.executeUpdate("delete from card where id="+id);
  if(i==1)
  {out.println("");
    response.setHeader("refresh","1;url=https://blog.csdn.net/qq_35760825/article/details/cycleCard.jsp");
  }
  else{
    out.println("");
    response.setHeader("refresh","1;url=https://blog.csdn.net/qq_35760825/article/details/cycleCard.jsp");
  }
  db.close();
%>

书名	作者	价格	操作	备注 <% String s="select * from book"; ResultSet resultSet=db.executeQuery(s); while(resultSet.next()){ int id=resultSet.getInt(1); out.println("
"+resultSet.getString(2)+"	"+resultSet.getString(3)+"	"+resultSet.getString(4)+"	删除修改	"+resultSet.getString(5)+"

姓名	年龄	性别	职位	操作 <% String s="select * from card where logicDelete=0 and name like '%"+key+"%'"; ResultSet rs=db.executeQuery(s); while(rs.next()){ int id=rs.getInt(1); out.println("
"+rs.getString(2)+"	"+rs.getString(3)+"	"+rs.getString(4)+"	"+rs.getString(5)+"	删除修改

【web应用系统实践】第四章作业

欢迎你，" + cookies[i].getValue() + "！

Java相关栏目本月热门文章