Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package firstconnection;
- import java.sql.Connection;
- import java.sql.DatabaseMetaData;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- import java.util.logging.Level;
- import java.util.logging.Logger;
- public class DB {
- final String JDBC_DRIVER = "org.apache.derby.jdbc.EmbeddedDriver";
- final String URL = "jdbc:derby:sampleDB;create=true";
- final String USERNAME = "";
- final String PASSWORD = "";
- public DB() {
- //Létrehozzuk a kapcsolatot (hidat)
- Connection conn = null;
- //Megpróbáljuk életre kelteni
- try {
- conn = DriverManager.getConnection(URL);
- System.out.println("A híd létrejött");
- } catch (SQLException ex) {
- System.out.println("Valami baj van a connection (híd) létrehozásakor.");
- System.out.println(""+ex);
- }
- // Ha életre kelt csinálunk egy megpakolható teherautót
- Statement createStatement = null;
- if (conn != null) {
- try {
- createStatement = conn.createStatement();
- } catch (SQLException ex) {
- System.out.println("Valami baj van a createStatement (teherautó) létrehozásakor.");
- System.out.println(""+ex);
- }
- }
- //Megnézzük, hogy üres-e az adatbázis?
- DatabaseMetaData dbmd = null;
- try {
- dbmd = conn.getMetaData();
- } catch (SQLException ex) {
- System.out.println("Valami baj van a DatabaseMetaData (adatbázis leírása) létrehozásakor.");
- System.out.println(""+ex);
- }
- try {
- ResultSet rs1 = dbmd.getTables(null, "APP", "USERS", null);
- if (!rs1.next()) {
- createStatement.execute("create table users(name varchar(20), age varchar(20))");
- }
- } catch (SQLException ex) {
- System.out.println("Valami baj van az adattáblák létrehozásakor.");
- System.out.println(""+ex);
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement