JDBC连接数据库

1.加载JDBC驱动程序

Class.forName(“com.mysql.jdbc.Driver”);

Class.forName(“oracle.jdbc.OracleDriver”);

2.提供jdbc连接的URL

String url ="jdbc:oracle:thin:@192.168.0.64:1521/xe";

String url = "jdbc:mysql://localhost:3306/javademo?"

                + "user=root&password=root&useUnicode=true&characterEncoding=UTF8";

 

3.创建数据库的连接

Connection con = DriverManager.getConnection(url,"lxl","1234");

4.创建一个Statement

Statement st = con.createStatement();

5.执行SQL语句返回一个ResultSet集合

ResultSet rs = st.executeQuery("select* from stud");

6.遍历ResultSet获取数据库的值

while(rs.next()){

           String id = rs.getString("id");

           String name = rs.getString("name");

           intage =rs.getInt("age");

           String sex = rs.getString("sex");

           System.err.println(id+","+name+","+age+","+sex);

       }

7.关闭JDBC对象

关闭记录集 ResultSetrs

关闭声明  Statement 

关闭连接对象 Connection

代码示例：

添加build path ：ojdbc.jar（自己去找。。。）

一般在Oracle数据库安装目录：F:\sqldeveloper\jdbc\lib 下有个jar包【ojdbc.jar】，将它复制出来用于构建路径。

package cn.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import org.junit.Test;

public class Demo {
	@Test
	public void test() throws Exception {
		Class.forName("oracle.jdbc.OracleDriver");
		String url="jdbc:oracle:thin:@192.168.0.105:1521/xe";
		Connection con =DriverManager.getConnection(url,"lxl","1234");
		System.err.println(">>"+con);
		Statement st=con.createStatement();
		ResultSet rs = st.executeQuery("select * from stud");
		while(rs.next()) {
			String id=rs.getString("id");
			String name=rs.getString("name");
			String sex=rs.getString("sex");
			int age=rs.getInt("age");
			System.err.println(id+","+name+","+sex+","+age);
		}
		rs.close();
		st.close();
		con.close();
	}

}