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 19: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