第二次实训

第二次实训

一、

1创建一个项目：学生信息管理体系（的么伍呷）V1.0

2在项目根目录创建help、images、lib三个文件夹

3、在lib里添加MySQL数据库驱动程序包

下载数据库驱动程序包
链接：https://pan.baidu.com/s/1xE-jJVMGiPQ5Qdxi7q-KZw 提取码：og6p
将驱动程序包拷贝到lib目录
在这里插入图片描述

4、在images里添加图片

下载图片素材
链接：https://pan.baidu.com/s/1V3afx3Lw_4sw3R2Gyy2mZg 提取码：4sjd

将图片素材拷贝到images目录

5、在help里添加帮助文档

下载帮助文档
链接：https://pan.baidu.com/s/11TG9x3dfxej-06eWbcsqGw 提取码：iv6z
将帮助文档拷贝到help目录

6、

在src里创建net.hw.student.bean包

**依次创建四个实体类：College、Status、Student与User，分别对应t_college表、t_status表、t_student表与t_user表。
实体类的属性对应于数据表的字段，主要两者的数据类型要匹配，网上可以搜索到MySQL数据类型与Java数据类型的匹配对应表。

1、创建学校实体类对应学校表

package net.dm.student.bean;

/**

• 功能：学校实体类

• 作者：的么伍呷

• 日期：的么伍呷
  */
  public class College {
  private int id ;//学校标识符
  private String name;//学校名称
  private String president;//校长
  private String 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 String getStartTime() {
  return startTime;
  }

  public void setStartTime(String 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 + ‘’’ +
  ‘}’;
  }

}

2、创建状态实体类对应状态表

package net.dm.student.bean;
/**

• 功能：学校实体类
• 作者：的么伍呷
• 日期：的么伍呷
  */

public class Status {
private int id ;//
private String collage;//
private String virsion;//
private String telephone;//
private String address;//
private String email;//

public int getId() {
    return id;
}

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

public String getCollage() {
    return collage;
}

public void setCollage(String collage) {
    this.collage = collage;
}

public String getVirsion() {
    return virsion;
}

public void setVirsion(String virsion) {
    this.virsion = virsion;
}

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;
}

@Override
public String toString() {
    return "Status{" +
            "id=" + id +
            ", collage='" + collage + '\'' +
            ", virsion='" + virsion + '\'' +
            ", telephone='" + telephone + '\'' +
            ", address='" + address + '\'' +
            ", email='" + email + '\'' +
            '}';
}

public void setEmail(String email) {
    this.email = email;

}

}

3创建学生实体类对应学生表

package net.dm.student.bean;
/**

• 功能：学校实体类
• 作者：的么伍呷
• 日期：的么伍呷
  */

public class Student {
private int id ;//
private String name;//
private String sex;//
private String age;//
private String department;//
private String clazz;//
private String telephone;//
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 getSex() {
    return sex;
}

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

public String getAge() {
    return age;
}

public void setAge(String 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;
}

@Override
public String toString() {
    return "Student{" +
            "id=" + id +
            ", name='" + name + '\'' +
            ", sex='" + sex + '\'' +
            ", age='" + age + '\'' +
            ", department='" + department + '\'' +
            ", clazz='" + clazz + '\'' +
            ", telephone='" + telephone + '\'' +
            '}';
}

public void setTelephone(String telephone) {
    this.telephone = telephone;

}

}

4、创建用户实体类对应用户表

package net.dm.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 +
            '}';
}

}
**

注意：导入的日期类是util包里的Date类，import java.util.Date; 不要导成sql包里的Date类。

**

7在src里创建net.dm.student.dbutil包

**在包里创建数据库连接管理类ConnectionManager

package net.dm.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/student1?useSSL=false”;
private static final String USER = “root”;
private static final String PASSWORD = “13795642521h”;

/**
 * 私有化构造方法,拒绝实例化
 */

private ConnectionManager() {
}

/**
 * 获取数据库静态方法
 */

public static Connection getConnection() {
    //声明变量
    Connection conn = null;
    //安装数据库驱动

    try {
        Class.forName((DRIVER));
    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    }
    //利用驱动程序管理器类获取数据库连接
    try {
        conn = DriverManager.getConnection(URL, USER, PASSWORD);
    } catch (SQLException throwables) {
        throwables.printStackTrace();
    }

    //返回数据库连接
    return conn;
}

/**
 * 关闭数据库静态方法
 *
 * @param conn
 */
private static void closeConnection(Connection conn) {
    //判断数据库连接方法是否为空
    if (conn != null) {
        try {
            if (!conn.isClosed()) {
                conn.close();
            }
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }

    }

}

public static void main(String[] args) {
    //获取数据库连接
    Connection conn = getConnection();
    //判断数据库是否连接成功
    if (conn != null) {
        //用户数据库连接成功
        JOptionPane.showMessageDialog(null, "恭喜数据库连接成功！");

    } else {
        //提示用户数据库连接失败
        JOptionPane.showMessageDialog(null, "很遗憾数据库没有连接连接石板！");

    }
    //关闭数据库连接
    closeConnection(conn);
    System.out.print("程序到此完毕");

}

}

说明：private static final String PASSWORD = “root”; 密码值改成你电脑上MySQL的密码。
运行程序，测试数据库连接是否成功