1  2 
 3 import java.sql.Connection;
 4 import java.sql.DriverManager;
 5 import java.sql.ResultSet;
 6 import java.sql.Statement;
 7 
 8  9 
10 public class JDBCTest {
11     public static void main(String[] args){
12         String driver = "com.mysql.jdbc.Driver";
13         String url = "jdbc:mysql://127.0.0.1:3306/test";
14         String user="root";
15         String password = "";
16         
17         try {
18             Class.forName(driver);
19             Connection connection = DriverManager.getConnection(url,user,password);
20             if(!connection.isClosed()){
21                 System.out.println("Succeeded connecting to the Database!");
22             }
23             Statement statement = connection.createStatement();
24             String sql = "select * from stu";
25             ResultSet rs = statement.executeQuery(sql);
26             System.out.println("id\tname");
27             while (rs.next()) {
28                 String string1 = rs.getString("id");
29                 String string2 = rs.getString("name");
30                 System.out.println(string1+‘\t‘+string2);
31             }
32         } catch (Exception e) {
33             e.printStackTrace();
34         }
35     }
36 }