java.sql.SQLException:关闭的连接:

package Orcle;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class OracleApp {

	public static void main(String[] args) {
//	        Class.forName();
	        try {
				Class.forName("oracle.jdbc.driver.OracleDriver");
			} catch (ClassNotFoundException e) {
				e.printStackTrace();
			}
		   
	        PreparedStatement pp=null;
	        Connection con=null;
	        
	        try {
				
	        	con=DriverManager.getConnection("jdbc:oracle:thin:@192.168.58.1:1521:oracle", "scott", "Ab123456");
	            	System.out.println("数据库连接成功");
	        
	        } catch (SQLException e) {
				e.printStackTrace();
			}




这里在preparestament 调用前。数据库连接不能关闭 也就不能con.close();
//finally {
//				try {
//					con.close();
//				} catch (SQLException e) {
//					// TODO 自动生成的 catch 块
//					e.printStackTrace();
//				}
//			}
	        
	      try {
			pp=con.prepareStatement("select * from  T_TEACHER");
		   ResultSet rs=pp.executeQuery();
		   
		   while(rs.next()) {
			   System.out.println(rs.getString("TEACHER_NAME"));
		   }rs.close();
		} catch (SQLException e) {
	
			e.printStackTrace();
		}finally {
			try {
				
				if (pp!=null) {
					pp.close();
				}
				if (con!=null) {
					con.close();
				}
				
			} catch (SQLException e) {
				e.printStackTrace();
			}
		
		}
	       
	      
	      
	     
	        
		
	}

}