数据库之JDBC

1.JDBC
数据库连接信息：

#oracle
jdbc.driver=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle.thin:@localhost:1521:your_database
jdbc.user=hr
jdbc.pwd=hr

#mysql
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/your_database
jdbc.user=root
jdbc.pwd=root

#sqlserver
jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc.url=jdbc:sqlserver://localhost:1433;databaseName=your_database
jdbc.user=sa
jdbc.pwd=sa

package org.lanqiao.proj.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class JdbcDemo {
	public static void main(String[] args) {
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		try {
			//1. 加载数据库驱动（桥梁）
			Class.forName("oracle.jdbc.driver.OracleDriver");
			System.out.println("数据库驱动加载成功！");
			
			//2. 获取连接对象
			conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl11g", "hr", "hr");
			System.out.println("数据库连接成功！");
			
			//3. 创建命令对象
			stmt = conn.createStatement();
			
			//4. 做crud 操作
			//int ret = stmt.executeUpdate("DML语句");
			rs = stmt.executeQuery("select * from student");	//DQL
			if(null != rs) {
				while(rs.next()) {
					String no = rs.getString("no");
					String name = rs.getString("name");
					Student stu = new Student(no, name);
					System.out.println(stu);
				}
			}
			
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}finally {
			//5. 资源回收释放
			try {
				if(null != rs) {
					rs.close();
				}
				if(null != stmt) {
					stmt.close();
				}
				if(null != conn) {
					conn.close();
				}
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
	}
}