1、下载并添加mysql-connector-java-5.1.17-bin.jar包
2、代码
package mysqltest;import java.io.*;import java.sql.*;public class test { public static void main(String[] args) { String JDriver= "com.mysql.jdbc.Driver"; String connectdb="jdbc:mysql://127.0.0.1:3306/abc";//abc是database name try{ Class.forName(JDriver); }catch(ClassNotFoundException ex){ ex.printStackTrace(); System.out.println("加载数据库引擎失败！"); System.exit(0); } System.out.println("数据库引擎加载成功！"); try{ String user="root"; String password="123456"; Connection con=DriverManager.getConnection(connectdb, user, password); System.out.println("连接数据库成功！"); Statement stmt=con.createStatement(); System.out.println("查询/n开始读取数据"); ResultSet rs=stmt.executeQuery("SELECT * FROM users where id=1"); while(rs.next()) { System.out.println(rs.getString("id")+"/t"+rs.getString("name")); } stmt.close(); con.close(); }catch(SQLException e){ e.printStackTrace(); System.exit(0); } }}
