Hola muchachos necesito saber como creo en el mismo archivo 2 tablas diferentes
gracias si me pueden ayudar se lo agradeceria mucho.Las tablas son locate y cd.
Esto es lo que tengo:
import java.sql.*;
public class MyOwnJDBCProgram {
/**
* @param args the command line arguments
*/
public static void main(String[] args) {
String url = "jdbc:derby://localhost:1527/sample";
Connection con;
String createString;
createString = "create table location " +
"(Location_id, Integer not NULL PRIMARY KEY, " +
"Location VARCHAR(40))";
Statement stmt;
try {
// Load database driver. This is old method of loading
// database driver.
Class.forName("org.apache.derby.jdbc.ClientDriver" );
} catch(java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
}
try {
// Create database connection
con = DriverManager.getConnection(url,
"app", "app");
// Create a statement and execute it
stmt = con.createStatement();
stmt.executeUpdate(createString);
// If there is no exception, the COFFEES table must be successfully created
System.out.println("location table is successfully created");
stmt.close();
con.close();
} catch(SQLException ex) {
System.err.println("SQLException: " + ex.getMessage());
}
/** Connection con1;
String createString1;
createString1 = "create table cd " +
"(cd_id, integer not null primary key, +
"title varchar(40),
"author varchar(40),
"year_created integer,
"location integer,
"rating integer,
//CONSTRAINT FK_CD_LOCATION FOREIGN KEY (LOCATION) REFERENCES LOCATION(LOCATION_ID))";
Statement stmt1;
try {
// Load database driver. This is old method of loading
// database driver.
Class.forName("org.apache.derby.jdbc.ClientDriver" );
} catch(java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
}
try {
// Create database connection
con1 = DriverManager.getConnection(url,
"app", "app");
// Create a statement and execute it
stmt1 = con1.createStatement();
stmt1.executeUpdate(createString1);
// If there is no exception, the COFFEES table must be successfully created
System.out.println("cd table is successfully created");
// Close statement and connection
stmt1.close();
con1.close();
} catch(SQLException ex) {
System.err.println("SQLException: " + ex.getMessage());
}
//createString1= "create table cd " +
//"(cd_id, integer not null primary key, +
//"title varchar(40),
//"author varchar(40),
//"year_created integer,
//"location integer,
//"rating integer,
//CONSTRAINT FK_CD_LOCATION FOREIGN KEY (LOCATION) REFERENCES LOCATION(LOCATION_ID))";
*/
}
}
