java ee - how to create mysql database using servlet please give some basic ideas -

java ee - how to create mysql database using servlet please give some basic ideas -

i working on lastly year project. want connect mysql database using jdbc, please 1 give me basic thought regarding how create mysql database using servlet

create static variables likebelow in class

// jdbc driver name , 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";

and phone call createdb method based on doget or dopost

public static void createdb() { connection conn = null; statement stmt = null; try{ //step 2: register jdbc driver class.forname("com.mysql.jdbc.driver"); //step 3: open connection system.out.println("connecting database..."); conn = drivermanager.getconnection(db_url, user, pass); //step 4: execute query system.out.println("creating database..."); stmt = conn.createstatement(); string sql = "create database students"; stmt.executeupdate(sql); system.out.println("database created successfully..."); }catch(sqlexception se){ //handle errors jdbc se.printstacktrace(); }catch(exception e){ //handle errors class.forname e.printstacktrace(); }finally{ //finally block used close resources try{ if(stmt!=null) stmt.close(); }catch(sqlexception se2){ }// nil can try{ if(conn!=null) conn.close(); }catch(sqlexception se){ se.printstacktrace(); }//end seek }//end seek system.out.println("goodbye!"); }//end main }//end jdbcexample

mysql java-ee servlets