
how to take input table name in jsp to create table in mysql?

Hello Friend,
Try the following code:
<%@page import="java.sql.*"%>
<form method="post">
Enter Table Name:<input type="text" name="table"><input type="submit" value="Create Table">
</form>
<%
String tab=request.getParameter("table");
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql", "root", "root");
Statement st = con.createStatement();
String table = "CREATE TABLE "+tab+"(id integer, name varchar(100), address varchar(100))";
System.out.println(table);
st.executeUpdate(table);
out.println("Table is created successfully!");
}
catch (Exception e){
e.printStackTrace();
}
%>
Thanks
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.