工具類：檢查數據庫表是否存在某一列

2019-11-08 02:34:19

字體：大中小

來源：轉載

供稿：網友

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; } }}

上一篇：GPS讀書筆記-from2/18/2017-2/21/2017

下一篇：Spring @Resource、@Autowired、@Qualifier的注解注入及區別