连接mysql数据库

连接mysql数据库操作

加载mysql驱动,下一个驱动的jar包;

Connection con;String driver = "com.mysql.jdbc.Driver";String url = "jdbc:mysql://localhost:3306/mydb";String user = "root";String password = "123456";try{Class.forName(driver);con = DriverManager.getConnection(url,user,password);if(!con.isClosed()){System.out.println("Succeeded connecting to the Database!");}Statement statement = con.createStatement();String sql = "select * from users";ResultSet rs = statement.executeQuery(sql);System.out.println("-----------------");System.out.println("执行结果如下所示:");  System.out.println("-----------------");  System.out.println("用户名" + "\t" + "密码");  System.out.println("-----------------"); String username = null;String pass_word = null;while(rs.next()){username = rs.getString("USER_NAME");pass_word = rs.getString("PASSWORD");System.out.println(username + "\t" + pass_word);}rs.close();con.close();}catch (Exception e) { e.printStackTrace();}finally{    System.out.println("数据库数据成功获取！！");}