import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
/**
* 功能说明:检查数据库表是否存在某一列
* @author LZG
*
*/
public class ColumnUtil {
public boolean checkTableColumn(String tableName, String columnName) {
// ========================A开始=============
Connection conn = null;
String className = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
String user = "onepiece";
String password = "luffy";
// ========================A结束==============
Statement stm = null;
ResultSet rs = null;
ResultSetMetaData rsmd = null;
// 数据库列字段的List集合
List<String> tableColumnList = new ArrayList<String>();
try {
Class.forName(className);
conn = DriverManager.getConnection(url, user, password);
stm = conn.createStatement();
rs = stm.executeQuery("select * from " + tableName);
rsmd = rs.getMetaData();
int columnCount = rsmd.getColumnCount();
for (int i = 1; i <= columnCount; i++) {
tableColumnList.add(rsmd.getColumnName(i));
}
if (null != stm) {
stm.close();
}
if (null != conn) {
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
if (!tableColumnList.contains(columnName)) {
return false;
} else {
return true;
}
}
}
工具类:检查数据库表是否存在某一列
最新推荐文章于 2021-08-17 17:03:53 发布