Java本地连接数据库（idea）

import java.sql.*;

public class TestJDBC {
    private final static String USER = "root";
    private final static String PASS = "123456";
    public static void main(String[] args) {

        try {
            //step1
            Class.forName("com.mysql.jdbc.Driver");
            //step2
            try {
                System.out.println("Connecting to databse...");
                Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/student",USER,PASS);
                //step3
                Statement stmt = conn.createStatement();
                //step4
                String sql = "SELECT * from student";
                ResultSet rs = stmt.executeQuery(sql);
                //step5
                while(rs.next()){
                    System.out.println("serial:" + rs.getString(1)+"name:" + rs.getString(2) + "birth:" + rs.getString(3));
                }
                //step6
                rs.close();
                stmt.close();
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        } catch (ClassNotFoundException e) {
            System.out.println("加载驱动失败！");
        }

    }
}

注意：

1.idea导入mysql-connector-java-5.1.44-bin.jar包
  直接将mysql-connector-java-5.1.44-bin.jar拖动到项目名处，然后单击工程目录mysql-connector-java-5.1.44-bin.jar右键Add as library即可。如果:jar包没配置正确的化,就会提示ClassNotFoundException异常。
2.getString方法的列下表是从1开始的。
　　* @param columnIndex the first column is 1, the second is 2, …
　　String getString(int columnIndex) throws SQLException
3.markdown 实现缩进的小技巧：
　　（1）全角状态下：按空格即可（如搜搜狗输入法的全角半角切换关闭了，可右键输入法->设置属性->按键 将shift+space复选框选中）
　　（2）自己输入命令：中文空格： 英文空格：&nbsp；