Erinevus lehekülje "Java" redaktsioonide vahel
Allikas: Kuutõrvaja
(→Kasulikud lisamaterjalid) |
(→Ühendus andmebaasiga) |
||
27. rida: | 27. rida: | ||
Hello, World | Hello, World | ||
− | ===Ühendus andmebaasiga=== | + | ===Ühendus PostgreSQL andmebaasiga=== |
− | + | $ cat HelloPostgresql.java | |
+ | import java.sql.*; | ||
+ | import java.sql.DriverManager; | ||
+ | import java.sql.SQLException; | ||
+ | import java.net.*; | ||
+ | |||
+ | public class HelloPostgresql | ||
+ | { | ||
+ | public static void main(String args[]) throws SQLException { | ||
+ | Connection con = null; | ||
+ | try { | ||
+ | Class.forName("org.postgresql.Driver"); | ||
+ | con = DriverManager.getConnection("jdbc:postgresql://127.0.0.1/test", "priit", "parool"); | ||
+ | Statement st = con.createStatement(); | ||
+ | ResultSet rs = st.executeQuery("SELECT * FROM priit.inimene"); | ||
+ | while(rs.next()) { | ||
+ | System.out.println(rs.getString("nimi")); | ||
+ | } | ||
+ | } catch (Exception e) { | ||
+ | e.printStackTrace(); | ||
+ | } finally { | ||
+ | if(con != null) { | ||
+ | con.close(); | ||
+ | } | ||
+ | } | ||
+ | } | ||
+ | } | ||
+ | |||
+ | Kompileerimiseks | ||
+ | |||
+ | $ export CLASSPATH=postgresql-8.4-701.jdbc3.jar:. | ||
+ | $ javac HelloPostgresql.java | ||
+ | |||
+ | Käivitamiseks | ||
+ | |||
+ | $ java HelloPostgresql | ||
===Kasulikud lisamaterjalid=== | ===Kasulikud lisamaterjalid=== |
Redaktsioon: 2. aprill 2010, kell 20:32
Sisukord
Sissejuhatus
TODO
Java paigaldamine
TODO
Java kasutamine
Lähtetekst
$ cat HelloWorld.java public class HelloWorld { public static void main(String[] args) { System.out.println("Hello, World"); } }
Kompileerimine, tekib fail HelloWorld.class
$ javac HelloWorld.java
Käivitamine
$ java HelloWorld Hello, World
Ühendus PostgreSQL andmebaasiga
$ cat HelloPostgresql.java import java.sql.*; import java.sql.DriverManager; import java.sql.SQLException; import java.net.*; public class HelloPostgresql { public static void main(String args[]) throws SQLException { Connection con = null; try { Class.forName("org.postgresql.Driver"); con = DriverManager.getConnection("jdbc:postgresql://127.0.0.1/test", "priit", "parool"); Statement st = con.createStatement(); ResultSet rs = st.executeQuery("SELECT * FROM priit.inimene"); while(rs.next()) { System.out.println(rs.getString("nimi")); } } catch (Exception e) { e.printStackTrace(); } finally { if(con != null) { con.close(); } } } }
Kompileerimiseks
$ export CLASSPATH=postgresql-8.4-701.jdbc3.jar:. $ javac HelloPostgresql.java
Käivitamiseks
$ java HelloPostgresql