package CreateDatabase;

//STEP 1. Import required packages
import java.sql.*;

public class CreateDatabase {
	// JDBC driver name and database URL
	static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
	static final String DB_URL = "jdbc:mysql://localhost/EMPLOYEE";
	// Database credentials
	static final String USER = "root";
	static final String PASS = "student";

	public static void main(String[] args) {
		Connection conn = null;
		Statement stmt = null;
		try {
			// STEP 2: Register JDBC driver
			Class.forName("com.mysql.jdbc.Driver");
			// STEP 3: Open a connection
			System.out.println("Connecting to database...");
			conn = DriverManager.getConnection(DB_URL, USER, PASS);
			// STEP 4: Execute a query
			System.out.println("Creating database...");
			stmt = conn.createStatement();
			String sql = "CREATE DATABASE IF NOT EXISTS EMPLOYEE";
			stmt.executeUpdate(sql);
			System.out.println("Database Created");
			sql = "CREATE TABLE IF NOT EXISTS EMP( NAME VARCHAR(20),REGNO CHAR(10),BRANCH VARCHAR(20),EMAIL VARCHAR(50));";
			stmt.executeUpdate(sql);
			System.out.println("Database created successfully...");
			sql = "INSERT INTO STUD VALUES('VENKAT','130911142','IT','venkatrajvanshi@gmail.com')";
			stmt.executeUpdate(sql);
			sql = "INSERT INTO STUD VALUES('SHUBHAM','130911152','IT','shubh95varma@yahoo.co.in')";
			stmt.executeUpdate(sql);
			sql = "INSERT INTO STUD VALUES('RISHABH','130911110','IT','indoria.rishabh5@gmail.com')";
			stmt.executeUpdate(sql);
			System.out.println("Values Entered!");

		} catch (SQLException se) {
			// Handle errors for JDBC
			se.printStackTrace();
		} catch (Exception e) {
			// Handle errors for Class.forName
			e.printStackTrace();
		} finally {
			// finally block used to close resources
			try {
				if (stmt != null)
					stmt.close();
			} catch (SQLException se2) {
			}// nothing we can do
			try {
				if (conn != null)
					conn.close();
			} catch (SQLException se) {
				se.printStackTrace();
			}// end finally try
		}// end try
		System.out.println("Goodbye!");
	}// end main
}// end JDBCExample