Nest使用TypeORM操作mysql

这是官网连接

https://nestjs.bootcss.com/techniques/sql

安装所需要的依赖

npm install --save @nestjs/typeorm typeorm mysql2

安装过程完成后，我们可以将 TypeOrmModule 导入AppModule

app.module.ts

import { Module } from '@nestjs/common';
import { TypeOrmModule } from '@nestjs/typeorm';

@Module({
  imports: [
    TypeOrmModule.forRoot({
      type: 'mysql',
      host: 'localhost',
      port: 3306,
      username: 'root',
      password: 'root',
      database: 'test',
      entities: [],
      synchronize: true,
    }),
  ],
})
export class AppModule {}

新建user文件夹

在文件夹下添加

user.controller.ts
user.service.ts
user.module.ts
user.entity.ts

user.controller.ts

import { Controller, Get } from '@nestjs/common';
import {UsersService} from './user.service'

@Controller()
export class UserController {
  constructor(private readonly usersService: UsersService) {}

  @Get("hello")
  getHello(){
    return this.usersService.findAll()
  }
}

user.entity.ts

import { Entity, Column, PrimaryGeneratedColumn } from 'typeorm';

@Entity()
export class User {
  @PrimaryGeneratedColumn()
  id: number;

  @Column()
  firstName: string;

  @Column()
  lastName: string;

  @Column({ default: true })
  isActive: boolean;
}

user.service.ts

import { Injectable } from '@nestjs/common';
import { InjectRepository } from '@nestjs/typeorm';
import { Repository } from 'typeorm';
import { User } from './user.entity';

@Injectable()
export class UsersService {
  constructor(
    @InjectRepository(User)
    private usersRepository: Repository<User>
  ) {}

  findAll(): Promise<User[]> {
    return this.usersRepository.find();
  }

  findOne(id: string): Promise<User> {
    return this.usersRepository.findOne(id);
  }

  async remove(id: string): Promise<void> {
    await this.usersRepository.delete(id);
  }
}

user.module.ts

import { Module } from '@nestjs/common';
import { TypeOrmModule } from '@nestjs/typeorm';
import { UsersService } from './user.service';
import { UserController } from './user.controller';
import { User } from './user.entity';

@Module({
  imports: [TypeOrmModule.forFeature([User])],
  providers: [UsersService],
  controllers: [UserController],
})
export class UsersModule {}

最后的app.module.ts别忘记了这两个属性

import { Module } from '@nestjs/common';
import { AppController } from './app.controller';
import { AppService } from './app.service';
import { TypeOrmModule } from '@nestjs/typeorm';
import {User} from './user/user.entity'
import{UsersModule} from './user/user.module'
@Module({
  imports: [
    TypeOrmModule.forRoot({
      type: 'mysql',
      host: 'localhost',
      port: 3306,
      username: 'root',
      password: '123456',
      database: 'za',
      entities: [User],//加上表的实体类
      synchronize: true,
    }),
    UsersModule  //导出模块，不然会报错
  ],
  controllers: [AppController],
  providers: [AppService],
})
export class AppModule {}

npm run start启动项目最后在浏览器输入在
usercontroller.ts文件中写的hello路由，调用 Service 中的findAll()方法.
返回数据

最后在这里上传，这个项目的全部代码

链接：https://pan.baidu.com/s/1jXp5oKHBaP7LY7WWJdz6sA 
提取码：6666