Java连接数据库（JDBC）之三：java访问数据库MySQL实例

在加载驱动和使用Connection connect=DriverManager.getConnection语句时IDE会提示你使用try-catch语句防止发生异常。

package cc.bb.aa;import java.sql.*;public class myjdbc {public static void main(String args[]) {try {Class.forName("com.mysql.jdbc.Driver");//加载MYSQL JDBC驱动程序 //Class.forName("org.gjt.mm.mysql.Driver");System.out.println("Success loading Mysql !");}catch (Exception e) {System.out.print("Error loading Mysql Driver!");e.printStackTrace();}try {Connection connect =DriverManager.getConnection( "jdbc:mysql://localhost:3306/tuke","root","123456");//连接URL为 jdbc:mysql//服务器地址/数据库名 ，后面的2个参数分别是登陆用户名和密码System.out.println("Success connect Mysql !");Statement stmt = connect.createStatement();ResultSet rs = stmt.executeQuery("select * from users"); //user 为你表的名称while (rs.next()) {System.out.println(rs.getString("UserName"));}}catch (Exception e) {System.out.print("get data error!");e.printStackTrace();}}}

输出结果：