Changeset 19716 for lang/java

Show
Ignore:
Timestamp:
09/22/08 12:01:02 (2 months ago)
Author:
int128
Message:

エンティティ名をSlideとStatusに変更した

Location:
lang/java/slideboard/trunk
Files:
6 modified
2 moved

Legend:

Unmodified
Added
Removed

  • lang/java/slideboard/trunk/sql/create.sql

    r17460 r19716  
    44        id INTEGER generated by default as identity, 
    55        name VARCHAR(255) NOT NULL, 
    6         department VARCHAR(255) NOT NULL, 
    76        mail VARCHAR(255) NOT NULL, 
    87        PRIMARY KEY(id) 
    98); 
    109 
    11 CREATE TABLE post ( 
     10CREATE TABLE slide ( 
    1211        id INTEGER generated by default as identity, 
    1312        title VARCHAR(255) NOT NULL, 
    … …  
    1817); 
    1918 
    20 INSERT INTO author VALUES(1, 'Taro', 'My Home Security', 'taro@example.com'); 
    21 INSERT INTO author VALUES(2, 'Jiro', 'Your Home Security', 'jiro@example.com'); 
    22 INSERT INTO author VALUES(3, 'Ikzo', 'My Home Security', 'ikzo@example.com'); 
     19CREATE TABLE target ( 
     20        id INTEGER generated by default as identity, 
     21        name VARCHAR(255) NOT NULL, 
     22        PRIMARY KEY(id) 
     23); 
    2324 
    24 INSERT INTO post VALUES(1, 'Post1', 'This is a test post.', 3); 
     25CREATE TABLE status ( 
     26        slide_id INTEGER NOT NULL, 
     27        panel_id INTEGER NOT NULL, 
     28        show BOOLEAN NOT NULL, 
     29        PRIMARY KEY(slide_id, panel_id), 
     30        FOREIGN KEY(slide_id) REFERENCES slide(id), 
     31        FOREIGN KEY(target_id) REFERENCES target(id) 
     32); 
     33 
     34INSERT INTO author VALUES(1, 'Taro', 'taro@example.com'); 
     35INSERT INTO author VALUES(2, 'Jiro', 'jiro@example.com'); 
     36 
     37INSERT INTO post VALUES(1, 'Post1', 'This is a test post.', 1); 
    2538INSERT INTO post VALUES(2, 'Post2', 'This is a test post.', 2); 
    2639INSERT INTO post VALUES(3, 'Post3', 'This is a test post.', 1); 
    2740 
     41INSERT INTO panel VALUES(1, '7F'); 
     42INSERT INTO panel VALUES(2, '8F'); 
     43 
    2844COMMIT; 

  • lang/java/slideboard/trunk/src/main/java/org/hidetake/slideboard/action/IndexAction.java

    r17461 r19716  
    55import javax.annotation.Resource; 
    66 
    7 import org.hidetake.slideboard.entity.Post; 
     7import org.hidetake.slideboard.entity.Slide; 
    88import org.hidetake.slideboard.service.PostService; 
    99import org.seasar.struts.annotation.Execute; 
    … …  
    1212{ 
    1313 
    14         public List<Post> postList; 
     14        public List<Slide> slideList; 
    1515         
    1616        @Resource 
    … …  
    2020        public String index() 
    2121        { 
    22                 postList = postService.findAllJoinAuthor(); 
     22                slideList = postService.findAllJoinAuthor(); 
    2323                return "index.jsp"; 
    2424        } 

  • lang/java/slideboard/trunk/src/main/java/org/hidetake/slideboard/entity/Author.java

    r17338 r19716  
    11package org.hidetake.slideboard.entity; 
    2  
    3 import java.util.List; 
    42 
    53import javax.persistence.Entity; 
    64import javax.persistence.GeneratedValue; 
    75import javax.persistence.Id; 
    8 import javax.persistence.OneToMany; 
    96 
    107@Entity 
    … …  
    2219        public String department; 
    2320 
    24         @OneToMany(mappedBy = "author") 
    25         public List<Post> postList; 
    26  
    2721} 

  • lang/java/slideboard/trunk/src/main/java/org/hidetake/slideboard/entity/Slide.java

    r17178 r19716  
    99import javax.persistence.OneToMany; 
    1010 
    11 /** 
    12  * 投稿記事クラス。 
    13  *  
    14  * @author hidetake 
    15  *  
    16  */ 
    1711@Entity 
    18 public class Post 
     12public class Slide 
    1913{ 
    2014 
    … …  
    2721        public String description; 
    2822 
    29         @OneToMany(mappedBy = "post") 
    30         public List<Show> showList; 
     23        @OneToMany(mappedBy = "slide") 
     24        public List<Status> statusList; 
    3125 
    3226        public int authorId; 

  • lang/java/slideboard/trunk/src/main/java/org/hidetake/slideboard/entity/Status.java

    r17178 r19716  
    22 
    33import javax.persistence.Entity; 
     4import javax.persistence.Id; 
    45import javax.persistence.ManyToOne; 
    56 
    67@Entity 
    7 public class Show 
     8public class Status 
    89{ 
    910 
    10         public int postId; 
     11        @Id 
     12        public int slideId; 
    1113         
    1214        @ManyToOne 
    13         public Post post; 
    14          
    15         public int targetId; 
     15        public Slide slide; 
     16 
     17        @Id 
     18        public int panelId; 
    1619         
    1720        @ManyToOne 
    18         public Target target; 
     21        public Target panel; 
    1922         
    2023} 

  • lang/java/slideboard/trunk/src/main/java/org/hidetake/slideboard/entity/Target.java

    r17160 r19716  
    1919 
    2020        @OneToMany(mappedBy = "target") 
    21         public List<Show> showList; 
     21        public List<Status> statusList; 
    2222 
    2323} 

  • lang/java/slideboard/trunk/src/main/java/org/hidetake/slideboard/service/PostService.java

    r17461 r19716  
    33import java.util.List; 
    44 
    5 import org.hidetake.slideboard.entity.Post; 
     5import org.hidetake.slideboard.entity.Slide; 
    66import org.seasar.extension.jdbc.service.S2AbstractService; 
    77 
    8 public class PostService extends S2AbstractService<Post> 
     8public class PostService extends S2AbstractService<Slide> 
    99{ 
    10         public List<Post> findAllJoinAuthor() 
     10        public List<Slide> findAllJoinAuthor() 
    1111        { 
    12                 return jdbcManager.from(Post.class).innerJoin("author").getResultList(); 
     12                return jdbcManager.from(Slide.class).innerJoin("author").getResultList(); 
    1313        } 
    1414} 

  • lang/java/slideboard/trunk/webapp/WEB-INF/view/index.jsp

    r17669 r19716  
    2323 
    2424<div id="postList"> 
    25 <c:forEach var="m" varStatus="s" items="${postList}"> 
     25<c:forEach var="m" varStatus="s" items="${slideList}"> 
    2626 
    2727<div class="post">