第二次实训

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

  • 3
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值