Guest User

Untitled

a guest
Feb 8th, 2017
44
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.75 KB | None | 0 0
  1. String DBName = request.getParameter("dbname");
  2.  
  3. String myDriver = "com.mysql.jdbc.Driver";
  4. String DriverUrl = "jdbc:mysql://localhost/";
  5. Class.forName(myDriver);
  6. System.out.println("\nDriver loaded successfully");
  7.  
  8. Connection conn = DriverManager.getConnection(DriverUrl, "root","");
  9. System.out.println("\nConnection is established");
  10. Statement st = conn.createStatement();
  11. String CreateDB;
  12. CreateDB = "CREATE DATABASE IF NOT EXISTS " + DBName;
  13. st.execute(CreateDB);
  14. String SelectDB = "use "+DBName.toLowerCase();
  15. System.out.println("DBNAME" + SelectDB);
  16. st.execute(SelectDB);
Add Comment
Please, Sign In to add comment