
Hello friends.I want to share my jsp problem.I want to show all of my database(mysql) tables except two(user,manufacturer) in a jsp page.plssss help me??

<%@page import="java.sql.*"%>
<%@page import="java.util.*"%>
<%
ArrayList<String> list=new ArrayList<String>();
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql","root", "root");
DatabaseMetaData meta = conn.getMetaData();
ResultSet res = meta.getTables(null, null, "%", null);
String tableNames = "";
while(res.next()){
tableNames = res.getString(3) + " ";
list.add(tableNames);
}
list.remove(list.size()-1);
for(int i=0;i<list.size();i++){
%>
<%=list.get(i).toString()%><br>
<%
}
%>
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.