dbconnection.java

jsp和ajax 的三级联动

package com.soft.dwr;

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

public class DBConnection {
	private static Connection con;

	public DBConnection() {

	}

	public static Connection getCon() {
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			con = DriverManager.getConnection(
					"jdbc:oracle:thin:@localhost:1521:orcl", "system",
					"sinojava");
		} catch (Exception e) {
			e.printStackTrace();
		}
		return con;
	}

	public static void close(Statement smt, ResultSet rst) throws Exception {
		if (rst != null) {
			rst.close();
		}
		if (smt != null)
			smt.close();

	}

	
}