java连接JDBC和数据库连接池

最新推荐文章于 2024-07-18 16:09:33 发布

dareu_4523

最新推荐文章于 2024-07-18 16:09:33 发布

阅读量128

点赞数

分类专栏： Java 文章标签： java mysql 开发语言

本文链接：https://blog.csdn.net/weixin_46028606/article/details/121190806

版权

Java 专栏收录该内容

60 篇文章 3 订阅

订阅专栏

package MySQL_Base_Operation;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;

public class MySQL {
    public static Connection connection;
    public static Statement statement;

    static {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            connection = java.sql.DriverManager.getConnection("jdbc:mysql://127.0.0.1/temp", "root", "12345678");
            statement = connection.createStatement();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public static void showDatabases(String sql) {
        try {
            ResultSet rs = statement.executeQuery(sql);
            final int col_count = rs.getMetaData().getColumnCount();
            while (rs.next()) {
                for (int i = 1; i <= col_count; i++) {
                    System.out.printf("%30s", rs.getString(i));
                }
                System.out.println();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public static void handleSQL(String sql) {
        int count = -1;
        try {
            if (sql.contains("show databases")) {

                showDatabases(sql);
                System.out.println("Query OK.");

            } else if (sql.contains("update") || sql.contains("insert") || sql.contains("delete")) {

                count = statement.executeUpdate(sql);
                System.out.println("Query OK." + count + "rows affected.");

            } else if (sql.contains("use")) {

                statement.execute(sql);
                System.out.println("Database changed.");

            } else if (sql.contains("select") || sql.contains("show")) {

                ResultSet rs = statement.executeQuery(sql);
                final int col_count = rs.getMetaData().getColumnCount();
                for (int i = 1; i <= col_count; i++) {
                    System.out.printf("%32s", rs.getMetaData().getColumnName(i));
                }
                System.out.println();
                while (rs.next()) {
                    for (int i = 1; i <= col_count; i++) {
                        System.out.printf("%32s", rs.getString(i));
                    }
                    System.out.println();
                }

            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public static void main(String[] args) {
        Scanner sc = new Scanner(System.in);
        while (sc.hasNextLine()) {
            String line = sc.nextLine();
            if (line != null && !line.equals("")) {
                handleSQL(line);
            }
        }
    }
}