检测数据库中是否存在某一张表

来源：互联网发布：php错误日志编辑：程序博客网时间：2024/05/22 12:23
import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class MysqlTest1 {public static void main(String[] args) throws Exception {testPrepareStatement("test");}public static void testPrepareStatement(String tableName) {Connection conn = getConnection();PreparedStatement ps = null;try {String sql = "show tables from test like '"+tableName+"'";ps = conn.prepareStatement(sql);ResultSet rs = ps.executeQuery();boolean isTableExist = rs.first();System.out.println(isTableExist);} catch (Exception e) {e.printStackTrace();} finally {close(conn);}}public static Connection getConnection() {Connection conn = null;try {Class.forName("com.mysql.jdbc.Driver");String url = "jdbc:mysql://localhost:3306/test?characterEncoding=utf-8";conn = DriverManager.getConnection(url, "root", "test");} catch (Exception e) {e.printStackTrace();}return conn;}public static void close(Connection conn,Statement st) {if(conn!=null) {try {conn.close();} catch (SQLException e) {e.printStackTrace();}}if(st!=null) {try {st.close();} catch (SQLException e) {e.printStackTrace();}}}public static void close(Connection conn) {if(conn!=null) {try {conn.close();} catch (SQLException e) {e.printStackTrace();}}}public static void close(Statement st) {if(st!=null) {try {st.close();} catch (SQLException e) {e.printStackTrace();}}}}
0 0