号外!号外!不用new 也能创建对象

//伴生类
//1.private修饰的构造函数,在类外部不能访问,所以不能在测试类中使用new
class Stu private (var name:String){

}
//伴生对象
object  Stu{
  //2.定义一个对象
  //然后private的构造函数,在半生对象内部可以使用
  private val instance = new Stu("小花")
  //3.提供一个可以访问这个对象的方法
  def getInstance:Stu = instance
}
object Test777 {
  def main(args: Array[String]): Unit = {

    //单列模式:只能创建一个对象
//    var s = new Stu("小花")
//    var s1 = new Stu("小花")
    var s = Stu.getInstance
    var s1 = Stu.getInstance
    println(s==s1)

    println(s.name)
  }
}
以下是使用 MySQL 数据库创建上述 4 个关系模式并输入模拟数据的示例步骤: 1. 创建职工表: ``` CREATE TABLE employees ( employee_number INT PRIMARY KEY, name VARCHAR(255), birth_date DATE, gender CHAR(1), phone_number VARCHAR(255), hire_date DATE, job_number INT, department_number INT, FOREIGN KEY (job_number) REFERENCES jobs(job_number), FOREIGN KEY (department_number) REFERENCES departments(department_number) ); ``` 2. 创建部门表: ``` CREATE TABLE departments ( department_number INT PRIMARY KEY, department_name VARCHAR(255), location VARCHAR(255), manager_number INT, FOREIGN KEY (manager_number) REFERENCES employees(employee_number) ); ``` 3. 创建岗位表: ``` CREATE TABLE jobs ( job_number INT PRIMARY KEY, job_name VARCHAR(255), job_description TEXT, job_allowance DECIMAL(10,2) ); ``` 4. 创建薪水表: ``` CREATE TABLE salaries ( salary_number INT PRIMARY KEY, employee_number INT, base_salary DECIMAL(10,2), job_allowance DECIMAL(10,2), date DATE, FOREIGN KEY (employee_number) REFERENCES employees(employee_number) ); ``` 5. 输入模拟数据: ``` INSERT INTO employees (employee_number, name, birth_date, gender, phone_number, hire_date, job_number, department_number) VALUES (1, 'John Doe', '1990-01-01', 'M', '123-456-7890', '2020-01-01', 1, 1), (2, 'Jane Doe', '1995-01-01', 'F', '098-765-4321', '2020-01-01', 2, 1), (3, 'Bob Smith', '1985-01-01', 'M', '111-111-1111', '2020-01-01', 3, 2); INSERT INTO departments (department_number, department_name, location, manager_number) VALUES (1, 'Marketing', 'New York', 1), (2, 'Sales', 'Chicago', 3); INSERT INTO jobs (job_number, job_name, job_description, job_allowance) VALUES (1, 'Manager', 'Manages a team
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值