用java写一个利用数据库的疫苗管理系统
时间: 2024-06-08 11:11:49 浏览: 10
好的,以下是一个简单的疫苗管理系统的Java代码,使用MySQL数据库进行数据存储:
```
import java.sql.*;
import java.util.Scanner;
public class VaccineManagementSystem {
private Connection conn;
private Statement stmt;
private ResultSet rs;
private Scanner scanner = new Scanner(System.in);
public VaccineManagementSystem() {
try {
Class.forName("com.mysql.cj.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/vaccines?serverTimezone=UTC", "username", "password");
stmt = conn.createStatement();
} catch (Exception e) {
e.printStackTrace();
}
}
public void addVaccine() {
System.out.print("请输入疫苗名称:");
String name = scanner.next();
System.out.print("请输入疫苗生产日期(格式为yyyy-MM-dd):");
String date = scanner.next();
System.out.print("请输入疫苗有效期(天数):");
int validity = scanner.nextInt();
System.out.print("请输入疫苗数量:");
int quantity = scanner.nextInt();
try {
String sql = "INSERT INTO vaccines(name, production_date, validity, quantity) VALUES('" + name + "', '" + date + "', " + validity + ", " + quantity + ")";
stmt.executeUpdate(sql);
System.out.println("添加成功!");
} catch (Exception e) {
e.printStackTrace();
}
}
public void searchVaccine() {
System.out.print("请输入要查询的疫苗名称:");
String name = scanner.next();
try {
String sql = "SELECT * FROM vaccines WHERE name='" + name + "'";
rs = stmt.executeQuery(sql);
if (rs.next()) {
System.out.println("名称:" + rs.getString("name") + ",生产日期:" + rs.getString("production_date") + ",有效期:" + rs.getInt("validity") + "天,数量:" + rs.getInt("quantity"));
} else {
System.out.println("未找到该疫苗!");
}
} catch (Exception e) {
e.printStackTrace();
}
}
public void updateVaccine() {
System.out.print("请输入要修改的疫苗名称:");
String name = scanner.next();
try {
String sql = "SELECT * FROM vaccines WHERE name='" + name + "'";
rs = stmt.executeQuery(sql);
if (rs.next()) {
System.out.println("名称:" + rs.getString("name") + ",生产日期:" + rs.getString("production_date") + ",有效期:" + rs.getInt("validity") + "天,数量:" + rs.getInt("quantity"));
System.out.print("请输入新的生产日期(格式为yyyy-MM-dd):");
String date = scanner.next();
System.out.print("请输入新的有效期(天数):");
int validity = scanner.nextInt();
System.out.print("请输入新的数量:");
int quantity = scanner.nextInt();
sql = "UPDATE vaccines SET production_date='" + date + "', validity=" + validity + ", quantity=" + quantity + " WHERE name='" + name + "'";
stmt.executeUpdate(sql);
System.out.println("更新成功!");
} else {
System.out.println("未找到该疫苗!");
}
} catch (Exception e) {
e.printStackTrace();
}
}
public void deleteVaccine() {
System.out.print("请输入要删除的疫苗名称:");
String name = scanner.next();
try {
String sql = "SELECT * FROM vaccines WHERE name='" + name + "'";
rs = stmt.executeQuery(sql);
if (rs.next()) {
sql = "DELETE FROM vaccines WHERE name='" + name + "'";
stmt.executeUpdate(sql);
System.out.println("删除成功!");
} else {
System.out.println("未找到该疫苗!");
}
} catch (Exception e) {
e.printStackTrace();
}
}
public void displayVaccines() {
try {
String sql = "SELECT * FROM vaccines";
rs = stmt.executeQuery(sql);
while (rs.next()) {
System.out.println("名称:" + rs.getString("name") + ",生产日期:" + rs.getString("production_date") + ",有效期:" + rs.getInt("validity") + "天,数量:" + rs.getInt("quantity"));
}
} catch (Exception e) {
e.printStackTrace();
}
}
public void close() {
try {
if (rs != null) rs.close();
if (stmt != null) stmt.close();
if (conn != null) conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
VaccineManagementSystem system = new VaccineManagementSystem();
while (true) {
System.out.println("请选择操作:");
System.out.println("1. 添加疫苗");
System.out.println("2. 查询疫苗");
System.out.println("3. 修改疫苗");
System.out.println("4. 删除疫苗");
System.out.println("5. 显示所有疫苗");
System.out.println("0. 退出");
int choice = system.scanner.nextInt();
switch (choice) {
case 1:
system.addVaccine();
break;
case 2:
system.searchVaccine();
break;
case 3:
system.updateVaccine();
break;
case 4:
system.deleteVaccine();
break;
case 5:
system.displayVaccines();
break;
case 0:
system.close();
System.exit(0);
break;
default:
System.out.println("无效的选择!");
}
}
}
}
```
请注意,上述代码中的数据库连接信息需要根据实际情况进行修改。
相关推荐
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.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://img-home.csdnimg.cn/images/20210720083646.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)