java图书馆管理系统mysql代码

很抱歉，我无法提供完整的图书馆管理系统的MySQL代码。但是，我可以给您一些参考：

1. 创建数据库和表

CREATE DATABASE library;

USE library;

CREATE TABLE books (
  book_id INT(11) NOT NULL AUTO_INCREMENT,
  title VARCHAR(255) NOT NULL,
  author VARCHAR(255) NOT NULL,
  category VARCHAR(255) NOT NULL,
  publisher VARCHAR(255) NOT NULL,
  publish_date DATE NOT NULL,
  price DECIMAL(10,2) NOT NULL,
  PRIMARY KEY (book_id)
);

CREATE TABLE members (
  member_id INT(11) NOT NULL AUTO_INCREMENT,
  name VARCHAR(255) NOT NULL,
  address VARCHAR(255) NOT NULL,
  phone VARCHAR(20) NOT NULL,
  PRIMARY KEY (member_id)
);

CREATE TABLE loans (
  loan_id INT(11) NOT NULL AUTO_INCREMENT,
  book_id INT(11) NOT NULL,
  member_id INT(11) NOT NULL,
  loan_date DATE NOT NULL,
  due_date DATE NOT NULL,
  return_date DATE,
  PRIMARY KEY (loan_id),
  FOREIGN KEY (book_id) REFERENCES books (book_id),
  FOREIGN KEY (member_id) REFERENCES members (member_id)
);

2. 插入数据

INSERT INTO books (title, author, category, publisher, publish_date, price) VALUES
('Head First Java', 'Kathy Sierra, Bert Bates', 'Programming', 'O''Reilly Media', '2003-02-09', 39.99),
('Thinking in Java', 'Bruce Eckel', 'Programming', 'Prentice Hall', '2006-02-20', 49.99),
('Java Concurrency in Practice', 'Brian Goetz, Tim Peierls, Joshua Bloch, Joseph Bowbeer, David Holmes, Doug Lea', 'Programming', 'Addison-Wesley Professional', '2006-05-19', 44.99),
('Effective Java', 'Joshua Bloch', 'Programming', 'Addison-Wesley Professional', '2008-05-08', 37.99);

INSERT INTO members (name, address, phone) VALUES
('John Smith', '123 Main St, Anytown, USA', '555-1234'),
('Jane Doe', '456 Oak St, Anytown, USA', '555-5678');

INSERT INTO loans (book_id, member_id, loan_date, due_date) VALUES
(1, 1, '2021-01-01', '2021-02-01'),
(2, 1, '2021-01-15', '2021-02-15'),
(3, 2, '2021-02-01', '2021-03-01');

3. 查询数据

-- 获取所有图书
SELECT * FROM books;

-- 获取所有借阅记录及其对应的图书和会员信息
SELECT loans.loan_id, loans.loan_date, loans.due_date, loans.return_date, books.title AS book_title, members.name AS member_name
FROM loans
INNER JOIN books ON loans.book_id = books.book_id
INNER JOIN members ON loans.member_id = members.member_id;

-- 获取某个会员的借阅记录及其对应的图书信息
SELECT loans.loan_id, loans.loan_date, loans.due_date, loans.return_date, books.title AS book_title
FROM loans
INNER JOIN books ON loans.book_id = books.book_id
WHERE loans.member_id = 1;

这些只是示例代码，具体的图书馆管理系统的代码会更复杂和详细。如有需要，您可以自行搜索相关资源或咨询专业人士。