本次实训创建项目,步骤一:创建学生信息管理系统。
步骤二:创建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代码,运行程序成功。