package sql; /** * User: yumingzhe * Date: 5/19/12 * Time: 4:15 PM */ import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.Transaction; import org.hibernate.cfg.Configuration; import pojo.*; import java.io.UnsupportedEncodingException; import java.sql.Timestamp; import java.util.Date; /** * This class is used for inserting data */ public class InsertData { public static void main(String[] args) throws UnsupportedEncodingException { SessionFactory factory = new Configuration().configure().buildSessionFactory(); Session session = factory.openSession(); Transaction transaction = session.beginTransaction(); /* SiteUser siteUser = new SiteUser(); siteUser.setUsername("yumingzhe"); siteUser.setEmail("yumingzhe@live.cn"); siteUser.setActive(true); siteUser.setBanned(false); siteUser.setInstituteId("123"); siteUser.setPassword("lfjlinnnz"); siteUser.setSalt("ljfinv"); session.save(siteUser); SiteUser siteUser = (SiteUser) session.get(SiteUser.class, 1); Blog blog = (Blog) session.get(Blog.class, 1); CommentEntity commentEntity = new CommentEntity(); commentEntity.setSiteUser(siteUser); commentEntity.setBlog(blog); commentEntity.setPostTime(new Timestamp(new Date().getTime())); commentEntity.setContent("the second comment"); blog.getCommentEntities().add(commentEntity); Activity activity = new Activity(); activity.setAction("发表了评论"); activity.setActivityOccurTime(new Timestamp(new Date().getTime())); activity.setSiteUser(siteUser); activity.setCommentEntity(commentEntity); activity.setBlog(blog); siteUser.getActivities().add(activity); session.save(commentEntity);*/ /* Blog blog = new Blog(); blog.setTitle("first blog"); blog.setContent("this is the first blog"); blog.setDescription("first blog"); blog.setAccess("public"); blog.setTag("blog"); blog.setPostDate(new Timestamp(new Date().getTime())); SiteUser siteUser = (SiteUser) session.get(SiteUser.class, 1); blog.setSiteUser(siteUser); Activity activity = new Activity(); activity.setAction("post blog"); activity.setSiteUser(siteUser); activity.setBlog(blog); activity.setActivityOccurTime(new Timestamp(new Date().getTime())); blog.setActivity(activity); session.save(blog);*/ /* SiteUser siteUser = (SiteUser) session.get(SiteUser.class, 1); Blog blog = (Blog) session.get(Blog.class, 1); CommentEntity commentEntity = new CommentEntity(); commentEntity.setBlog(blog); commentEntity.setPostTime(new Timestamp(new Date().getTime())); commentEntity.setSiteUser(siteUser); commentEntity.setContent("third comment"); Activity activity = new Activity(); activity.setAction("post comment"); activity.setSiteUser(siteUser); activity.setCommentEntity(commentEntity); activity.setActivityOccurTime(new Timestamp(new Date().getTime())); commentEntity.setActivity(activity); session.save(commentEntity);*/ /* Activity activity = (Activity) session.get(Activity.class, 2); CommentEntity commentEntity = activity.getCommentEntity(); if (commentEntity != null) { Blog blog = commentEntity.getBlog(); if (blog != null) { System.out.println("blog title: " + blog.getTitle() + " blog content: " + blog.getContent()); } } else { System.out.print("i am here"); } */ /* Message message = new Message(); message.setType("internalnotice"); message.setAuthor("王艳"); message.setPublisher("administrator"); message.setTopic("信息学院举行第三届亚沙会志愿者欢送会"); message.setContent("根据“吴方数学新秀奖”评选办法规定,在个人申报和教授推荐的基础上,经学院团委审查、" + "“吴方数学新秀奖”评审委员会评审,确定数学与应用数学专业2008级孟凡钦同学为第一届“吴方数学新秀奖”获得者,现予以公示。"); message.setPublishtime(new Timestamp(new Date().getTime())); session.save(message);*/ WebsiteMessage websiteMessage=new WebsiteMessage(); websiteMessage.setWebsitename("软件工程研究室"); websiteMessage.setMaintenanceaddress("wangyan_megan@yeah.net"); websiteMessage.setDefaultlanguage("Chinese"); websiteMessage.setVisits(10); websiteMessage.setPath("./img/main_pic.jpg"); session.save(websiteMessage); /* Link link = new Link(); link.setWebsitename("SCIRUS"); link.setWebsiteurl("http://www.scirus.com/"); session.save(link); Subject subject=new Subject(); subject.setSubjecttopic("计算机科学与技术"); subject.setResearchdirection("数据仓库"); subject.setResearchmember("王艳 于明哲"); subject.setStarttime("2012年3月"); subject.setPrograss("40%"); session.save(subject);*/ transaction.commit(); session.close(); } }