一周问题总结——Java web——Myeclipse2017

 

1. Navicat 连接不上Oracle 报28547 ——oci.dll文件版本问题

2.Hibernate pojos配置文件问题：

注解：

新建实体类XXX.java对应一张表。

@Table name 表名

@Id

@GeneratedValue主键

@Column表内字段 name字段名一致，private String userAccount;

3.SQL多表查询

SELECT
	"COUNT" (s.USER_ACCOUNT) AS "num",
	o.GRADE "年级",
	s.EDUCATION "学历"
FROM
	VIEW_USER S
LEFT JOIN VIEW_ORG O ON s.USER_ACCOUNT = o.USER_ACCOUNT
GROUP BY
	o.GRADE,
	s.EDUCATION
ORDER BY
	O.GRADE,
	s.EDUCATION DESC

LEFT JOIN 左外连接

GROUP BY 分组

OEDER　BY　排序