mysql实现学生管理系统的连接（从数据库导入数据）

最新推荐文章于 2024-05-13 04:59:42 发布

fineCoderWithLove

最新推荐文章于 2024-05-13 04:59:42 发布

阅读量922

点赞数

文章标签：数据库 mysql java

本文链接：https://blog.csdn.net/giaogege666/article/details/127398004

版权

main

package cs.itcast.jdbc;


import cs.itcast.Student.student;

import java.util.ArrayList;
import java.util.List;
import java.util.Scanner;

import static cs.itcast.jdbc.mysqlutil.*;

public class mysql {
    public static void main(String[] args) {
        Scanner sc = new Scanner(System.in);
        List<student> list = new ArrayList<>();
        while (true) {
            System.out.println("1.获取本地数据库连接");
            System.out.println("2.添加学生进入数据库");
            System.out.println("3.从数据库中删除学生");
            System.out.println("4.查询数据库中的学生");
            System.out.println("5.展示数据库成员信息");
            int choice = sc.nextInt();
            switch (choice) {
                case 1:
                    getmysql();break;
                case 2:
                    addmysql();break;
                case 3:
                    delete();break;
                case 4:
                    select();break;
                case 5:
                    getmysql();break;

            }

        }
    }

}

mysqlutils

package cs.itcast.jdbc;

import cs.itcast.Student.student;
import javafx.scene.paint.Stop;

import java.sql.*;
import java.util.ArrayList;
import java.util.List;
import java.util.Scanner;

public class mysqlutil {
    public static void getmysql() {
        List<student> list = new ArrayList<>();
        Statement stmt = null;
        ResultSet rs = null;
        Connection conn = null;
        //使用list集合封装
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/zzt?serverTimezone=GMT&useSSL=false", "root", "root");
            String sql = "select *from stu";
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);
            student s = new student();
            while (rs.next()) {
                String name = rs.getString("name");
                String gender = rs.getString("gender");
                double weight = rs.getDouble("weight");
                double height = rs.getDouble("height");
                String hobby = rs.getString("hobby");
                s = new student();
                s.setName(name);
                s.setGender(gender);
                s.setWeight(weight);
                s.setHeight(height);
                s.setHobby(hobby);
                list.add(s);
            }


        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        } finally {
            if (rs != null) {
                try {
                    rs.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
                if (stmt != null) {
                    try {
                        rs.close();
                    } catch (SQLException e) {
                        e.printStackTrace();
                    }
                    if (conn != null) {
                        try {
                            rs.close();
                        } catch (SQLException e) {
                            e.printStackTrace();
                        }
                    }

                }

            }
        }
        //获取数据库连接
        System.out.println(list);
    }

    public static void addmysql() {
        Scanner sc = new Scanner(System.in);
        PreparedStatement pstmt = null;
        int count = 0;
        Connection conn = null;
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/zzt?serverTimezone=GMT&useSSL=false", "root", "root");
            String sql = "insert into stu values(?,?,?,?,?)";
            pstmt = conn.prepareStatement(sql);
            System.out.println("请输入姓名");
            String name = sc.next();
            pstmt.setString(1, name);
            System.out.println("请输入性别");
            String gender = sc.next();
            pstmt.setString(2, gender);
            System.out.println("请输入体重");
            double weight = sc.nextDouble();
            pstmt.setDouble(3, weight);
            System.out.println("请输入身高");
            double height = sc.nextDouble();
            pstmt.setDouble(4, height);
            System.out.println("请输入爱好");
            String hobby = sc.next();
            pstmt.setString(5, hobby);
            count = pstmt.executeUpdate();
            System.out.println(count);
            if (count > 0)
                System.out.println("添加成功");
            else
                System.out.println("添加失败");


        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        } finally {
            if (pstmt != null) {
                try {
                    pstmt.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
                if (conn != null) {
                    try {
                        conn.close();
                    } catch (SQLException e) {
                        e.printStackTrace();
                    }
                }

            }

        }
    }

    public static void delete() {
        Scanner sc = new Scanner(System.in);
        PreparedStatement pstmt = null;
        int count = 0;
        Connection conn = null;
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/zzt?serverTimezone=GMT&useSSL=false", "root", "root");
            String sql = "delete from stu where name = ?";
            pstmt = conn.prepareStatement(sql);
            System.out.println("请输入想要删除的学生姓名");
            String name = sc.next();
            pstmt.setString(1, name);
            count = pstmt.executeUpdate();
            if (count > 0)
                System.out.println("删除成功");
            else
                System.out.println("删除失败");

        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
    }

    public static void select() {
        Scanner sc = new Scanner(System.in);
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        int count = 0;
        Connection conn = null;
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/zzt?serverTimezone=GMT&useSSL=false", "root", "root");
            String sql = "select *from stu where name = ?";
            pstmt = conn.prepareStatement(sql);
            System.out.println("请输入想要查询的学生姓名");
            String name = sc.next();
            pstmt.setString(1, name);
            rs = pstmt.executeQuery();
            while (rs.next()) {

                String name01 = rs.getString("name");
                String gender = rs.getString("gender");
                double weight = rs.getDouble(3);
                double height = rs.getDouble(4);
                String hobby = rs.getString("hobby");
                System.out.println(name01 + "-------" + gender + "-------" + weight + "-------" + height + "-------" + hobby);
            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
    }
}

student

package cs.itcast.Student;

import java.util.Objects;

public class student {
    private String name;
    private String gender;
    private double weight;
    private double height;
    private String hobby;

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getGender() {
        return gender;
    }

    public void setGender(String gender) {
        this.gender = gender;
    }

    public double getWeight() {
        return weight;
    }

    public void setWeight(double weight) {
        this.weight = weight;
    }

    public double getHeight() {
        return height;
    }

    public void setHeight(double height) {
        this.height = height;
    }

    public String getHobby() {
        return hobby;
    }

    public void setHobby(String hobby) {
        this.hobby = hobby;
    }

    @Override
    public boolean equals(Object o) {
        if (this == o) return true;
        if (o == null || getClass() != o.getClass()) return false;
        student student = (student) o;
        return Double.compare(student.weight, weight) == 0 && Double.compare(student.height, height) == 0 && Objects.equals(name, student.name) && Objects.equals(gender, student.gender) && Objects.equals(hobby, student.hobby);
    }

    @Override
    public int hashCode() {
        return Objects.hash(name, gender, weight, height, hobby);
    }

    @Override
    public String toString() {
        return "student{" +
                "name='" + name + '\'' +
                ", gender='" + gender + '\'' +
                ", weight=" + weight +
                ", height=" + height +
                ", hobby='" + hobby + '\'' +
                '}'+'\n';
    }
}