JAVA图书管理系统登录、注册、添加图书、删除图书信息连接MySQL创建GUI代码
时间: 2023-08-03 11:08:49 浏览: 38
以下是一个简单的Java图书管理系统的登录、注册、添加图书、删除图书信息的MySQL代码示例。注意,这只是一个示例代码,可能需要进行一些适应性修改以适合你的具体需求。
登录:
```java
public static boolean login(String username, String password) {
try {
Connection conn = getConnection();
PreparedStatement ps = conn.prepareStatement(
"SELECT * FROM users WHERE username=? AND password=?");
ps.setString(1, username);
ps.setString(2, password);
ResultSet rs = ps.executeQuery();
boolean result = rs.next();
rs.close();
ps.close();
conn.close();
return result;
} catch (SQLException e) {
e.printStackTrace();
return false;
}
}
```
注册:
```java
public static boolean register(String username, String password) {
try {
Connection conn = getConnection();
PreparedStatement ps = conn.prepareStatement(
"INSERT INTO users (username, password) VALUES (?, ?)");
ps.setString(1, username);
ps.setString(2, password);
int result = ps.executeUpdate();
ps.close();
conn.close();
return result > 0;
} catch (SQLException e) {
e.printStackTrace();
return false;
}
}
```
添加图书:
```java
public static boolean addBook(String title, String author, String isbn, int year) {
try {
Connection conn = getConnection();
PreparedStatement ps = conn.prepareStatement(
"INSERT INTO books (title, author, isbn, year) VALUES (?, ?, ?, ?)");
ps.setString(1, title);
ps.setString(2, author);
ps.setString(3, isbn);
ps.setInt(4, year);
int result = ps.executeUpdate();
ps.close();
conn.close();
return result > 0;
} catch (SQLException e) {
e.printStackTrace();
return false;
}
}
```
删除图书:
```java
public static boolean deleteBook(int id) {
try {
Connection conn = getConnection();
PreparedStatement ps = conn.prepareStatement(
"DELETE FROM books WHERE id=?");
ps.setInt(1, id);
int result = ps.executeUpdate();
ps.close();
conn.close();
return result > 0;
} catch (SQLException e) {
e.printStackTrace();
return false;
}
}
```
希望这些代码对你有所帮助!