Java的JDBC编程初体验

JDBC编程主要步骤如下：
开始
1.加载数据库的JDBC驱动（JDBC API）*
2.创建连接*
3.创建命令*
4.准备SQL语句 C
5.执行SQL语句* C
6.处理结果* C
7.关闭结果
8.关闭命令
9.关闭连接

代码如下：

import java.sql.*;

/**
 * Created with IntelliJ IDEA.
 * Description:
 * User: Y
 * Date: 2019-06-24
 * Time: 21:21
 */
public class MyFirstJDBC {
    public static void main(String[] args) {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            String url="jdbc:mysql://127.0.0.1:3306/mos?user=root&password=177458";
            try {
                Connection connection=DriverManager.getConnection(url);
                Statement statement=connection.createStatement();
                String sql="select id,xingming from info";
                ResultSet resultSet=statement.executeQuery(sql);
                while (resultSet.next()){
                    int id=resultSet.getInt("id");
                    String name=resultSet.getString("xingming");
                    System.out.println(id+" "+name);
                }

            } catch (SQLException e) {
                e.printStackTrace();
            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }


}

?