JDBC简单连接Mysql数据库

首先导入第三方mysql的.jar包，Add as Library。我的数据库表为beauty，字段及其类型为id(int),name(String),age(int)

package DAY2;

import java.sql.*;

public class ConnMysql {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb2","root","123");
        Statement stat=conn.createStatement();
        String sql="select * from beauty";
        ResultSet rs=stat.executeQuery(sql);
        while (rs.next()){
            System.out.print(rs.getInt(1)+" ");
            System.out.print(rs.getString(2)+" ");
            System.out.println(rs.getInt(3));
        }
        conn.close();
        stat.close();
        rs.close();
    }
}