Advertisement
Guest User

Untitled

a guest
Jul 19th, 2016
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.03 KB | None | 0 0
  1. package com.serwis.model;
  2.  
  3.  
  4. import javax.persistence.*;
  5.  
  6. import java.util.Arrays;
  7. import java.util.Set;
  8.  
  9.  
  10. @Entity
  11. @Table(name="Users")
  12. public class Users {
  13.  
  14. @Id
  15. @GeneratedValue(strategy= GenerationType.AUTO)
  16. @Column(name="id")
  17. private int id;
  18.  
  19. @Column(name="login")
  20. private String login;
  21.  
  22. @Column(name="password")
  23. private String password;
  24.  
  25. @Column(name="email")
  26. private String email;
  27.  
  28. @Column(name="avatar")
  29. private byte[] avatar;
  30.  
  31. @OneToMany(mappedBy="users", cascade = CascadeType.ALL,fetch = FetchType.EAGER)
  32. private Set<Post> posts;
  33.  
  34. public Users(){}
  35.  
  36. public Users(int id, String login, String password, String email, byte[] avatar) {
  37. this.id = id;
  38. this.login = login;
  39. this.password = password;
  40. this.email = email;
  41. this.avatar = avatar;
  42. }
  43.  
  44.  
  45. public Users(byte[] avatar, String email, String password, String login) {
  46. this.avatar = avatar;
  47. this.email = email;
  48. this.password = password;
  49. this.login = login;
  50. }
  51.  
  52. @Override
  53. public String toString() {
  54. return "Users{" +
  55. "id=" + id +
  56. ", login='" + login + ''' +
  57. ", password='" + password + ''' +
  58. ", email='" + email + ''' +
  59. ", avatar=" +
  60. ", posts=" + posts.size()+
  61. '}';
  62. }
  63.  
  64. public int getId() {
  65. return id;
  66. }
  67.  
  68. public void setId(int id) {
  69. this.id = id;
  70. }
  71.  
  72. public String getLogin() {
  73. return login;
  74. }
  75.  
  76. public void setLogin(String login) {
  77. this.login = login;
  78. }
  79.  
  80. public String getPassword() {
  81. return password;
  82. }
  83.  
  84. public void setPassword(String password) {
  85. this.password = password;
  86. }
  87.  
  88. public String getEmail() {
  89. return email;
  90. }
  91.  
  92. public void setEmail(String email) {
  93. this.email = email;
  94. }
  95.  
  96. public byte[] getAvatar() {
  97. return avatar;
  98. }
  99.  
  100. public void setAvatar(byte[] avatar) {
  101. this.avatar = avatar;
  102. }
  103.  
  104.  
  105. }
  106.  
  107. package com.serwis.model;
  108.  
  109. import javax.persistence.*;
  110. import java.util.Date;
  111.  
  112.  
  113. @Entity
  114. @Table(name="Post")
  115. public class Post {
  116.  
  117. @Id
  118. @GeneratedValue(strategy= GenerationType.AUTO)
  119. @Column(name="id")
  120. private int id;
  121.  
  122.  
  123. @Column(name="content")
  124. private String content;
  125.  
  126. @Column(name="date")
  127. private Date date;
  128.  
  129. @Column(name="tags")
  130. private String tags;
  131.  
  132. @ManyToOne
  133. @JoinColumn(name="DODATKOWA")
  134. private Users users;
  135.  
  136. public Post(){}
  137.  
  138. public Post( String content, Date date, String tags) {
  139. this.content = content;
  140. this.date = date;
  141. this.tags = tags;
  142. }
  143.  
  144. public Post(String content, Date date, String tags, Users users) {
  145. this.content = content;
  146. this.date = date;
  147. this.tags = tags;
  148. this.users = users;
  149. }
  150.  
  151. @Override
  152. public String toString() {
  153. return "Post{" +
  154. "id=" + id +
  155. ", content='" + content + ''' +
  156. ", date=" + date +
  157. ", tags='" + tags + ''' +
  158. ", users=" + users +
  159. '}';
  160. }
  161.  
  162. public int getId() {
  163. return id;
  164. }
  165.  
  166. public void setId(int id) {
  167. this.id = id;
  168. }
  169.  
  170. public Users getUsers() { return users; }
  171.  
  172. public void setUsers(Users users) { this.users = users; }
  173.  
  174. public String getContent() {
  175. return content;
  176. }
  177.  
  178. public void setContent(String content) {
  179. this.content = content;
  180. }
  181.  
  182. public Date getDate() {
  183. return date;
  184. }
  185.  
  186. public void setDate(Date date) {
  187. this.date = date;
  188. }
  189.  
  190. public String getTags() {
  191. return tags;
  192. }
  193.  
  194. public void setTags(String tags) {
  195. this.tags = tags;
  196. }
  197. }
  198.  
  199. import com.serwis.model.Chat;
  200. import com.serwis.model.Photo;
  201. import com.serwis.model.Post;
  202. import com.serwis.model.Users;
  203. import org.hibernate.Query;
  204. import org.hibernate.Session;
  205. import org.hibernate.SessionFactory;
  206. import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
  207. import org.hibernate.cfg.Configuration;
  208. import org.hibernate.service.ServiceRegistry;
  209.  
  210. import java.util.List;
  211.  
  212.  
  213. /**
  214. * Created by Jodanpotasu on 2016-07-17.
  215. */
  216. public class TEST {
  217.  
  218. public static void main(String[] args){
  219. Configuration configuration = new Configuration().configure().addAnnotatedClass(Users.class).addAnnotatedClass(Post.class);
  220. ServiceRegistry serviceRegistry
  221. = new StandardServiceRegistryBuilder()
  222. .applySettings(configuration.getProperties()).build();
  223.  
  224. // builds a session factory from the service registry
  225. SessionFactory sessionFactory = configuration.buildSessionFactory(serviceRegistry);
  226.  
  227.  
  228.  
  229. try{
  230. Users user = new Users(null,"YYYYYYYYYYYYY","dupa","dupa");
  231. Post post = new Post("content",null,"tags",user);
  232.  
  233. Session session = sessionFactory.openSession();
  234. session.beginTransaction();
  235. session.save(user);
  236. session.save(post);
  237.  
  238. Query query = session.createQuery("from Users");
  239. List list = query.list();
  240.  
  241. Query query1 = session.createQuery("from Post");
  242. List list1 = query1.list();
  243.  
  244. session.getTransaction().commit();
  245.  
  246.  
  247. session.close();
  248.  
  249. System.out.println(list);
  250.  
  251. System.out.println("post");
  252. System.out.println(list1);
  253.  
  254. }catch (Exception e){
  255. System.out.println("bladnn");
  256. System.out.println(e);
  257. } finally {
  258. System.out.println("zrobiono");
  259. }
  260.  
  261.  
  262.  
  263.  
  264.  
  265. }
  266. }
  267.  
  268. <?xml version='1.0' encoding='utf-8'?>
  269. <!DOCTYPE hibernate-configuration PUBLIC
  270. "-//Hibernate/Hibernate Configuration DTD//EN"
  271. "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
  272.  
  273. <hibernate-configuration>
  274. <session-factory>
  275. <!-- JDBC connection settings -->
  276. <property name="hibernate.connection.driver_class">org.hsqldb.jdbcDriver</property>
  277. <property name="connection.url">jdbc:hsqldb:file:database/serwisDB;hsqldb.write_delay=false;shutdown=true;</property> <!--shutdown=true; -->
  278. <property name="connection.username">sa</property>
  279. <property name="connection.password"></property>
  280. <!--https://www.progress.com/jdbc/resources/tutorials/connection-pooling/connection -->
  281. <property name="connection.pool_size">1</property>
  282.  
  283. <!-- SQL DIALECT -->
  284. <property name="hibernate.dialect">org.hibernate.dialect.HSQLDialect</property>
  285.  
  286. <!-- SHOW SQL OUTPUT -->
  287. <property name="show_sql">true</property>
  288.  
  289. <property name="hibernate.current_session_context_class">thread</property>
  290.  
  291. <property name="hibernate.hbm2ddl.auto">update</property>
  292.  
  293.  
  294.  
  295. </session-factory>
  296. </hibernate-configuration>
  297.  
  298. java.lang.NullPointerException
  299. zrobiono
  300. 22:40:25.391 [pool-1-thread-1] DEBUG org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl - Connection pool now considered primed; min-size will be maintained
  301.  
  302. Process finished with exit code -1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement