Javaweb查询
连接数据库:
Util JDBC工具类:代码有点多只展现一部分
Dao层:
Sql语句完整
private static final String SelectAll = “SELECT member_id,member_name,member.member_type_id,phone,PASSWORD,register_time ,member.certificate_type_id,member.certificate_number ,sex,email,member.is_valid,certificate_type,member_type FROM member INNER JOIN certificate_type ON member.certificate_type_id=certificate_type.certificate_type_id INNER JOIN member_type ON member.member_type_id =member_type.member_type_id”;
Service层:
Servlet层:
Jsp 页面:
Web.xml:配置