JDBC总结

JDBC编程步骤

1 Load the Driver

1 .Class.forName()|Class.forName().newInstance()|new DriverName()

2.实例化时自动向DriverManager注册，不需显示调用DriverManager.regisrerDriver方法

2 Connect to the DataBase

1.DriverManager.getConnection()

3 Execute the SQL

1.Connection.CreateStatement()

2.Statement.executeQuery()

3.Statement.executeUpdate()

4 Retrieve the result data

1.循环取得结果while(rs.next())

5 Show the result data

1.将数据库中的各种类型转换成为java中的类型(getXXX)方法

6 Close

1.close the resultset. /close the statement / close the connection

实例：

import java.sql.*;

public class TestJDBC {
	public static void main(String[] args) {
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager
					.getConnection("jdbc:mysql://localhost/mydata?user=root&password=root");

			stmt = conn.createStatement();

			rs = stmt.executeQuery("SELECT * FROM dept;");

			while (rs.next()) {
				System.out.println(rs.getString("dname"));
				System.out.println(rs.getInt("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();
			}
		}
	}
}

import java.sql.*;

public class JDBCDemo {

	public static void main(String[] args) {
		//1.声明变量
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		try {
		//2.加载驱动	
			Class.forName("com.mysql.jdbc.Driver");
			
		//3.创建连接
			conn = DriverManager.getConnection(
					"jdbc:mysql://localhost:3306/mydata", "root", "root");
			
		//4.进行sql语句查询
			String sql = "select * from customers where age=?";
			pstmt = conn.prepareStatement(sql);
			pstmt.setInt(1, 22);
			rs = pstmt.executeQuery();

		//5.对结果进行循环
			while (rs.next()) {
				System.out.println(rs.getInt("id") + "\t"
						+ rs.getString("name") + "\t" + rs.getInt("age")
						+ "\t" + rs.getString("email") + "\t");
			}
		} catch (Exception e) {
			// TODO: handle exception
		} finally {
		//6.关闭资源
			try{
			if(rs!=null){
			rs.close();
			}
			}catch(Exception e){}
			finally{
				try{
				pstmt.close();
				}catch(Exception e){}
				finally{
					try {
						if(conn!=null){
						conn.close();
						}
					} catch (SQLException e) {
					}
				}
			}
		}
	}
}