Java: erinevus redaktsioonide vahel
Allikas: Kuutõrvaja
Mine navigeerimisribaleMine otsikasti
| 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 17:32
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