J2EE项目中施用Json格式数据

J2EE项目中使用Json格式数据
在java中使用json，一共需要引入6个包：
1.json-lib-2.4-jdk15.jar(json包,必须导入)
2.commons-lang 2.5(依赖包,必须导入)
3.commons-beanutils 1.8.0(依赖包,必须导入)
4.commons-collections 3.2.1(依赖包,必须导入)
5.commons-logging 1.1.1(依赖包,必须导入)
6.ezmorph 1.0.6(依赖包,必须导入)
Demo流程：
点击index.jsp页面的"json测试按钮",经jquery调用getJson ajax请求处理到JsonServlet,servlet中调用DeptDAO方法查询dept表中的所有数据,并返回list,在将list封装成json格式数据,最后callback,并在index.jsp页面的相应div中显示数据.
主要代码如下:
1.index.jsp

2.Dept.java(实体类)

5.DBHelp.java(数据库工具类)
package com.czq.util;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class DBHelp {private static final String url="jdbc:oracle:thin:@localhost:1521:orcl";private static final String driver="oracle.jdbc.driver.OracleDriver";private static final String userName="scott";private static final String userPassWord="tiger";public static Connection getConnection(){try {Class.forName(driver);Connection connection=DriverManager.getConnection(url, userName, userPassWord);if (null!=connection) {return connection;}} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}return null;}public static void closeResultSet(ResultSet resultSet) {if (null!=resultSet) {try {resultSet.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}public static void closeStatement(Statement statement) {if (null!=statement) {try {statement.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}public static void closeConnection(Connection connection) {if (null!=connection) {try {connection.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}public static void main(String[] args) {DBHelp.getConnection();}}

最后附上源码