//DB.java


package db;
import java.sql.*;

public class DB {

    private Connection conn;

    public DB() {
        try {
            Class.forName("com.mysql.jdbc.Driver").newInstance();

            String url = ("jdbc:mysql:///ims");
            conn =  DriverManager.getConnection(url, "java", "java");

        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    public Connection getConn() {
        return conn;
    }
}




// Device.java

import db.DB;
import java.sql.*;
class Device{

    public static void getDevice(){
    try {
        DB db = new DB();
        Connection conn = db.getConn();
        Statement statement = conn.createStatement();
        String Query = "SELECT * from Device";
        ResultSet rs = statement.executeQuery(Query);
        while (rs.next()){
        String model = rs.getString("Model");
        System.out.println( model );
        }
        conn.close();
    }
    catch ( Exception ex){
        ex.printStackTrace();
        }
    }

    public static void main (String args[]){
        getDevice();
    }
}