package db; import java.sql.*; public class dbTest { public static void main(String[] args) { try { Class.forName("com.mysql.jdbc.Driver"); } catch ( ClassNotFoundException e ) { System.out.println("找不到mysql 驱动"); e.printStackTrace(); } String url = "jdbc:mysql://172.28.50.248:3316/toonstore"; Connection conn; try { conn = DriverManager.getConnection(url, "docker", "1234"); Statement stmt = conn.createStatement() ; System.out.println("数据库连接成功"); String sql = "select * from user"; //要执行的SQL ResultSet rs = stmt.executeQuery(sql);//创建数据对象 System.out.println("编号"+"\t"+"姓名"+"\t"); while (rs.next()){ System.out.print(rs.getInt(1) + "\t"); System.out.print(rs.getString(3) + "\t"); System.out.println(); } rs.close(); stmt.close(); conn.close(); } catch ( SQLException e ) { System.out.println(e); e.printStackTrace(); } } }
运行结果
你打算打赏多少钱呢?
(微信扫一扫)