Advertisement
Guest User

lab database

a guest
Feb 24th, 2019
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.91 KB | None | 0 0
  1. package database;
  2.  
  3. import java.sql.*;
  4. public class Database {
  5.  
  6.     public static void main(String[] args) {
  7.  
  8.         String url = "jdbc:mysql://localhost/info";
  9.         String user = "root";
  10.         String password = "root";
  11.         try {
  12.             Connection con = DriverManager.getConnection(url, user, password);
  13.             Statement state = con.createStatement();
  14.             ResultSet result = state.executeQuery("Select * from student");
  15.             while (result.next()) {
  16.                 System.out.println("Id : " + result.getString("id"));
  17.                 System.out.println("Name: " + result.getString("name"));
  18.                 System.out.println("Semester : " + result.getString("semester"));
  19.                 System.out.println("");
  20.             }
  21.         } catch (Exception ex) {
  22.             ex.printStackTrace();
  23.             System.out.println("Cause : " + ex.getCause());
  24.         }
  25.     }
  26.  
  27. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement