【mysql】 java访问mysql入门例子

关联文章：

《linux下mysql的安装与使用》
《用SpringBoot创建mysql工程》
【mysql】 入门例子

CREATE TABLE `student` (
  `id` int(11) NOT NULL,
  `name` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

insert into `student` (`id`, `name`) values('1','zhangsan');
insert into `student` (`id`, `name`) values('2','lisi');

import java.sql.*;

public class JDBCTest {
    private static Connection conn;
    private static PreparedStatement pst;
    private static ResultSet rs;

    public static void main(String[] args) throws SQLException {

        PreparedStatement pst = null;
        ResultSet rs = null;

        try {
            String sql = "SELECT * FROM student";
            String url = "jdbc:mysql://10.40.65.183:3306/test";
           Class.forName("com.mysql.jdbc.Driver"); // 加载驱动

            conn = DriverManager.getConnection(url, "name", "password");
            JDBCTest.pst = conn.prepareStatement(sql);
            //preparedStatement.execute("SELECT * FROM student");
            JDBCTest.rs = JDBCTest.pst.executeQuery();

            while (JDBCTest.rs.next()) {
                System.out.println(JDBCTest.rs.getInt(1) + " " + JDBCTest.rs.getString(2));
            }
        } catch (Exception e) {
            e.printStackTrace();
        }finally {
            if (rs != null) {
                try {
                    rs.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            if (pst != null) {
                try {
                    pst.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            if (conn != null) {
                try {
                    conn.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }

        }
    }
}

执行结果：

1 zhangsan
2 lisi