jdbc编程之数据查询

先把jar包下载好，并倒入工程

package com.bupt.jdbc; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class JDBCTest { public static void main(String[] args) { String sql = "SELECT * FROM tbl_user"; Connection conn = null; //数据库连接 Statement st = null; //用于执行查询 ResultSet rs = null; //结果集合 try { Class.forName("com.mysql.jdbc.Driver"); //加载驱动 conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jsp_db?useSSL=false", "root", "19930614"); //打开连接 st = conn.createStatement(); //执行查询 rs = st.executeQuery(sql); while(rs.next()){ //处理结果 System.out.print(rs.getInt("id")+" "); System.out.print(rs.getString("name")+" "); System.out.print(rs.getString("password")+" "); System.out.print(rs.getString("email")+" "); System.out.println(); } } catch (Exception e) { e.printStackTrace(); }finally{ try { //清理环境 rs.close(); } catch (Exception e2) { e2.printStackTrace(); } try { st.close(); } catch (Exception e3) { e3.printStackTrace(); } try { conn.close(); } catch (Exception e4) { e4.printStackTrace(); } } } }