Java链接数据库六大步骤

1、类加载ojdbc6.jar

Class.forName("oracle.jdbc.OracleDriver");

或者

new oracle.jdbc.driver.OracleDriver();

 

2、连接数据库

Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "Sven", "123456");

 

3、创建Statement对象将sql语句发送到数据库

Statement stmt = conn.createStatement();

 

4、执行sql语句

ResultSet rs = stmt.executeQuery("select * from dept");

 

5、通过下标获取数据

System.out.println(rs.getString("deptno"));

System.out.println(rs.getInt("deptno"));

 

6、关闭连接通道

rs.close();
stmt.close();
conn.close();

 

完整代码如下：

import java.sql.*;
public class TestJdbc {

	public static void main(String[] args) throws Exception{
		
		Class.forName("oracle.jdbc.OracleDriver");//类加载ojdbc6.jar
		//new oracle.jdbc.driver.OracleDriver();
		
		Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "Sven", "123456");//连接数据库
		Statement stmt = conn.createStatement();//创建Statement对象将sql语句发送到数据库
		ResultSet rs = stmt.executeQuery("select * from dept");//执行sql语句
		
		while(rs.next()){
			System.out.println(rs.getString("deptno"));//通过下标获取数据
			System.out.println(rs.getInt("deptno"));
		}
		rs.close();//关闭连接通道
		stmt.close();
		conn.close();
	}
}