java mysql

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
 
public class FetchValueClass {
 
    static final String URL = "jdbc:mysql://localhost/cm";
    static final String USERNAME = "user";
    static final String PASSWORD = "pass";
 
    public static void main(String[] args){
 
        String sql = "SELECT * FROM music;";
 
        try ( Connection connection = DriverManager.getConnection(URL, USERNAME, PASSWORD);
            PreparedStatement statement = connection.prepareStatement(sql); ){
 
            ResultSet result = statement.executeQuery();
 
            result.next();
            System.out.println(result.getString(1));
            System.out.println(result.getString(2));
            System.out.println(result.getString(3));
            System.out.println(result.getString("id"));
            System.out.println(result.getString("name"));
            System.out.println(result.getString("title"));
 
            System.out.println("");
 
            result.next();
            System.out.println(result.getString(1));
            System.out.println(result.getString(2));
            System.out.println(result.getString(3));
            System.out.println(result.getString("id"));
            System.out.println(result.getString("name"));
            System.out.println(result.getString("title"));
 
        } catch(SQLException e){
            e.printStackTrace();
        }
    }
}