but it's pretty easy. As I recall, if you execute that query, the PHP query result accessing functions that would normally give you a key-value pair will have the column names as the keys. But it's been a while since
下面是一种常用的方法: importjava.sql.*;importjava.util.ArrayList;importjava.util.List;publicclassMySQLColumnNames{publicstaticList<String>getColumnNames(StringtableName){List<String>columnNames=newArrayList<>();try(Connectionconnection=MySQLConnection.getConnection()){DatabaseMetaDatametaData=connection.getMe...
* @return */publicstaticList<String>getColumnNames(StringtableName){List<String>columnNames=newArrayList<>();//与数据库的连接Connectionconn=getConnection();PreparedStatementpStemt=null;StringtableSql=SQL+tableName;try{pStemt=conn.prepareStatement(tableSql);//结果集元数据ResultSetMetaDatarsmd=pStemt.get...
PAY_TYPE.put(tableName,newArrayList()); } resultSet.close(); // --- LISTING DATABASE COLUMN NAMES --- DatabaseMetaDatameta=conn.getMetaData(); Iteratoriiiiii=PAY_TYPE.keySet().iterator(); while(iiiiii.hasNext()) { StringtempTable=iiiiii.next(); resultSet=meta.getColumns(databaseName,nu...
> a way I can display WHICH field or column names the query did or did not match on? USE test; DROP TABLE IF EXISTS foo; CREATE TABLE foo ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, field1 CHAR(20), field2 CHAR(20) ); ...
Hello, I'm trying to get column names from a mySql database table in a single column with the columns names. I have a script working in dbVizualizer: - 848313
.getTables(databaseName,null, "%", types); String tableName= "";while(resultSet.next()) { tableName= resultSet.getString(3); log.info("Table Name = " +tableName); } resultSet.close();//--- LISTING DATABASE COLUMN NAMES ---DatabaseMetaData meta =conn.getMetaData(); ...
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有...
import java.sql.*; public class GetFieldNames { public static void main(String[] args) { String url = "jdbc:mysql://localhost:3306/mydatabase"; String user = "username"; String password = "password"; try (Connection conn = DriverManager.getConnection(url, user, password); Statement stmt...
Written By Posted How to get names of columns in query mitesh shah May 27, 2012 06:58AM Re: How to get names of columns in query laptop alias May 28, 2012 01:46AM Sorry, you can't reply to this topic. It has been closed....