Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ID: 1, name: Zenon, surname: Martyniuk, group: 2
- ID: 2, name: Bartłomiej, surname: Misiewicz, group: 4
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.Statement;
- public class Main {
- public static void main(String[] args) {
- // TODO Auto-generated method stub
- String DB_URL = "jdbc:mysql://ricky.heliohost.org/cackoa_database";
- String USER = "cackoa_user";
- String PASS = "cackoa_password";
- try(Connection conn = DriverManager.getConnection(DB_URL, USER, PASS))
- {
- Statement stmnt = conn.createStatement();
- String query = "SELECT * FROM student LIMIT 2";
- ResultSet rs = stmnt.executeQuery(query);
- while(rs.next())
- {
- System.out.print("ID: " + rs.getInt("id"));
- System.out.print(", name: " + rs.getString("name"));
- System.out.print(", surname: " + rs.getString("surname"));
- System.out.println(", group: " + rs.getInt("student_group"));
- }
- }
- catch(Exception ex)
- {
- System.out.println(ex.getMessage());
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement