//STEP 1. Import required packages
import java.sql.*;
public class JDBCExample {
// JDBC driver name and database URL
static final String JDBC_DRIVER
= "com.mysql.jdbc.Driver"; static final String DB_URL
= "jdbc:mysql://localhost/";
// Database credentials
static final String USER
= "username"; static final String PASS
= "password";
public static void main
(String[] args
) { try{
//STEP 2: Register JDBC driver
Class.forName("com.mysql.jdbc.Driver");
//STEP 3: Open a connection
System.
out.
println("Connecting to database...");
//STEP 4: Execute a query
System.
out.
println("Creating database..."); stmt = conn.createStatement();
String sql
= "CREATE DATABASE STUDENTS"; stmt.executeUpdate(sql);
System.
out.
println("Database created successfully..."); //Handle errors for JDBC
se.printStackTrace();
//Handle errors for Class.forName
e.printStackTrace();
}finally{
//finally block used to close resources
try{
if(stmt!=null)
stmt.close();
}// nothing we can do
try{
if(conn!=null)
conn.close();
se.printStackTrace();
}//end finally try
}//end try
System.
out.
println("Goodbye!"); }//end main
}//end JDBCExample
Ly9TVEVQIDEuIEltcG9ydCByZXF1aXJlZCBwYWNrYWdlcwppbXBvcnQgamF2YS5zcWwuKjsKCnB1YmxpYyBjbGFzcyBKREJDRXhhbXBsZSB7CiAgIC8vIEpEQkMgZHJpdmVyIG5hbWUgYW5kIGRhdGFiYXNlIFVSTAogICBzdGF0aWMgZmluYWwgU3RyaW5nIEpEQkNfRFJJVkVSID0gImNvbS5teXNxbC5qZGJjLkRyaXZlciI7ICAKICAgc3RhdGljIGZpbmFsIFN0cmluZyBEQl9VUkwgPSAiamRiYzpteXNxbDovL2xvY2FsaG9zdC8iOwoKICAgLy8gIERhdGFiYXNlIGNyZWRlbnRpYWxzCiAgIHN0YXRpYyBmaW5hbCBTdHJpbmcgVVNFUiA9ICJ1c2VybmFtZSI7CiAgIHN0YXRpYyBmaW5hbCBTdHJpbmcgUEFTUyA9ICJwYXNzd29yZCI7CiAgIAogICBwdWJsaWMgc3RhdGljIHZvaWQgbWFpbihTdHJpbmdbXSBhcmdzKSB7CiAgIENvbm5lY3Rpb24gY29ubiA9IG51bGw7CiAgIFN0YXRlbWVudCBzdG10ID0gbnVsbDsKICAgdHJ5ewogICAgICAvL1NURVAgMjogUmVnaXN0ZXIgSkRCQyBkcml2ZXIKICAgICAgQ2xhc3MuZm9yTmFtZSgiY29tLm15c3FsLmpkYmMuRHJpdmVyIik7CgogICAgICAvL1NURVAgMzogT3BlbiBhIGNvbm5lY3Rpb24KICAgICAgU3lzdGVtLm91dC5wcmludGxuKCJDb25uZWN0aW5nIHRvIGRhdGFiYXNlLi4uIik7CiAgICAgIGNvbm4gPSBEcml2ZXJNYW5hZ2VyLmdldENvbm5lY3Rpb24oREJfVVJMLCBVU0VSLCBQQVNTKTsKCiAgICAgIC8vU1RFUCA0OiBFeGVjdXRlIGEgcXVlcnkKICAgICAgU3lzdGVtLm91dC5wcmludGxuKCJDcmVhdGluZyBkYXRhYmFzZS4uLiIpOwogICAgICBzdG10ID0gY29ubi5jcmVhdGVTdGF0ZW1lbnQoKTsKICAgICAgCiAgICAgIFN0cmluZyBzcWwgPSAiQ1JFQVRFIERBVEFCQVNFIFNUVURFTlRTIjsKICAgICAgc3RtdC5leGVjdXRlVXBkYXRlKHNxbCk7CiAgICAgIFN5c3RlbS5vdXQucHJpbnRsbigiRGF0YWJhc2UgY3JlYXRlZCBzdWNjZXNzZnVsbHkuLi4iKTsKICAgfWNhdGNoKFNRTEV4Y2VwdGlvbiBzZSl7CiAgICAgIC8vSGFuZGxlIGVycm9ycyBmb3IgSkRCQwogICAgICBzZS5wcmludFN0YWNrVHJhY2UoKTsKICAgfWNhdGNoKEV4Y2VwdGlvbiBlKXsKICAgICAgLy9IYW5kbGUgZXJyb3JzIGZvciBDbGFzcy5mb3JOYW1lCiAgICAgIGUucHJpbnRTdGFja1RyYWNlKCk7CiAgIH1maW5hbGx5ewogICAgICAvL2ZpbmFsbHkgYmxvY2sgdXNlZCB0byBjbG9zZSByZXNvdXJjZXMKICAgICAgdHJ5ewogICAgICAgICBpZihzdG10IT1udWxsKQogICAgICAgICAgICBzdG10LmNsb3NlKCk7CiAgICAgIH1jYXRjaChTUUxFeGNlcHRpb24gc2UyKXsKICAgICAgfS8vIG5vdGhpbmcgd2UgY2FuIGRvCiAgICAgIHRyeXsKICAgICAgICAgaWYoY29ubiE9bnVsbCkKICAgICAgICAgICAgY29ubi5jbG9zZSgpOwogICAgICB9Y2F0Y2goU1FMRXhjZXB0aW9uIHNlKXsKICAgICAgICAgc2UucHJpbnRTdGFja1RyYWNlKCk7CiAgICAgIH0vL2VuZCBmaW5hbGx5IHRyeQogICB9Ly9lbmQgdHJ5CiAgIFN5c3RlbS5vdXQucHJpbnRsbigiR29vZGJ5ZSEiKTsKfS8vZW5kIG1haW4KfS8vZW5kIEpEQkNFeGFtcGxl