(1) 使用java实现一个简单的信息管理系统的代码(集合框架、I0、 JDBC)
时间: 2023-06-15 20:06:54 浏览: 43
这是一个简单的基于 Java 的信息管理系统,使用集合框架、IO 和 JDBC:
```
import java.io.*;
import java.sql.*;
import java.util.*;
public class InfoSystem {
private static Connection conn = null;
private static PreparedStatement pstmt = null;
private static ResultSet rs = null;
public static void main(String[] args) {
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/info";
String username = "root";
String password = "password";
conn = DriverManager.getConnection(url, username, password);
System.out.println("连接数据库成功!");
// 创建表
String createTable = "CREATE TABLE IF NOT EXISTS student (id INT(11) PRIMARY KEY AUTO_INCREMENT, name VARCHAR(20), age INT(11), gender VARCHAR(2), major VARCHAR(30))";
pstmt = conn.prepareStatement(createTable);
pstmt.executeUpdate();
System.out.println("创建表成功!");
Scanner input = new Scanner(System.in);
int choice;
do {
System.out.println("请选择您要进行的操作:");
System.out.println("1. 添加学生信息");
System.out.println("2. 修改学生信息");
System.out.println("3. 删除学生信息");
System.out.println("4. 查询学生信息");
System.out.println("5. 退出系统");
choice = input.nextInt();
switch (choice) {
case 1:
addStudent();
break;
case 2:
updateStudent();
break;
case 3:
deleteStudent();
break;
case 4:
queryStudent();
break;
case 5:
System.out.println("感谢使用本系统!");
break;
default:
System.out.println("输入有误,请重新输入!");
break;
}
} while (choice != 5);
// 关闭资源
if (rs != null) {
rs.close();
}
if (pstmt != null) {
pstmt.close();
}
if (conn != null) {
conn.close();
}
} catch (ClassNotFoundException e) {
System.out.println("找不到驱动程序类,加载驱动失败!");
e.printStackTrace();
} catch (SQLException e) {
System.out.println("数据库连接失败!");
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
}
// 添加学生信息
private static void addStudent() {
try {
Scanner input = new Scanner(System.in);
System.out.println("请输入学生姓名:");
String name = input.next();
System.out.println("请输入学生年龄:");
int age = input.nextInt();
System.out.println("请输入学生性别:");
String gender = input.next();
System.out.println("请输入学生专业:");
String major = input.next();
String insert = "INSERT INTO student (name, age, gender, major) VALUES (?, ?, ?, ?)";
pstmt = conn.prepareStatement(insert);
pstmt.setString(1, name);
pstmt.setInt(2, age);
pstmt.setString(3, gender);
pstmt.setString(4, major);
pstmt.executeUpdate();
System.out.println("添加学生信息成功!");
} catch (SQLException e) {
System.out.println("添加学生信息失败!");
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
}
// 修改学生信息
private static void updateStudent() {
try {
Scanner input = new Scanner(System.in);
System.out.println("请输入要修改学生的姓名:");
String name = input.next();
String query = "SELECT * FROM student WHERE name = ?";
pstmt = conn.prepareStatement(query);
pstmt.setString(1, name);
rs = pstmt.executeQuery();
if (rs.next()) {
System.out.println("请输入新的学生年龄:");
int age = input.nextInt();
System.out.println("请输入新的学生性别:");
String gender = input.next();
System.out.println("请输入新的学生专业:");
String major = input.next();
String update = "UPDATE student SET age = ?, gender = ?, major = ? WHERE name = ?";
pstmt = conn.prepareStatement(update);
pstmt.setInt(1, age);
pstmt.setString(2, gender);
pstmt.setString(3, major);
pstmt.setString(4, name);
pstmt.executeUpdate();
System.out.println("修改学生信息成功!");
} else {
System.out.println("查无此人!");
}
} catch (SQLException e) {
System.out.println("修改学生信息失败!");
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
}
// 删除学生信息
private static void deleteStudent() {
try {
Scanner input = new Scanner(System.in);
System.out.println("请输入要删除学生的姓名:");
String name = input.next();
String delete = "DELETE FROM student WHERE name = ?";
pstmt = conn.prepareStatement(delete);
pstmt.setString(1, name);
int count = pstmt.executeUpdate();
if (count > 0) {
System.out.println("删除学生信息成功!");
} else {
System.out.println("查无此人!");
}
} catch (SQLException e) {
System.out.println("删除学生信息失败!");
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
}
// 查询学生信息
private static void queryStudent() {
try {
Scanner input = new Scanner(System.in);
System.out.println("请输入要查询学生的姓名:");
String name = input.next();
String query = "SELECT * FROM student WHERE name = ?";
pstmt = conn.prepareStatement(query);
pstmt.setString(1, name);
rs = pstmt.executeQuery();
if (rs.next()) {
System.out.println("姓名:" + rs.getString("name"));
System.out.println("年龄:" + rs.getInt("age"));
System.out.println("性别:" + rs.getString("gender"));
System.out.println("专业:" + rs.getString("major"));
} else {
System.out.println("查无此人!");
}
} catch (SQLException e) {
System.out.println("查询学生信息失败!");
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
}
}
```
这个信息管理系统使用 MySQL 数据库,并包含以下功能:
1. 添加学生信息
2. 修改学生信息
3. 删除学生信息
4. 查询学生信息
5. 退出系统
使用时需要先创建名为 `info` 的数据库,然后在其中创建名为 `student` 的表。表结构如下:
```
CREATE TABLE IF NOT EXISTS student (
id INT(11) PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(20),
age INT(11),
gender VARCHAR(2),
major VARCHAR(30)
);
```
注意,这个程序只是一个简单的示例,实际的信息管理系统需要根据具体需求进行设计和开发。
相关推荐
![application/x-rar](https://img-home.csdnimg.cn/images/20210720083606.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)
![](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)