質問編集履歴

2

追記修正

2021/01/26 02:42

投稿

K_3578
K_3578

スコア1282

test CHANGED
File without changes
test CHANGED
@@ -588,7 +588,7 @@
588
588
 
589
589
  }
590
590
 
591
- (以降、カラム毎に上記と同じ処理を繰り返すため省略)
591
+ <!--(以降、カラム毎に上記と同じ処理を繰り返すため省略)-->
592
592
 
593
593
  }
594
594
 

1

追記

2021/01/26 02:42

投稿

K_3578
K_3578

スコア1282

test CHANGED
File without changes
test CHANGED
@@ -322,10 +322,278 @@
322
322
 
323
323
  }
324
324
 
325
-
326
-
327
325
  ```
328
326
 
327
+
328
+
329
+ models.Trucks.java
330
+
331
+ ```Java
332
+
333
+ package models;
334
+
335
+ import java.sql.Date;
336
+
337
+ import java.sql.Time;
338
+
339
+
340
+
341
+ import javax.persistence.Column;
342
+
343
+ import javax.persistence.Entity;
344
+
345
+ import javax.persistence.GeneratedValue;
346
+
347
+ import javax.persistence.GenerationType;
348
+
349
+ import javax.persistence.Id;
350
+
351
+ import javax.persistence.NamedQueries;
352
+
353
+ import javax.persistence.NamedQuery;
354
+
355
+ import javax.persistence.Table;
356
+
357
+
358
+
359
+ @Table(name = "trucks")
360
+
361
+ @NamedQueries({
362
+
363
+ @NamedQuery(
364
+
365
+ name = "getAllTrucks",
366
+
367
+ query = "SELECT t FROM Trucks AS t"
368
+
369
+ ),
370
+
371
+ @NamedQuery(
372
+
373
+ name = "getTrucksCount",
374
+
375
+ query = "SELECT COUNT(t) FROM Trucks AS t"
376
+
377
+ ),
378
+
379
+ })
380
+
381
+ @Entity
382
+
383
+ public class Trucks{
384
+
385
+ @Id
386
+
387
+ @Column(name = "id")
388
+
389
+ @GeneratedValue(strategy = GenerationType.IDENTITY)
390
+
391
+ private Integer id;
392
+
393
+
394
+
395
+ @Column(name = "task_date", nullable = true)
396
+
397
+ private Date task_date;
398
+
399
+
400
+
401
+ @Column(name = "task_time", nullable = true)
402
+
403
+ private Time task_time;
404
+
405
+
406
+
407
+ @Column(name = "office_name", nullable = true)
408
+
409
+ private String office_name;
410
+
411
+
412
+
413
+ @Column(name = "truck_code", nullable = true)
414
+
415
+ private String truck_code;
416
+
417
+
418
+
419
+ @Column(name = "stack_area", nullable = true)
420
+
421
+ private String stack_area;
422
+
423
+
424
+
425
+ @Column(name = "wholesale_area", nullable = true)
426
+
427
+ private String wholesale_area;
428
+
429
+
430
+
431
+ @Column(name = "truck_type", nullable = true)
432
+
433
+ private String truck_type;
434
+
435
+
436
+
437
+ @Column(name = "wa_time", nullable = true)
438
+
439
+ private String wa_time;
440
+
441
+
442
+
443
+
444
+
445
+ @Column(name = "sa_time", nullable = true)
446
+
447
+ private String sa_time;
448
+
449
+
450
+
451
+ @Column(name = "e_stack_area", nullable = true)
452
+
453
+ private String e_stack_area;
454
+
455
+
456
+
457
+ @Column(name = "m_wholesale_area", nullable = true)
458
+
459
+ private String m_wholesale_area;
460
+
461
+
462
+
463
+ @Column(name = "mw_time", nullable = true)
464
+
465
+ private String mw_time;
466
+
467
+
468
+
469
+
470
+
471
+ @Column(name = "es_time", nullable = true)
472
+
473
+ private String es_time;
474
+
475
+
476
+
477
+ @Column(name = "mw_text", nullable = true)
478
+
479
+ private String mw_text;
480
+
481
+
482
+
483
+ @Column(name = "mw_select", nullable = true)
484
+
485
+ private String mw_select;
486
+
487
+
488
+
489
+ @Column(name = "sa_text", nullable = true)
490
+
491
+ private String sa_text;
492
+
493
+
494
+
495
+ @Column(name = "sa_select", nullable = true)
496
+
497
+ private String sa_select;
498
+
499
+
500
+
501
+ @Column(name = "wa_text", nullable = true)
502
+
503
+ private String wa_text;
504
+
505
+
506
+
507
+ @Column(name = "wa_select", nullable = true)
508
+
509
+ private String wa_select;
510
+
511
+
512
+
513
+ @Column(name = "es_text", nullable = true)
514
+
515
+ private String es_text;
516
+
517
+
518
+
519
+ @Column(name = "es_select", nullable = true)
520
+
521
+ private String es_select;
522
+
523
+
524
+
525
+ @Column(name = "wa_time2", nullable = true)
526
+
527
+ private String wa_time2;
528
+
529
+
530
+
531
+ @Column(name = "sa_time2", nullable = true)
532
+
533
+ private String sa_time2;
534
+
535
+
536
+
537
+ @Column(name = "stack_area2", nullable = true)
538
+
539
+ private String stack_area2;
540
+
541
+
542
+
543
+ @Column(name = "wholesale_area2", nullable = true)
544
+
545
+ private String wholesale_area2;
546
+
547
+
548
+
549
+ @Column(name = "sa_text2", nullable = true)
550
+
551
+ private String sa_text2;
552
+
553
+
554
+
555
+ @Column(name = "sa_select2", nullable = true)
556
+
557
+ private String sa_select2;
558
+
559
+
560
+
561
+ @Column(name = "wa_text2", nullable = true)
562
+
563
+ private String wa_text2;
564
+
565
+
566
+
567
+ @Column(name = "wa_select2", nullable = true)
568
+
569
+ private String wa_select2;
570
+
571
+
572
+
573
+
574
+
575
+
576
+
577
+ public Integer getId() {
578
+
579
+ return id;
580
+
581
+ }
582
+
583
+
584
+
585
+ public void setId(Integer id) {
586
+
587
+ this.id = id;
588
+
589
+ }
590
+
591
+ (以降、カラム毎に上記と同じ処理を繰り返すため省略)
592
+
593
+ }
594
+
595
+ ```
596
+
329
597
  ### 補足情報(FW/ツールのバージョンなど)
330
598
 
331
599