在Eclipse中创建了Dynamic Web Project项目,项目名称为login1,请编写一个简单的学生信息管理系统需要连接MySQL数据库,请把哪个文件和创在哪和哪个文件所有代码发给我

首先，需要在Eclipse中安装MySQL的JDBC驱动程序，然后按照以下步骤进行操作：

1. 在Eclipse中创建一个Dynamic Web Project项目，命名为login1。

2. 在项目的WebContent目录下创建一个名为WEB-INF的文件夹，并在其中创建一个名为lib的文件夹。

3. 将MySQL的JDBC驱动程序（mysql-connector-java.jar）复制到lib文件夹中。

4. 在项目的src目录下创建一个名为com.login1的包。

5. 在com.login1包下创建一个名为DBUtils的Java类，用于连接MySQL数据库。

6. 在DBUtils类中编写以下代码：

package com.login1;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DBUtils {
    private static final String URL = "jdbc:mysql://localhost:3306/student";
    private static final String USER = "root";
    private static final String PASSWORD = "123456";

    public static Connection getConnection() {
        Connection conn = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection(URL, USER, PASSWORD);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return conn;
    }
}

7. 在com.login1包下创建一个名为Student的Java类，用于表示学生信息。

8. 在Student类中编写以下代码：

package com.login1;

public class Student {
    private int id;
    private String name;
    private int age;
    private String sex;
    private String department;

    public Student() {
    }

    public Student(int id, String name, int age, String sex, String department) {
        this.id = id;
        this.name = name;
        this.age = age;
        this.sex = sex;
        this.department = department;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

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

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getDepartment() {
        return department;
    }

    public void setDepartment(String department) {
        this.department = department;
    }
}

9. 在com.login1包下创建一个名为StudentDAO的Java类，用于操作学生信息。

10. 在StudentDAO类中编写以下代码：

package com.login1;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class StudentDAO {
    public void add(Student student) {
        Connection conn = null;
        PreparedStatement pstmt = null;
        try {
            conn = DBUtils.getConnection();
            String sql = "insert into student(id, name, age, sex, department) values (?, ?, ?, ?, ?)";
            pstmt = conn.prepareStatement(sql);
            pstmt.setInt(1, student.getId());
            pstmt.setString(2, student.getName());
            pstmt.setInt(3, student.getAge());
            pstmt.setString(4, student.getSex());
            pstmt.setString(5, student.getDepartment());
            pstmt.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DBUtils.close(conn, pstmt, null);
        }
    }

    public void update(Student student) {
        Connection conn = null;
        PreparedStatement pstmt = null;
        try {
            conn = DBUtils.getConnection();
            String sql = "update student set name=?, age=?, sex=?, department=? where id=?";
            pstmt = conn.prepareStatement(sql);
            pstmt.setString(1, student.getName());
            pstmt.setInt(2, student.getAge());
            pstmt.setString(3, student.getSex());
            pstmt.setString(4, student.getDepartment());
            pstmt.setInt(5, student.getId());
            pstmt.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DBUtils.close(conn, pstmt, null);
        }
    }

    public void delete(int id) {
        Connection conn = null;
        PreparedStatement pstmt = null;
        try {
            conn = DBUtils.getConnection();
            String sql = "delete from student where id=?";
            pstmt = conn.prepareStatement(sql);
            pstmt.setInt(1, id);
            pstmt.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DBUtils.close(conn, pstmt, null);
        }
    }

    public Student getById(int id) {
        Connection conn = null;
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        Student student = null;
        try {
            conn = DBUtils.getConnection();
            String sql = "select * from student where id=?";
            pstmt = conn.prepareStatement(sql);
            pstmt.setInt(1, id);
            rs = pstmt.executeQuery();
            if (rs.next()) {
                student = new Student();
                student.setId(rs.getInt("id"));
                student.setName(rs.getString("name"));
                student.setAge(rs.getInt("age"));
                student.setSex(rs.getString("sex"));
                student.setDepartment(rs.getString("department"));
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DBUtils.close(conn, pstmt, rs);
        }
        return student;
    }

    public List<Student> getAll() {
        Connection conn = null;
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        List<Student> students = new ArrayList<Student>();
        try {
            conn = DBUtils.getConnection();
            String sql = "select * from student";
            pstmt = conn.prepareStatement(sql);
            rs = pstmt.executeQuery();
            while (rs.next()) {
                Student student = new Student();
                student.setId(rs.getInt("id"));
                student.setName(rs.getString("name"));
                student.setAge(rs.getInt("age"));
                student.setSex(rs.getString("sex"));
                student.setDepartment(rs.getString("department"));
                students.add(student);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            DBUtils.close(conn, pstmt, rs);
        }
        return students;
    }
}

11. 在com.login1包下创建一个名为Test的Java类，用于测试学生信息管理系统。

12. 在Test类中编写以下代码：

package com.login1;

import java.util.List;

public class Test {
    public static void main(String[] args) {
        StudentDAO dao = new StudentDAO();

        // 添加学生信息
        Student student1 = new Student(1, "张三", 18, "男", "计算机科学与技术");
        dao.add(student1);
        Student student2 = new Student(2, "李四", 19, "女", "软件工程");
        dao.add(student2);

        // 获取所有学生信息
        List<Student> students = dao.getAll();
        for (Student student : students) {
            System.out.println(student.getId() + "\t" + student.getName() + "\t" + student.getAge() + "\t" + student.getSex() + "\t" + student.getDepartment());
        }

        // 修改学生信息
        student1.setDepartment("信息安全");
        dao.update(student1);

        // 获取指定学生信息
        Student student = dao.getById(1);
        System.out.println(student.getId() + "\t" + student.getName() + "\t" + student.getAge() + "\t" + student.getSex() + "\t" + student.getDepartment());

        // 删除学生信息
        dao.delete(2);
    }
}

以上就是一个简单的学生信息管理系统的示例代码。需要注意的是，这只是一个示例，实际应用中还需要根据需求进行修改和完善。