copy of testjdbc.java

来自「连接数据库」· Java 代码 · 共 58 行

import java.sql.*;

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:@172.16.42.123:1521:orcl", "scott", "tiger");
			stmt=conn.createStatement();//创建语句对象用于执行sql语句
			rs= stmt.executeQuery("select * from dept");
			while(rs.next())
			{
				System.out.println(	rs.getString("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();	
			}
		}
	}

}