JDBC连接示例程序-Oracle和MySQL

以Oracle和MySQL为例，比较完善的JDBC连接示例

Oracle连接：

import java.sql.*;
/*
 * 数据库 jdbc 
 * 严谨示例程序
 */
public class TestJDBC 
{
	public static void main (String[] args)
	{
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		try
		{
			Class.forName("oracle.jdbc.driver.OracleDriver");
			conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.1:MINEDB", "root","password");
			stmt = conn.createStatement();
			rs = stmt.executeQuery("select * from dept");
			
			while(rs.next())
			{
				System.out.println(rs.getString("deptno"));
				System.out.println(rs.getInt("deptno"));
			}
		}
		catch(ClassNotFoundException e)
		{
			e.printStackTrace();
		}
		catch(SQLException e)
		{
			e.printStackTrace();
		}
		finally
		{
			try
			{
				if(rs != null) 
				{
					rs.close();
					rs=null;
				}
				if(stmt != null)
				{
					stmt.close();
					stmt=null;
				}
				if(conn !=null)
				{
					conn.close();
					conn=null;
				}
			}
			catch(SQLException e)
			{
				e.printStackTrace();	
			}
		}
	}
}

MySQL连接

package bean;

import java.sql.*;

public class TestMysqlConnection
{
	public static void main(String[] args)
	{
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		try
		{
			Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager.getConnection(
					"jdbc:mysql://localhost:3306/mydata?useUnicode=true&characterEncoding=utf-8&useSSL=false&user=root&password=11235");
			stmt = conn.createStatement();
			rs = stmt.executeQuery("select * from dept");
			while (rs.next())
			{
				System.out.println(rs.getString("loc"));
			}
		} 
		catch (ClassNotFoundException e)
		{
			e.printStackTrace();
		} 
		catch (SQLException e)
		{
			e.printStackTrace();
		} 
		finally// 先开后关
		{
			try
			{
				if (rs != null)
				{
					rs.close();
					rs = null;//让垃圾收集器可以随时回收
				}
				if (stmt != null)
				{
					stmt.close();
					stmt = null;
				}
				if (conn != null)
				{
					conn.close();
					conn = null;
				}
			} 
			catch (SQLException e)
			{
				e.printStackTrace();
			}
		}
	}

}