import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
// —
public class CriarTabela {
/**
* @param args
*/
public static void main(String[] args) {
Connection con = null;
Statement st = null;
try {
con = DBConnection.getConnection();
st = con.createStatement();
int r = 0;
try {
r = st.executeUpdate("CREATE TABLE TRANSPORTADORA "
+ "(EMPRESA VARCHAR(30),CNPJ INTEGER(20)PRIMARY KEY,"
+ "ENDERECO VARCHAR(30) , TELEFONE_COMERCIAL INTEGER(8),TELEFONE_CELULAR INTEGER (8)");
} catch (SQLException e) {
System.out.println("Tabela");
}
System.out.println("r = " + r);
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBConnection.closeStatement(st);
DBConnection.closeConnection(con);
}
}
}