JDBC 流程

1、加载数据库驱动类

   //mysql驱动 
   public static final String DRIVER = "com.mysql.jdbc.Driver";
   //连接数据库的url
   public static final String URL = "jdbc:mysql://localhost:3306/test";
    //数据库用户名
    public static final String USERNAME = "root";
    //密码
    public static final String PASSWORD = "root";
    //第一步：加载Driver类
	Class.forName(DRIVER);

2、通过DriverManager，使用url，用户名，密码获取数据库连接Connection

	connection = DriverManager.getConnection(URL, USERNAME, PASSWORD);

3、通过Connection，使用sql语句打开Statement对象

	preparedStatement = connection.prepareStatement("select * from Person where name =?");
	//传入参数，之所以这样是为了防止sql注入
    preparedStatement.setString(1,"lyy");

4、执行语句，返回结果resultSet

	resultSet = preparedStatement.executeQuery();

5、对结果resultSet进行处理

	while (resultSet.next()) {
       String name = resultSet.getString("name");
    }

6、倒序释放资源 resultSet->preparedStatement ->connection

	try {
          if (null != resultSet && !resultSet.isClosed()) {
             resultSet.close();
          }
          if (null != preparedStatement && !preparedStatement.isClosed()) {
             preparedStatement.close();
          }
          if (null != resultSet && !resultSet.isClosed()) {
             resultSet.close();
          }
   	} catch (Exception e) {

    }