Java Reference
In-Depth Information
import java.sql.SQLException;
import java.sql.Statement;
class EmployeeDB
{
public static void main(String[] args)
{
String url = "jdbc:derby:employee;create=true";
try
(Connection
con
=
DriverMan-
ager.getConnection(url))
{
try (Statement stmt = con.createStatement())
{
String
sql
=
"CREATE
TABLE
EMPLOYEES(ID
INTEGER, NAME VARCHAR(30))";
stmt.executeUpdate(sql);
sql = "INSERT INTO EMPLOYEES VALUES(1, 'John
Doe')";
stmt.executeUpdate(sql);
sql = "INSERT INTO EMPLOYEES VALUES(2, 'Sally
Smith')";
stmt.executeUpdate(sql);
ResultSet rs = stmt.executeQuery("SELECT * FROM
EMPLOYEES");
while (rs.next())
System.out.println(rs.getInt("ID")+"
"+rs.getString("NAME"));
sql = "DROP TABLE EMPLOYEES";
stmt.executeUpdate(sql);
}
}
catch (SQLException sqlex)
{
while (sqlex != null)
{
System.err.println("SQL
error
:
