国产av日韩一区二区三区精品,成人性爱视频在线观看,国产,欧美,日韩,一区,www.成色av久久成人,2222eeee成人天堂

Home 類庫(kù)下載 java類庫(kù) How to use embedded MySQL in Java

How to use embedded MySQL in Java

Nov 07, 2016 pm 05:30 PM
java mysql Embed

這篇文件主要介紹在Java中嵌入式MySQL的使用,對(duì)于一些的應(yīng)用項(xiàng)目,提供安裝版的Mysql,Oracle是必須的工作。但是有時(shí)候如果是一個(gè)小的工具,可安裝或者移植性比較強(qiáng)的小軟件。再去安裝數(shù)據(jù)庫(kù)可能就比較麻煩了。

其實(shí)MySQL也有嵌入式的,不需要安裝,在使用的過(guò)程中,會(huì)自動(dòng)創(chuàng)建數(shù)據(jù)庫(kù)以及通過(guò)代碼的方式啟動(dòng)或者關(guān)閉。下面提供一些代碼片段,具體的會(huì)提供下載地址。

這個(gè)是核心代碼類,這個(gè)類實(shí)現(xiàn)了Mysql 的啟動(dòng)和停止以及數(shù)據(jù)庫(kù)的啟動(dòng)狀態(tài)。

package net.simple.mysql;

import java.io.File;
import java.util.HashMap;
import java.util.Map;
import java.util.Properties;
import java.util.Set;

import com.mysql.management.MysqldResource;

public final class EmbedMySqlServer {
    private MysqldResource mysqlInstance;
    //配置信息
    public final Properties props;
    //端口信息
    private String port;
    /**
     * 考慮到數(shù)據(jù)庫(kù)的性能問題,允許將數(shù)據(jù)庫(kù)放在其它磁盤
     */
    private String embedMySqlHome;

    public EmbedMySqlServer(final Properties props) {
        this.props = props;
    }

    public EmbedMySqlServer(final Properties props, String embedMySqlHome) {
        this.embedMySqlHome = embedMySqlHome;
        this.props = props;
    }

    public final String getEmbedMySqlHome() {
        return null == embedMySqlHome ? getPlatformBaseDir() : embedMySqlHome;
    }

    /**
    * 獲得當(dāng)前應(yīng)用主目錄
    * @return 當(dāng)前應(yīng)用啟動(dòng)程序所在目錄.
    */
    public static String getPlatformBaseDir() {
        return System.getProperty("user.dir");
    }

    public static boolean isBlank(final String str) {
        int strLen;
        if (str == null || (strLen = str.length()) == 0) {
            return true;
        }
        for (int i = 0; i < strLen; i++) {
            if (Character.isWhitespace(str.charAt(i)) == false) {
                return false;
            }
        }
        return true;
    }

    public void startup() {
        final File baseDir = new File(getEmbedMySqlHome(), "mysql-em");
        mysqlInstance = new MysqldResource(baseDir);
        port = props.getProperty("port");
        if (isBlank(port))
            props.put("port", port = String.valueOf((int) (Math.random() * 40000)));
        final Set<Object> keys = props.keySet();
        final Map<String, String> options = new HashMap<String, String>(keys.size());
        for (final Object key : keys) {
            final String val = props.getProperty(key.toString());
            if ("".equals(val))
                options.put(key.toString(), null);
            else
                options.put(key.toString(), val.replace("{$contextPath}", getPlatformBaseDir()));
        }
        if (!mysqlInstance.isRunning())
            mysqlInstance.start("Em_MySQL", options, false, keys.contains("defaults-file"));
    }

    public String getPort() {
        return port;
    }

    /**
     * 判斷mysql是否正在運(yùn)行
     */
    public boolean isRunning() {
        return null == mysqlInstance ? false : mysqlInstance.isRunning();
    }

    public void shutdown() {
        if (mysqlInstance != null)
            mysqlInstance.shutdown();
    }

    public void cleanup() {
        if (mysqlInstance != null)
            mysqlInstance.cleanup();
    }
}

下面這個(gè)是啟動(dòng)Demo,

public static void main(String[] args) {
        try {
            Properties pro = new Properties();
            //根據(jù)機(jī)器配置,設(shè)置不同的參數(shù)
            pro.load(MysqlTest.class.getResourceAsStream("MySql_medium.properties"));
            new EmbedMySqlServer(pro).startup();
            //可以把數(shù)據(jù)庫(kù)放到其他磁盤
            //new EmbedMySqlServer(pro,"f:\\").startup();
            Connection conn = getTestConnection();
            System.out.println(conn.isClosed());
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

MySql_general.properties一般機(jī)器的配置樣例

MySql_medium.properties中等機(jī)器的配置樣例

MySql_large.properties高配機(jī)的配置樣例

具體的參數(shù)可以根據(jù)不同需求進(jìn)行定義,比如端口可以自由定義。

需要引用的mysql兩個(gè)jar,mysql-connector-mxj-gpl-6-0-11-db-files.jar,mysql-connector-mxj-gpl-6-0-11.jar

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undress AI Tool

Undress AI Tool

Undress images for free

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

PHP Tutorial
1502
276
How to handle transactions in Java with JDBC? How to handle transactions in Java with JDBC? Aug 02, 2025 pm 12:29 PM

To correctly handle JDBC transactions, you must first turn off the automatic commit mode, then perform multiple operations, and finally commit or rollback according to the results; 1. Call conn.setAutoCommit(false) to start the transaction; 2. Execute multiple SQL operations, such as INSERT and UPDATE; 3. Call conn.commit() if all operations are successful, and call conn.rollback() if an exception occurs to ensure data consistency; at the same time, try-with-resources should be used to manage resources, properly handle exceptions and close connections to avoid connection leakage; in addition, it is recommended to use connection pools and set save points to achieve partial rollback, and keep transactions as short as possible to improve performance.

Comparing Java Frameworks: Spring Boot vs Quarkus vs Micronaut Comparing Java Frameworks: Spring Boot vs Quarkus vs Micronaut Aug 04, 2025 pm 12:48 PM

Pre-formanceTartuptimeMoryusage, Quarkusandmicronautleadduetocompile-Timeprocessingandgraalvsupport, Withquarkusoftenperforminglightbetterine ServerLess scenarios.2.Thyvelopecosyste,

How does garbage collection work in Java? How does garbage collection work in Java? Aug 02, 2025 pm 01:55 PM

Java's garbage collection (GC) is a mechanism that automatically manages memory, which reduces the risk of memory leakage by reclaiming unreachable objects. 1.GC judges the accessibility of the object from the root object (such as stack variables, active threads, static fields, etc.), and unreachable objects are marked as garbage. 2. Based on the mark-clearing algorithm, mark all reachable objects and clear unmarked objects. 3. Adopt a generational collection strategy: the new generation (Eden, S0, S1) frequently executes MinorGC; the elderly performs less but takes longer to perform MajorGC; Metaspace stores class metadata. 4. JVM provides a variety of GC devices: SerialGC is suitable for small applications; ParallelGC improves throughput; CMS reduces

Comparing Java Build Tools: Maven vs. Gradle Comparing Java Build Tools: Maven vs. Gradle Aug 03, 2025 pm 01:36 PM

Gradleisthebetterchoiceformostnewprojectsduetoitssuperiorflexibility,performance,andmoderntoolingsupport.1.Gradle’sGroovy/KotlinDSLismoreconciseandexpressivethanMaven’sverboseXML.2.GradleoutperformsMaveninbuildspeedwithincrementalcompilation,buildcac

Using HTML `input` Types for User Data Using HTML `input` Types for User Data Aug 03, 2025 am 11:07 AM

Choosing the right HTMLinput type can improve data accuracy, enhance user experience, and improve usability. 1. Select the corresponding input types according to the data type, such as text, email, tel, number and date, which can automatically checksum and adapt to the keyboard; 2. Use HTML5 to add new types such as url, color, range and search, which can provide a more intuitive interaction method; 3. Use placeholder and required attributes to improve the efficiency and accuracy of form filling, but it should be noted that placeholder cannot replace label.

go by example http middleware logging example go by example http middleware logging example Aug 03, 2025 am 11:35 AM

HTTP log middleware in Go can record request methods, paths, client IP and time-consuming. 1. Use http.HandlerFunc to wrap the processor, 2. Record the start time and end time before and after calling next.ServeHTTP, 3. Get the real client IP through r.RemoteAddr and X-Forwarded-For headers, 4. Use log.Printf to output request logs, 5. Apply the middleware to ServeMux to implement global logging. The complete sample code has been verified to run and is suitable for starting a small and medium-sized project. The extension suggestions include capturing status codes, supporting JSON logs and request ID tracking.

How to use the observer pattern in Java? How to use the observer pattern in Java? Aug 02, 2025 am 11:52 AM

The clear answer to this question is the recommendation to implement the observer pattern using a custom observer interface. 1. Although Java provides Observable and Observer, the former is a class and has been deprecated and lacks flexibility; 2. The modern recommended practice is to define a functional Observer interface, and the Subject maintains the Observer list and notify all observers when the state changes; 3. It can be used in combination with Lambda expressions to improve the simplicity and maintainability of the code; 4. For GUI or JavaBean scenarios, PropertyChangeListener can be used. Therefore, new projects should adopt a custom observer interface scheme, which is type-safe, easy to test and specializes in modern Java

Java Concurrency Utilities: ExecutorService and Fork/Join Java Concurrency Utilities: ExecutorService and Fork/Join Aug 03, 2025 am 01:54 AM

ExecutorService is suitable for asynchronous execution of independent tasks, such as I/O operations or timing tasks, using thread pool to manage concurrency, submit Runnable or Callable tasks through submit, and obtain results with Future. Pay attention to the risk of unbounded queues and explicitly close the thread pool; 2. The Fork/Join framework is designed for split-and-governance CPU-intensive tasks, based on partitioning and controversy methods and work-stealing algorithms, and realizes recursive splitting of tasks through RecursiveTask or RecursiveAction, which is scheduled and executed by ForkJoinPool. It is suitable for large array summation and sorting scenarios. The split threshold should be set reasonably to avoid overhead; 3. Selection basis: Independent

See all articles