JDBC开发步骤：

JDBC入门

1.首先加入mysql-connector-java-5.1.39-bin.jar（JDBC开发jar包）

2.简单的开发代码案例

try {
			//1.注册驱动
			DriverManager.deregisterDriver(new com.mysql.jdbc.Driver());
			//2.建立连接  参数1：协议+访问的数据库 ， 参数2：用户名 ， 参数3：密码
			Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/day06", "root", "247436");
			//3.创建statement ， 跟数据库打交道一定需要这个对象, 一种提供操作sql语句的接口;
			Statement st = conn.createStatement(); 
			//4.执行查询，获得结果
			String sql = "select * from student";
			ResultSet rs = st.executeQuery(sql);
			
			while(rs.next()) {
				int int1 = rs.getInt("sid");
				String name = rs.getString("sname");
				System.out.println(int1);
				System.out.println(name);
			}
			
			rs.close();
			st.close();
			conn.close();
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

**如果连接数据库失败，需要重新设置MySql密码；

JDBC工具类(释放资源)

1.jdbc代码的完善

public static void main(String[] args) {
		Connection conn = null;
		ResultSet rs = null;
		Statement st = null;
		try {
			//1.注册驱动
			DriverManager.deregisterDriver(new com.mysql.jdbc.Driver());
			//2.建立连接  参数1：协议+访问的数据库 ， 参数2：用户名 ， 参数3：密码
			conn = DriverManager.getConnection("jdbc:mysql://localhost/day06", "root", "247436");
			//3.创建statement ， 跟数据库打交道一定需要这个对象, 一种提供操作sql语句的接口;
			st = conn.createStatement(); 
			//4.执行查询，获得结果
			String sql = "select * from student";
			rs = st.executeQuery(sql);
			
			while(rs.next()) {
				int int1 = rs.getInt("sid");
				String name = rs.getString("sname");
				System.out.println(int1);
				System.out.println(name);
			}	
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally {
			JDBCUtil.release(conn, st, rs);
		}
	}

2.释放资源工具类：

public class JDBCUtil {
	//防止出现异常
	public static void release(Connection conn , Statement st , ResultSet rs) {
		closeConnection(conn);
		closeResultSet(rs);
		closeStatement(st);
	}
	private static void closeResultSet(ResultSet rs) {
		if(rs != null) {
			try {
				rs.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}finally {
				rs = null ;
			}
		}
	}
	private static void closeStatement(Statement st) {
		if(st != null) {
			try {
				st.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}finally {
				st = null ;
			}
		}
	}
	private static void closeConnection(Connection conn) {
		if(conn != null) {
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}finally {
				conn = null ;
			}
		}
	}