Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package com.company;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.util.Properties;
- public class Main {
- public static void main(String[] args) {
- String url = "jdbc:oracle:thin:@//asterix.fri.uniza.sk:1521/orcl.fri.uniza.sk";
- try {
- Properties props = new Properties();
- props.setProperty("user", "kubala25");
- props.setProperty("password", "9505058662");
- Connection conn = DriverManager.getConnection(url,props);
- String sql ="SELECT * FROM os_udaje";
- PreparedStatement preStatement = conn.prepareStatement(sql);
- ResultSet result = preStatement.executeQuery();
- System.out.println("RODNE CISLO MENO PRIEZVISKO ULICA PSC OBEC");
- System.out.println("------------------------------------------------------------------------------------------");
- while(result.next()){
- System.out.print(result.getString("rod_cislo") + " ");
- System.out.print(result.getString("meno"));
- for (int i = 0; i < 20 - result.getString("meno").length(); i++) {
- System.out.print(" ");
- }
- System.out.print(result.getString("priezvisko"));
- for (int i = 0; i < 20 - result.getString("priezvisko").length(); i++) {
- System.out.print(" ");
- }
- System.out.print(result.getString("ulica"));
- for (int i = 0; i < 20 - result.getString("ulica").length(); i++) {
- System.out.print(" ");
- }
- System.out.print(result.getString("psc") + " ");
- System.out.print(result.getString("obec"));
- for (int i = 0; i < 20 - result.getString("obec").length(); i++) {
- System.out.print(" ");
- }
- System.out.println();
- }
- } catch (Exception ex) {
- ex.printStackTrace();
- }
- // CTRL + SHIFT + ALT + S --> pridat kniznicu - ojdbc6-12.1.0.2.jar
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement