Java：使用JDBC连接MySql数据库（查）

我不是女神ヾ 2023-07-25 09:16 9阅读 0赞

**使用JDBC连接mysql详细步骤以及增删改数据点击：**[https://blog.csdn.net/qq\_39588003/article/details/105498473][https_blog.csdn.net_qq_39588003_article_details_105498473]

package com.health.jdbc.查;
    
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.sql.Statement;
    
    import com.mysql.cj.protocol.Resultset;
    
    public class JdbcSelect {
    	public static void main(String[] args) throws Exception {
    		Connection conn = null;
    		Statement stmt = null;
    		ResultSet rs = null;
    		try {
    			//1.注册驱动(mysql8可省略)
    			Class.forName("com.mysql.cj.jdbc.Driver");
    			//2.定义sql
    			String sql = "select * from books";
    			//3.获取Connection对象
    			conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/数据库名?serverTimezone=Asia/Shanghai","用户名","密码");
    			//4.获取执行sql的对象 Statement
    			stmt = conn.createStatement();
    			//5.执行sql
    			rs = stmt.executeQuery(sql);
    
    			//6.处理结果
    			while(rs.next()) {
    				//循环判断游标是否在最后一行末尾
    				//根据表的各个字段名(或序号)获取数据
    				int id = rs.getInt("id");
    				String name = rs.getString(2);
    				String price = rs.getString("price");
    				String author = rs.getString(4);
    				System.out.println(id+"---"+name+"---"+price+"---"+author);
    			}
    			
    		} catch (ClassNotFoundException e) {
    			e.printStackTrace();
    		}finally {
    			//7.释放资源
    			//避免空指针异常
    			if(rs!=null) {
    				try {
    					stmt.close();
    				} catch (Exception e) {
    					e.printStackTrace();
    				}
    			}
    			if(stmt!=null) {
    				try {
    					stmt.close();
    				} catch (Exception e) {
    					e.printStackTrace();
    				}
    			}
    			if(conn!=null) {
    				try {
    					stmt.close();
    				} catch (Exception e) {
    					e.printStackTrace();
    				}
    				
    			}
    		}
    	}
    }

**查询结果：**

![2020041323350711.png][]

**数据库books表：**

![20200413233609187.png][]

[https_blog.csdn.net_qq_39588003_article_details_105498473]: https://blog.csdn.net/qq_39588003/article/details/105498473
[2020041323350711.png]: /images/20230528/8c582ee3397f4badbb38ec427b20b51b.png
[20200413233609187.png]: /images/20230528/67605ed1335745129c4a95d6a9dd0ad5.png