Menu



How to Create a database in MySql using JSP code


A database consists of one or more tables.

The CREATE DATABASE statement is used to create a database in MySQL.


The following examples create a database named "test":

create-table.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@ page import="java.sql.*" %>
<html>
<head>
<title>Create a Database using JSP</title>
</head>
<body>
<h1>Create a Database using JSP</h1>
<%
Connection connection = null;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306", "root", "");
Statement statement = connection.createStatement();
String query = "CREATE DATABASE test";
statement.executeUpdate(query);
out.println("Database test created sucessfully.");
}
catch (Exception e)
{
out.println("An error occurred.");
}
%>
</body>
</html>