企业官网建设流程全解析

一、SQL语句中字段名打错

javax.servlet.ServletException: java.sql.SQLSyntaxErrorException: Unknown column 'b.depton' in 'on clause'
报错原因：在Scott数据库中 dept表中deptno字段名打错了

String sql = "select a.* ,b.dname from emp a join dept b on a.deptno=b.deptno where 1=1 ";