标准JDBC连接

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class Test {

	/**
	 * @param args
	 */
	public static void main(String[] args) {

		String s = getJson();
		System.out.println(s);
	}
	
	public static String getJson() {
		
	    String s="{\"departmentOfRegister\":[";
	    Connection con = null;// 创建一个数据库连接
	    PreparedStatement pre = null;// 创建预编译语句对象，一般都是用这个而不用Statement
	    ResultSet result = null;// 创建一个结果集对象
	    PreparedStatement pre2 = null;
	    ResultSet result2 = null;
	    try {
	        Class.forName("oracle.jdbc.driver.OracleDriver");// 加载Oracle驱动程序
	        System.out.println("开始尝试连接数据库！");
	        String url = "jdbc:oracle:" + "thin:@127.0.0.1:1521:XE";// 127.0.0.1是本机地址，XE是精简版Oracle的默认数据库名
	        String user = "user";// 用户名,系统默认的账户名
	        String password = "password";// 你安装时选设置的密码
	        con = DriverManager.getConnection(url, user, password);// 获取连接
	        System.out.println("连接成功！");
	        String sql = "select * from TABLE where DEFINITIONID=? order by code";// 预编译语句，“？”代表参数
	        pre = con.prepareStatement(sql);// 实例化预编译语句
	        pre.setString(1, "departmentOfRegister");// 设置参数，前面的1表示参数的索引，而不是表中列名的索引
	        result = pre.executeQuery();// 执行查询，注意括号中不需要再加参数
	        while (result.next()) {
	        	s += "{\"code\":\"" + result.getString("code") + "\",\"name\":\"" + result.getString("codename") + "\"},";
	        }
	        s = s.substring(0, s.length()-1);
	        s += "],\"localPoliceStation\":[";
	        
	        String sql2 = "select * from TABLE where DEFINITIONID=? order by code";
	        pre2= con.prepareStatement(sql2);
	        pre2.setString(1, "localPoliceStation");
	        result2 = pre2.executeQuery();
	        while (result2.next()) {
	        	s += "{\"code\":\"" + result2.getString("code") + "\",\"name\":\"" + result2.getString("codename") + "\",\"parentCode\":\"" + 
	        			result2.getString("parentCode") + "\"},";
	        }
	        s = s.substring(0, s.length()-1);
	        s += "],\"result\":\"success\"}";
	    } catch (Exception e) {
	    	e.printStackTrace();
	    }
		
	    return s;
	}

}