Javaweb上级考试程序.docVIP

共四个包,整个架构为： 注意： （1）、建java web项目时需要选择JSTL Support（1.1） （2）、在项目中先建一个.sql文件，创建数据库代码都要写进去，然后打开MySql客户端创建数据库。 dao 包 AddressDao.java package dao; import java.sql.*; import java.util.*; import entity.*; import util.*; public class AddressDao public void add Address address try Connection conn JdbcUtil.getConnection ; PreparedStatement pstmt conn.prepareStatement insert into address name,street,city,state,zip values ?,?,?,?,? ; pstmt.setString 1,address.getName ; pstmt.setString 2,address.getStreet ; pstmt.setString 3,address.getCity ; pstmt.setString 4,address.getState ; pstmt.setString 5,address.getZip ; pstmt.executeUpdate ; JdbcUtil.close pstmt,conn ; catch SQLException e e.printStackTrace ; throw new RuntimeException e ; public void delete int id try Connection conn JdbcUtil.getConnection ; PreparedStatement pstmt conn.prepareStatement delete from address where id ? ; pstmt.setInt 1,id ; pstmt.executeUpdate ; JdbcUtil.close pstmt,conn ; catch SQLException e e.printStackTrace ; throw new RuntimeException e ; public void update Address address try Connection conn JdbcUtil.getConnection ; PreparedStatement pstmt conn.prepareStatement update address set name ?,street ?,city ?,state ?,zip ? where id ? ; pstmt.setString 1,address.getName ; pstmt.setString 2,address.getStreet ; pstmt.setString 3,address.getCity ; pstmt.setString 4,address.getState ; pstmt.setString 5,address.getZip ; pstmt.setInt 6,address.getId ; pstmt.executeUpdate ; JdbcUtil.close pstmt,conn ; catch SQLException e e.printStackTrace ; throw new RuntimeException e ; public List findAll List list new ArrayList ; try Connection conn JdbcUtil.getConnection ; PreparedStatement pstmt conn.prepareStatement select * from address ; ResultSet rs pstmt.executeQuery ; while rs.next Address address new Address ; address.setId rs.getInt 1 ; address.setName rs.getString 2 ; address.setStreet rs.getString 3 ; address.setCity rs.getString 4 ; address.s