第二次实训

本次实训创建项目，步骤一：创建学生信息管理系统。 步骤二：创建help、images、lib。 步骤三：在help中导入帮助文档.chm， 在images中导入图片， 在lib中导入mysql-connector-java-5.1.47.jar 步骤四：创建学校实体类对应学校表、状态实体类对应状态表、学生实体类对应学生表、用户实体类对应用户表。

package net.tjm.student.bean;

import java.util.Date;

/**

功能：学校实体类

作者：唐家明

日期：2020年06月05日 */ 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.tjm.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.tjm.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.tjm.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 + ‘}’; } }

步骤五：创建dbutil包，创建ConnectionManger类。 package net.tjm.student.dbutil;

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 = “12345”; 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; }

/** * 关闭数据连接方法 * * @param conn */ public static void closeConnection(Connection conn) { // 判断数据库连接是否为空 if (conn != null) { try { // 判断数据库连接是否关闭 if (!conn.isClosed()) { // 关闭数据库连接 conn.close(); } } catch (SQLException e) { System.err.println("温馨提示：数据库连接关闭失败！"); } } } /** * 测试数据库连接是否成功 * * @param args */ public static void main(String[] args) { // 获取数据库连接 Connection conn = getConnection(); // 判断是否连接成功 if (conn != null) { JOptionPane.showMessageDialog(null, "恭喜，数据库连接成功！"); } else { JOptionPane.showMessageDialog(null, "遗憾，数据库连接失败！"); } // 关闭数据库连接 closeConnection(conn); }

}

最后从数据库配置文件里读取属性值，修改ConnewrctionManager代码，运行程序成功。