How can I create MySQL table that contain two columns? [closed]

by

First you are gonna have to connect to the database, and then you can excecute queries:

 System.out.println("Table Creation Example!");
 Connection con = null;
 String url = "jdbc:mysql://localhost:3306/";
 String dbName = "jdbctutorial";
 String driverName = "com.mysql.jdbc.Driver";
 String userName = "root";
 String password = "root";
 String column1 = "nameOfTheFirstColumn";
 String column2 = "nameOfTheSecondColumn";

 try{
  Class.forName(driverName).newInstance();
 con = DriverManager.getConnection(url+dbName, userName, password);
 try{
  Statement st = con.createStatement();
  String table = 
  "CREATE TABLE Employee11(column1 + " varchar(10), + column2 + "Emp_name varchar(10))";
  st.executeUpdate(table);
  System.out.println("Table creation process successfully!");
  }
  catch(SQLException s){
  System.out.println("Table all ready exists!");
  }
  con.close();
  }
  catch (Exception e){
  e.printStackTrace();
  }

Adapted from this source.

More Related Contents:

  1. Diamond with a blank space inside
  2. What is the difference between a static method and a non-static method?
  3. How to secure an API REST for mobile app? (if sniffing requests gives you the “key”)
  4. How do I return a boolean from AsyncTask?
  5. Auto errors detection in IntelliJ IDEA
  6. Why would one declare an immutable class final in Java?
  7. Why java.util.Optional is not Serializable, how to serialize the object with such fields
  8. MVC Progress Bar Threading
  9. Java FileOutputStream Create File if not exists
  10. Meaning of delta or epsilon argument of assertEquals for double values
  11. How to use conditional breakpoint in Eclipse?
  12. Advantage of set and get methods vs public variable [duplicate]
  13. Java JSON serialization – best practice
  14. Why are wait() and notify() declared in Java’s Object class?
  15. How do you get the selected value of a Spinner?
  16. Java Generic Class – Determine Type
  17. Why does Java throw NullPointerException here?
  18. Eclipse comment/uncomment shortcut?
  19. Divide elements on groups in RecyclerView or Grouping Recyclerview items ,say by date
  20. ANDROID: Parsing XML
  21. When running the program in netBeans the font looks extremely weird
  22. How to continue execution when Assertion is failed
  23. How to get list of all window handles in Java (Using JNA)?
  24. How do I convert from YAML to JSON in Java?
  25. Explanation on Integer.MAX_VALUE and Integer.MIN_VALUE to find min and max value in an array
  26. What are mark and reset in BufferedReader?
  27. Using ‘==’ instead of .equals for Java strings [duplicate]
  28. Error inflating class android.support.design.widget.TabLayout
  29. Multiple install:install-file in a single pom.xml
  30. Java SimpleDateFormat pattern for W3C XML dates with timezone [duplicate]

Leave a Comment