JAVA-JDBC查询数据库

package com.dxm;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class JDBCDemo4 {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        Class.forName("com.mysql.jdbc.Driver");
        
        String url = "jdbc:mysql://localhost:3306/mybase";
        String user="root";
        String password="1234";
        Connection connection = DriverManager.getConnection(url, user, password);
        
        String sql = "select * from sort";        
        PreparedStatement statement = connection.prepareStatement(sql);
        
        ResultSet set = statement.executeQuery();
        while(set.next()){
            System.out.println(set.getString("sid")+"   "+set.getString("sname")+"   "+set.getString("sprice")+"   "+set.getString("sdesc"));
            
        }
        set.close();
        statement.close();
        connection.close();
        
    }
}