jdbc连接数据库

package privateTest;

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

public class myTest {

	public static void main(String[] args) throws SQLException {
		// 连接数据库
		String url = "jdbc:oracle:thin:@192.168.2.198:1521/toroku";
		String user = "CT7ADMIN";
		String password = "Ct7Adm_User";
		Connection conn = null;
		PreparedStatement pre = null;
		ResultSet rs = null;
		try{
			Class.forName("oracle.jdbc.OracleDriver"); 
			conn = DriverManager.getConnection(url, user, password);
			System.out.println("192.168.2.198 toroku connect success!");			
			String sql = "Select * from TableTest where ColumnTest = ?";
			pre = conn.prepareStatement(sql);
			pre.setString(1, "test");
			rs = pre.executeQuery();
			while(rs.next()){
				System.out.println(rs.getString("ColumnTest"));
			}						
		}catch(Exception e){
			e.printStackTrace();
		}finally{

//关闭连接，后打开先关闭
			try{
				if(rs != null)
					rs.close();
				if(pre != null)
					pre.close();
				if(conn != null)
					conn.close();
			}catch(Exception e){
				e.printStackTrace();
			}
		}				
	}
}