DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`password` varchar(50) default NULL,
`username` varchar(50) default NULL,
`id` int(20) NOT NULL auto_increment,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
`date` datetime default NULL,
`teamName` varchar(20) default NULL,
`id` int(20) NOT NULL,
`motto` varchar(1000) default NULL,
`Tel` varchar(50) default NULL,
`QQ` varchar(50) default NULL,
`stu_number` varchar(50) default NULL,
`stu_name` varchar(50) default NULL,
`gra_id` int(20) default NULL,
`stu_id` int(20) default NULL,
PRIMARY KEY (`id`),
KEY `gra_id` (`gra_id`),
KEY `id` (`id`),
CONSTRAINT `student_ibfk_1` FOREIGN KEY (`gra_id`) REFERENCES `grade` (`gra_id`),
CONSTRAINT `student_ibfk_2` FOREIGN KEY (`id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
这两个表的查询HQL语句怎么写FindAllStudents(){}
CREATE TABLE `user` (
`password` varchar(50) default NULL,
`username` varchar(50) default NULL,
`id` int(20) NOT NULL auto_increment,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
`date` datetime default NULL,
`teamName` varchar(20) default NULL,
`id` int(20) NOT NULL,
`motto` varchar(1000) default NULL,
`Tel` varchar(50) default NULL,
`QQ` varchar(50) default NULL,
`stu_number` varchar(50) default NULL,
`stu_name` varchar(50) default NULL,
`gra_id` int(20) default NULL,
`stu_id` int(20) default NULL,
PRIMARY KEY (`id`),
KEY `gra_id` (`gra_id`),
KEY `id` (`id`),
CONSTRAINT `student_ibfk_1` FOREIGN KEY (`gra_id`) REFERENCES `grade` (`gra_id`),
CONSTRAINT `student_ibfk_2` FOREIGN KEY (`id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
这两个表的查询HQL语句怎么写FindAllStudents(){}
Session session = sessionFactory.openSession();
String hql = "from Student";
Query query = session.createQuery(hql);
List list = query.list();
return list;
}