JAVA版学生信息管理系统

Java版学生信息管理系统（数据库存储数据） 包含但不限于 学院、专业、年级、班级、学生信息、课程、老师、成绩 的增删改查功能

package Java版学生信息管理系统;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

//添加学生
public class AddStud {

public void add(Student student) {
	Connection conn = DBConnection.getConnection();
	String sql = "insert into student values(?,?,?,?,?,?,?,?,?,?,?,?,?)";
	PreparedStatement ps;
	try {
		ps = conn.prepareStatement(sql);
		ps.setString(1, student.getXueyuan());
		ps.setString(2, student.getZhuanye());
		ps.setString(3, student.getGrade());
		ps.setString(4, student.getBanji());
		ps.setString(5, student.getName());
		ps.setString(6, student.getSex());
		ps.setString(7, student.getTel());
		ps.setString(8, student.getJiguan());
		ps.setString(9, student.getId());
		ps.setString(10, student.getMath());
		ps.setString(11, student.getEnglish());
		ps.setString(12, student.getC_language());
		ps.setString(13, student.getTeacher());
		ps.execute();
		System.out.println("成功添加一位学生");
		
		
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	} finally {
		DBConnection.closeConnection(conn);
	}
}

}

• 连接数据库
  */

package Java版学生信息管理系统;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DBConnection {

public static Connection getConnection() {
	
	Connection conn = null;
	String url = "jdbc:mysql://localhost:3306/db1?serverTimezone=UTC";
	String UserName = "root";
	String UserPassword = "root";
	
	try {
		Class.forName("com.mysql.cj.jdbc.Driver");
		conn = DriverManager.getConnection(url,UserName,UserPassword);
		System.out.println("数据库连接成功");
	} catch (ClassNotFoundException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
		return null;
	}catch (SQLException e) {
		e.printStackTrace();
		return null;
	}
	
	return conn;
}


public static void closeConnection(Connection conn) {
	if(conn != null) {
		try {
			conn.close();
			conn = null;	
		}catch(Exception e){
			e.printStackTrace();
		}
		
	}
}

public static void main(String[] args) {
	getConnection();
}

}

package Java版学生信息管理系统;
import java.sql.*;

public class DeleteStud {

public void Dele(String name) {
	Connection conn = DBConnection.getConnection();
	PreparedStatement ps;
	String sql = "DELETE FROM student WHERE name = ?";
	
	try {
		ps = conn.prepareStatement(sql);
		ps.setString(1, name);
		ps.execute();
		System.out.println("该学生信息成功删除");
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}finally {
		DBConnection.closeConnection(conn);
	}
}

}
package Java版学生信息管理系统;

import java.sql.*;

public class ShowStud {

public void Show(String name) {
	
	Student student = new Student();
	Connection conn = DBConnection.getConnection();
	String sql = "SELECT * FROM student where name = ?";
	PreparedStatement ps;
	ResultSet rs;
	
	try {
		ps = conn.prepareStatement(sql);
		ps.setString(1, name);
		rs = ps.exec