Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package app;
- import java.sql.*;
- public class appp {
- public static void main(String[] args) {
- String user="SYS";
- String pass="12345";
- Connection conn= null;
- try {
- Class.forName("oracle.jdbc.driver.OracleDriver");
- System.out.println("Nawiazujemy polaczenie");
- conn = DriverManager.getConnection("jdbc:oracle:thin:SYS@//localhost:1521/xe", "SYS as SYSDBA", "12345" );
- Statement a = conn.createStatement();
- ResultSet res = a.executeQuery("select * from pracownik");
- while(res.next()) {
- for(int i=0;i<5;i++) {
- System.out.print(res.getString(i+1)+"\t");
- }
- }
- }
- catch (ClassNotFoundException e) {
- System.out.println("Nie mozna pobrac sterownika");
- } catch (SQLException e) {
- System.out.println("Nie mozna polaczyc z baza danych" + e);
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement