java图书管理系统用mysql来实现增删改查怎么做
时间: 2023-05-02 16:00:56 浏览: 73
使用MySQL来实现Java图书管理系统的增删改查操作。具体可以通过Java中的JDBC接口连接MySQL数据库,然后使用SQL语句来实现增删改查的操作。例如,通过INSERT语句插入图书信息到MySQL数据库中,通过DELETE语句从数据库中删除图书信息,通过UPDATE语句更新图书信息,通过SELECT语句查询图书信息。通过以上操作实现Java图书管理系统的数据管理功能。
相关问题
java学生管理系统连接mysql实现增删改查
好的,以下是一个简单的Java学生管理系统示例,涉及到了连接MySQL数据库的增删改查操作。注意,以下示例代码仅供参考,需要根据具体情况进行修改和完善。
首先,需要创建一个学生类,表示一个学生的基本信息,例如学号、姓名、年龄、性别等。
```
public class Student {
private int id;
private String name;
private int age;
private String gender;
// 构造方法和getter/setter方法省略
}
```
然后,需要创建一个数据库连接工具类,用于连接MySQL数据库,并提供一些常用的增删改查操作方法。以下示例代码使用了JDBC连接MySQL数据库。
```
import java.sql.*;
public class DBUtil {
// MySQL数据库连接信息
private static final String URL = "jdbc:mysql://localhost:3306/students";
private static final String USERNAME = "root";
private static final String PASSWORD = "123456";
// 加载MySQL JDBC驱动
static {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
// 获取数据库连接
public static Connection getConnection() throws SQLException {
return DriverManager.getConnection(URL, USERNAME, PASSWORD);
}
// 关闭数据库连接
public static void close(Connection conn, Statement stmt, ResultSet rs) {
try {
if (rs != null) rs.close();
if (stmt != null) stmt.close();
if (conn != null) conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
// 增加学生信息
public static void addStudent(Student student) {
Connection conn = null;
PreparedStatement stmt = null;
try {
conn = getConnection();
String sql = "INSERT INTO students (name, age, gender) VALUES (?, ?, ?)";
stmt = conn.prepareStatement(sql);
stmt.setString(1, student.getName());
stmt.setInt(2, student.getAge());
stmt.setString(3, student.getGender());
stmt.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
close(conn, stmt, null);
}
}
// 删除学生信息
public static void deleteStudent(int id) {
Connection conn = null;
PreparedStatement stmt = null;
try {
conn = getConnection();
String sql = "DELETE FROM students WHERE id=?";
stmt = conn.prepareStatement(sql);
stmt.setInt(1, id);
stmt.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
close(conn, stmt, null);
}
}
// 更新学生信息
public static void updateStudent(Student student) {
Connection conn = null;
PreparedStatement stmt = null;
try {
conn = getConnection();
String sql = "UPDATE students SET name=?, age=?, gender=? WHERE id=?";
stmt = conn.prepareStatement(sql);
stmt.setString(1, student.getName());
stmt.setInt(2, student.getAge());
stmt.setString(3, student.getGender());
stmt.setInt(4, student.getId());
stmt.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
close(conn, stmt, null);
}
}
// 查询学生信息
public static Student getStudent(int id) {
Connection conn = null;
PreparedStatement stmt = null;
ResultSet rs = null;
Student student = null;
try {
conn = getConnection();
String sql = "SELECT * FROM students WHERE id=?";
stmt = conn.prepareStatement(sql);
stmt.setInt(1, id);
rs = stmt.executeQuery();
if (rs.next()) {
student = new Student();
student.setId(rs.getInt("id"));
student.setName(rs.getString("name"));
student.setAge(rs.getInt("age"));
student.setGender(rs.getString("gender"));
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
close(conn, stmt, rs);
}
return student;
}
}
```
以上代码中,需要替换MySQL数据库的连接信息(URL、用户名和密码),以及对应的学生表格名和字段名。代码中提供了四个常用的增删改查操作方法,分别是:
- 增加学生信息:使用PreparedStatement对象执行INSERT语句。
- 删除学生信息:使用PreparedStatement对象执行DELETE语句。
- 更新学生信息:使用PreparedStatement对象执行UPDATE语句。
- 查询学生信息:使用PreparedStatement对象执行SELECT语句,并将查询结果封装成一个学生对象返回。
最后,可以编写一个简单的测试程序,演示以上增删改查操作的使用。
```
public class Test {
public static void main(String[] args) {
// 增加学生信息
Student student = new Student();
student.setName("张三");
student.setAge(20);
student.setGender("男");
DBUtil.addStudent(student);
// 查询学生信息
Student student1 = DBUtil.getStudent(1);
System.out.println(student1.getName());
// 更新学生信息
student1.setName("李四");
DBUtil.updateStudent(student1);
// 删除学生信息
DBUtil.deleteStudent(1);
}
}
```
以上测试程序中,首先增加了一个学生信息,然后查询出该学生信息并输出,接着修改该学生姓名并更新,最后删除该学生信息。
图书管理系统java连接数据库实现增删改查
以下是一个简单的图书管理系统的Java代码示例,用于连接数据库并实现增删改查功能:
1. 连接数据库:
```java
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBConnection {
private static final String URL = "jdbc:mysql://localhost:3306/library";
private static final String USERNAME = "root";
private static final String PASSWORD = "password";
public static Connection getConn() {
Connection conn = null;
try {
conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
public static void close(Connection conn) {
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
```
2. 添加图书:
```java
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class BookDao {
public int addBook(Book book) {
int flag = 0;
Connection conn = null;
PreparedStatement pst = null;
try {
conn = DBConnection.getConn();
String sql = "INSERT INTO books (title, author, price) VALUES (?, ?, ?)";
pst = conn.prepareStatement(sql);
pst.setString(1, book.getTitle());
pst.setString(2, book.getAuthor());
pst.setDouble(3, book.getPrice());
flag = pst.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBConnection.close(conn);
}
return flag;
}
}
```
3. 删除图书:
```java
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class BookDao {
public int deleteBook(int id) {
int flag = 0;
Connection conn = null;
PreparedStatement pst = null;
try {
conn = DBConnection.getConn();
String sql = "DELETE FROM books WHERE id = ?";
pst = conn.prepareStatement(sql);
pst.setInt(1, id);
flag = pst.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBConnection.close(conn);
}
return flag;
}
}
```
4. 修改图书信息:
```java
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class BookDao {
public int updateBook(Book book) {
int flag = 0;
Connection conn = null;
PreparedStatement pst = null;
try {
conn = DBConnection.getConn();
String sql = "UPDATE books SET title = ?, author = ?, price = ? WHERE id = ?";
pst = conn.prepareStatement(sql);
pst.setString(1, book.getTitle());
pst.setString(2, book.getAuthor());
pst.setDouble(3, book.getPrice());
pst.setInt(4, book.getId());
flag = pst.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBConnection.close(conn);
}
return flag;
}
}
```
5. 查询图书:
```java
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
public class BookDao {
public List<Book> getAllBooks() {
List<Book> bookList = new ArrayList<>();
Connection conn = null;
PreparedStatement pst = null;
ResultSet rs = null;
try {
conn = DBConnection.getConn();
String sql = "SELECT * FROM books";
pst = conn.prepareStatement(sql);
rs = pst.executeQuery();
while (rs.next()) {
int id = rs.getInt("id");
String title = rs.getString("title");
String author = rs.getString("author");
double price = rs.getDouble("price");
Book book = new Book(id, title, author, price);
bookList.add(book);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBConnection.close(conn);
}
return bookList;
}
}
```
相关推荐
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)