Java数据库连接（JDBC）

创建chapter09项目，在lib文件导入mysql-connector-java-5.0.8-bin.jar包
实现第一个JDBC程序
Example01.java

package cn.itcast.jdbc.example;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Date;
public class Example01 {
   
	public static void main(String[] args) throws SQLException {
   
		Statement stmt = null;
		ResultSet rs = null;
		Connection conn = null;
		try {
   
			// 1. 注册数据库的驱动
			Class.forName("com.mysql.jdbc.Driver");
			// 2.通过DriverManager获取数据库连接
			String url = "jdbc:mysql://localhost:3306/jdbc";
			String username = "root";
			String password = "itcast";
			conn = DriverManager.getConnection (url, username, 
		     			password);
			// 3.通过Connection对象获取Statement对象
			 stmt = conn.createStatement();
			// 4.使用Statement执行SQL语句。
			String sql = "select * from users";
			rs = stmt.executeQuery(sql);
			// 5. 操作ResultSet结果集
			System.out.println("id | name   | password | email  | birthday");
			while (rs.next()) {
   
				int id = rs.getInt("id"); // 通过列名获取指定字段的值
				String name = rs.getString("name");
				String psw = rs.getString("password");
				String email = rs.getString("email");
				Date birthday = rs.getDate("birthday");
				System.out.println(id + " | " + name + " | " + psw + " | " + email
							+ " | " + birthday);
			}
		} catch (ClassNotFoundException e) {
   
			e.printStackTrace();
		} finally{
   
			// 6.回收数据库资源
			if(rs!=null) {
   
				try {
   
					rs.close();
				} catch (SQLException e) {
   
					e.printStackTrace();
				}
				rs = null;
			}
			if(stmt!=null) {
   
				try {
   
					stmt.close();
				} catch (SQLException e) {
   
					e.printStackTrace();
				}
				stmt = null;
			}
			if(conn!=null) {
   
				try {
   
					conn.close();
				} catch (SQLException e) {
   
					e.printStackTrace();
				}
				conn = null;
			}
		}		
	}
}

PreParedStateMent对象
Example02.java

package cn.itcast.jdbc.example;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement ;
import java.sql.SQLException;
public class Example02 {
   
	public static void main(String[] args) throws SQLException {
   
		Connection conn = null;
		PreparedStatement  preStmt = null;
			try {
   
	             // 加载数据库驱动
				Class.forName("com.mysql.jdbc.Driver");
				String url = "jdbc:mysql://localhost:3306/jdbc";
				String username = "root";
				String password = "itcast";
	             // 创建应用程序与数据库连接的Connection对象
				conn = DriverManager.getConnection(url, username, password);
				// 执行的SQL语句
				String sql = "INSERT INTO users(name,password,email,birthday)"
						+ "VALUES(?,?,?,?)";
	             // 创建执行SQL语句的PreparedStatement 对象
				preStmt = conn.prepareStatement(sql);
				preStmt.setString(1, "zl");
				preStmt.setString(2, "123456");
				preStmt.setString(3, "zl@sina.com");
				preStmt.setString(4, "1789-12-23");
				preStmt.executeUpdate();
			} catch (ClassNotFoundException e) {
   
				e.printStackTrace();
			} finally {
       // 释放资源
				if (preStmt !=