一、创建项目 创建java项目：学生管理系统(MYSQL版)V1.0 二、在项目里面创建我们在写项目期间需要的文件所存放文件的文件夹(help,lib,images) 三、在lib里添加MySQL数据库驱动程序包 作为库添加到项目里 四、在images里添加图片 五、在help里添加帮助文档 六、创建实体类 创建学校实体类对应学校表 package net.zty.student;
import java.util.Date;
public class College { private int id; private String name; private String president; private Date startTime; private String telephone; private String email; private String address; private String profile;
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 String getPresident() { return president; } public void setPresident(String president) { this.president = president; } public Date getStartTime() { return startTime; } public void setStartTime(Date startTime) { this.startTime = startTime; } public String getTelephone() { return telephone; } public void setTelephone(String telephone) { this.telephone = telephone; } public String getEmail() { return email; } public void setEmail(String email) { this.email = email; } public String getAddress() { return address; } public void setAddress(String address) { this.address = address; } public String getProfile() { return profile; } public void setProfile(String profile) { this.profile = profile; } @Override public String toString() { return "College{" + "id=" + id + ", name='" + name + '\'' + ", president='" + president + '\'' + ", startTime=" + startTime + ", telephone='" + telephone + '\'' + ", email='" + email + '\'' + ", address='" + address + '\'' + ", profile='" + profile + '\'' + '}'; }} 创建状态实体类对应状态表 package net.zty.student.bean;
public class Status { private int id; private String college; private String version; private String author; private String telephone; private String address; private String email;
public int getId() { return id; } public void setId(int id) { this.id = id; } public String getCollege() { return college; } public void setCollege(String college) { this.college = college; } public String getVersion() { return version; } public void setVersion(String version) { this.version = version; } public String getAuthor() { return author; } public void setAuthor(String author) { this.author = author; } public String getTelephone() { return telephone; } public void setTelephone(String telephone) { this.telephone = telephone; } public String getAddress() { return address; } public void setAddress(String address) { this.address = address; } public String getEmail() { return email; } public void setEmail(String email) { this.email = email; } @Override public String toString() { return "Status{" + "id=" + id + ", college='" + college + '\'' + ", version='" + version + '\'' + ", author='" + author + '\'' + ", telephone='" + telephone + '\'' + ", address='" + address + '\'' + ", email='" + email + '\'' + '}'; }} 创建学生实体类对应学生表 package net.zty.student.bean;
public class Student { private String id; private String name; private String sex; private int age; private String department; private String clazz; private String telephone;
public String getId() { return id; } public void setId(String id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getSex() { return sex; } public void setSex(String sex) { this.sex = sex; } public int getAge() { return age; } public void setAge(int age) { this.age = age; } public String getDepartment() { return department; } public void setDepartment(String department) { this.department = department; } public String getClazz() { return clazz; } public void setClazz(String clazz) { this.clazz = clazz; } public String getTelephone() { return telephone; } public void setTelephone(String telephone) { this.telephone = telephone; } @Override public String toString() { return "Student{" + "id='" + id + '\'' + ", name='" + name + '\'' + ", sex='" + sex + '\'' + ", age=" + age + ", department='" + department + '\'' + ", clazz='" + clazz + '\'' + ", telephone='" + telephone + '\'' + '}'; }} 创建用户实体类对应用户表 package net.zty.student.bean;
import java.util.Date;
public class User { private int id; private String username; private String password; private String telephone; private Date registerTime;
public int getId() { return id; } public void setId(int id) { this.id = id; } public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public String getTelephone() { return telephone; } public void setTelephone(String telephone) { this.telephone = telephone; } public Date getRegisterTime() { return registerTime; } public void setRegisterTime(Date registerTime) { this.registerTime = registerTime; } @Override public String toString() { return "User{" + "id=" + id + ", username='" + username + '\'' + ", password='" + password + '\'' + ", telephone='" + telephone + '\'' + ", registerTime=" + registerTime + '}'; }} 七、创建数据库连接管理类 package net.zty.student.dbutile;
import javax.swing.*; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException;
public class ConnectionManager { private static final String DRIVER = “com.mysql.jdbc.Driver”;
private static final String URL = "jdbc:mysql://localhost:3306/student"; private static final String USERNAME = "root"; private static final String PASSWORD = "010114"; private ConnectionManager() { } public static Connection getConnection() { // 定义数据库连接 Connection conn = null; try { // 安装数据库驱动程序 Class.forName(DRIVER); // 获取数据库连接 conn = DriverManager.getConnection(URL, USERNAME, PASSWORD); } catch (ClassNotFoundException e) { System.err.println("错误提示：数据库驱动程序未找到！"); } catch (SQLException e) { System.err.println("温馨提示：数据库连接失败！"); } // 返回数据库连接 return conn; } public static void closeConnection(Connection conn) { // 判断数据库连接是否为空 if (conn != null) { try { if (!conn.isClosed()) { conn.close(); } } catch (SQLException e) { System.err.println("温馨提示：数据库连接关闭失败！"); } } } public static void main(String[] args) { Connection conn = getConnection(); if (conn != null) { JOptionPane.showMessageDialog(null, "恭喜，数据库连接成功！"); } else { JOptionPane.showMessageDialog(null, "遗憾，数据库连接失败！"); } closeConnection(conn); }} 运行程序，查看结果 创建用户实体类 package net.zty.student.bean;
import java.sql.Timestamp; import java.util.Date;
public class User { private int id; private String username; private String password; private String telephone; private Date registerTime;
public int getId() { return id; } public void setId(int id) { this.id = id; } public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public String getTelephone() { return telephone; } public void setTelephone(String telephone) { this.telephone = telephone; } public Timestamp getRegisterTime() { return (Timestamp) registerTime; } public void setRegisterTime(Date registerTime) { this.registerTime = registerTime; } @Override public String toString() { return "User{" + "id=" + id + ", username='" + username + '\'' + ", password='" + password + '\'' + ", telephone='" + telephone + '\'' + ", registerTime=" + registerTime + '}'; }} 创建显示全部用户记录类 package net.zty.student.test;
import net.zty.student.dbutile.ConnectionManager; import net.zty.student.bean.User; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement;
public class DisplayAllUsers { public static void main(String[] args) { Connection conn = ConnectionManager.getConnection(); try { String strSQL = “select * from t_user”; Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(strSQL); while (rs.next()) { User user = new User(); user.setId(rs.getInt(“id”)); user.setUsername(rs.getString(“username”)); user.setPassword(rs.getString(“password”)); user.setTelephone(rs.getString(“telephone”)); user.setRegisterTime(rs.getTimestamp(“register_time”)); System.out.println(user); } } catch (SQLException e) { e.printStackTrace(); } finally { ConnectionManager.closeConnection(conn); } } }
按编号查找用户记录 package net.zty.student.test;
import net.zty.student.dbutile.ConnectionManager;
import java.sql.*; import java.util.Scanner;
public class FindUserByld { public static void main(String[] args) { int id; Scanner sc = new Scanner(System.in);
System.out.print("输入待查用户编号："); id = sc.nextInt(); Connection conn = null; try{ conn = ConnectionManager.getConnection(); String strSQL = "select * from t_user where id = ?"; PreparedStatement pstmt = conn.prepareStatement(strSQL); pstmt.setInt(1,id); ResultSet rs = pstmt.executeQuery(); if (rs.next()) { System.out.println("" + rs.getInt("id")); System.out.println("" + rs.getString("username")); System.out.println("" + rs.getString("password")); System.out.println("" + rs.getString("telephone")); System.out.println("" + rs.getTimestamp("register_time")); }else { System.out.println("查询结果：编号为【" + id + "】的用户不存在！"); } }catch (SQLException throwables) { throwables.printStackTrace(); }finally{ ConnectionManager.closeConnection(conn); } }} 创建用户登录类 package net.zty.student.test;
import net.zty.student.dbutile.ConnectionManager; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.Scanner;
public class Login { public static void main(String[] args) { // 声明部分 String username; String password; Scanner sc = new Scanner(System.in);
// 输入部分 System.out.print("输入用户名："); username = sc.next(); System.out.print("输入密码："); password = sc.next(); Connection conn = ConnectionManager.getConnection(); try { String strSQL = "select * from t_user where username = ? and password = ?"; PreparedStatement pstmt = conn.prepareStatement(strSQL); pstmt.setString(1, username); pstmt.setString(2, password); ResultSet rs = pstmt.executeQuery(); if (rs.next()) { System.out.println("恭喜，登录成功！"); } else { System.err.println("遗憾，登录失败！"); } } catch (SQLException e) { e.printStackTrace(); } finally { ConnectionManager.closeConnection(conn); } }} 创建添加用户记录类 package net.zty.student.test;
import net.zty.student.dbutile.ConnectionManager; import net.zty.student.bean.User; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.SQLException; import java.sql.Timestamp; import java.util.Date; import java.util.Scanner;
public class AddUser { public static void main(String[] args) { String username, password, telephone; Scanner sc = new Scanner(System.in); System.out.print(“用户名：”); username = sc.next(); System.out.print(“密码：”); password = sc.next(); System.out.print(“电话：”); telephone = sc.next(); User user = new User(); user.setUsername(username); user.setPassword(password); user.setTelephone(telephone); user.setRegisterTime(new Timestamp(new Date().getTime())); Connection conn = ConnectionManager.getConnection(); String strSQL = “insert into t_user (username, password, telephone, register_time) values (?, ?, ?, ?)”; try { PreparedStatement pstmt = conn.prepareStatement(strSQL); pstmt.setString(1, user.getUsername()); pstmt.setString(2, user.getPassword()); pstmt.setString(3, user.getTelephone()); pstmt.setTimestamp(4, user.getRegisterTime()); // 7. 执行SQL，返回添加的记录数 int count = pstmt.executeUpdate(); // 8. 判断是否添加成功 if (count > 0) { System.out.println(“恭喜，用户记录添加成功！”); } else { System.out.println(“遗憾，用户记录添加失败！”); } } catch (SQLException e) { e.printStackTrace(); } finally { ConnectionManager.closeConnection(conn); } } } 创建更新用户记录类 package net.zty.student.test;
import net.zty.student.dbutile.ConnectionManager; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.SQLException; import java.util.Scanner;
public class UpdateUser { public static void main(String[] args) { int id; String username, password; Scanner sc = new Scanner(System.in); System.out.print(“待编辑记录的id：”); id = sc.nextInt(); System.out.print(“新用户名：”); username = sc.next(); System.out.print(“新密码：”); password = sc.next(); Connection conn = ConnectionManager.getConnection(); String strSQL = “update t_user set username = ?, password = ? where id = ?”; try { PreparedStatement pstmt = conn.prepareStatement(strSQL); pstmt.setString(1, username); pstmt.setString(2, password); pstmt.setInt(3, id); int count = pstmt.executeUpdate(); if (count > 0) { System.out.println(“恭喜，用户记录更新成功！”); } else { System.out.println(“遗憾，用户记录更新失败！”); } } catch (SQLException e) { e.printStackTrace(); } finally { ConnectionManager.closeConnection(conn); } } } 创建删除用户记录类 package net.zty.student.test;
import net.zty.student.dbutile.ConnectionManager; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.SQLException; import java.util.Scanner;
public class DeleUserByld { public static void main(String[] args) { int id; Scanner sc = new Scanner(System.in); System.out.print(“待删记录的id：”); id = sc.nextInt(); Connection conn = ConnectionManager.getConnection(); String strSQL = “delete from t_user where id = ?”; try { PreparedStatement pstmt = conn.prepareStatement(strSQL); pstmt.setInt(1, id); int count = pstmt.executeUpdate(); if (count > 0) { System.out.println(“恭喜，用户记录删除成功！”); } else { System.out.println(“遗憾，用户记录删除失败！”); } } catch (SQLException e) { e.printStackTrace(); } finally { ConnectionManager.closeConnection(conn); } } }
