java mysql gettables,使用Java和MySQL显示表格？

最新推荐文章于 2023-04-04 00:36:02 发布

Reimu Hakurei

最新推荐文章于 2023-04-04 00:36:02 发布

阅读量78

点赞数

文章标签： java mysql gettables

本文介绍了一种使用Java动态生成SQL查询的方法，并提供了一个更优雅的解决方案来避免SQL语法错误。通过使用DatabaseMetaData API，可以有效地进行表名模式匹配，避免了直接在SQL字符串中拼接变量可能导致的问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

i have some jsp file. it has some variables. i want to use these varibles inside a mysql query as follows.

String given_session="monsoon";

String given_year="2012";

// note above two will be dynamically added.

ResultSet rs11 = (ResultSet) st11.executeQuery("show tables like '%_Assessment_" + given_session + "_" + given_year+"'");

I got the following exception :

java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%_Assessment_Monsoon_2013''

解决方案

There is a better and more elegant way.

String tableNamePattern = "%_Assessment_" + session + "_" + year;

DatabaseMetaData databaseMetaData = conn.getMetaData();

ResultSet rs = databaseMetaData.getTables(null, null, tableNamePattern,

null);

while(rs.next()) {

String tableName = rs.getString("TABLE_NAME");

...

}

Moreover, you must know the best practices of programming in Java because what you are using in your code is not smart. You can see a lot in Java Collected Practices.