Admin: 1 версия

2010-06-01T06:12:31Z

1 версия

в 18:01, 31 мая 2010

2010-05-31T18:01:43Z

Новая страница

== Connect to Java DB (Derby) with org.apache.derby.jdbc.EmbeddedDriver ==



<source lang="java">

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
public class JavaDBDemo {
static Connection conn;
public static void main(String[] args) {
String driver = "org.apache.derby.jdbc.EmbeddedDriver";
String connectionURL = "jdbc:derby:myDatabase;create=true";
String createString = "CREATE TABLE Employee (NAME VARCHAR(32) NOT NULL, ADDRESS VARCHAR(50) NOT NULL)";
try {
Class.forName(driver);
} catch (java.lang.ClassNotFoundException e) {
e.printStackTrace();
}
try {
conn = DriverManager.getConnection(connectionURL);
Statement stmt = conn.createStatement();
stmt.executeUpdate(createString);
PreparedStatement psInsert = conn.prepareStatement("insert into Employee values (?,?)");
psInsert.setString(1, args[0]);
psInsert.setString(2, args[1]);
psInsert.executeUpdate();
Statement stmt2 = conn.createStatement();
ResultSet rs = stmt2.executeQuery("select * from Employee");
int num = 0;
while (rs.next()) {
System.out.println(++num + ": Name: " + rs.getString(1) + "\n Address" + rs.getString(2));
}
rs.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
</source>



== Derby ISQL ==

== Derby JDBC Connection ==



<source lang="java">
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
public class MainClass {
public static void main(String[] args)
{
try {
String driver = "org.apache.derby.jdbc.EmbeddedDriver";
Class.forName(driver).newInstance();
Connection conn = null;
conn = DriverManager.getConnection("jdbc:derby:DerbyTestDB");
Statement s = conn.createStatement();
ResultSet rs = s.executeQuery("SELECT city, state, zipcode FROM zipcodes");
while(rs.next()) {
System.out.println("City : "+ rs.getString(1));
System.out.println("State : "+ rs.getString(2));
System.out.println("Zipcode: "+ rs.getString(3));
System.out.println();
}
rs.close();
s.close();
conn.close();
} catch(Exception e) {
System.out.println("Exception: "+ e);
e.printStackTrace();
}
}
}

</source>

← Предыдущая	Версия 06:12, 1 июня 2010
(нет различий)

Java/JDK 6/Java DB Derby - История изменений

Admin: 1 версия

в 18:01, 31 мая 2010