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

Home Java JavaBase Solution to garbled data inserted into mysql using java

Solution to garbled data inserted into mysql using java

Nov 30, 2019 am 11:15 AM
java

Solution to garbled data inserted into mysql using java

Method 1: Set encoding uniformity

1. Set the eclipse environment encoding (recommended : java video tutorial)

Solution to garbled data inserted into mysql using java

2. Set the mysql environment encoding

mydb as the database that needs to be modified Name

Solution to garbled data inserted into mysql using java

Method 2: Set the encoding when creating the database

1. Set the encoding when mysql creates the database

create database mydb default character set utf8 collate utf8_general_ci;

2. Set the encoding when creating the table

CREATE TABLE `type` ( 
`id` int(10) unsigned NOT NULL auto_increment, 
`flag_deleted` enum('Y','N') character set utf8 NOT NULL default 'N', 
`flag_type` int(5) NOT NULL default '0', 
`type_name` varchar(50) character set utf8 NOT NULL default '', 
PRIMARY KEY (`id`) 
)  DEFAULT CHARSET=utf8;

Method 3: Set when connecting to the database

Add ?useUnicode=true&characterEncoding=UTF-8

public class TestJdbc {
    private static String URL = "jdbc:mysql://localhost:3306/studentmanage?useUnicode=true&characterEncoding=UTF-8";
    useUnicode=true&characterEncoding=UTF-8
    private static String USER = "root";
    private static String PASSWORD = "root";

    public static void main(String[] args) {
        Connection con = null;

        String sql = "insert into user(uid,uname,password) values(?,?,?)";
        try {
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection(URL, USER, PASSWORD);
            con.close();
        } catch (Exception e) {
            e.printStackTrace();
        } 
    }

after the URL. The function of adding is to specify the encoding and decoding format of characters.

For example: the mysql database uses gbk encoding, while the project database uses utf-8 encoding. If useUnicode=true&characterEncoding=UTF-8 is added at this time, the effect has the following two aspects:

When storing data:

The database will first use UTF-8 when storing project data The format decodes the data into bytecode, and then reuses the decoded bytecode to store it in the database using GBK encoding.

When retrieving data:

When retrieving data from the database, the database will first decode the data in the database into bytecodes in GBK format, and then convert the decoded bytes The code re-encodes the data in UTF-8 format and finally returns the data to the client.

For more java knowledge, please pay attention to the java basic tutorial column.

The above is the detailed content of Solution to garbled data inserted into mysql using java. For more information, please follow other related articles on the PHP Chinese website!

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)

Go for Audio/Video Processing Go for Audio/Video Processing Jul 20, 2025 am 04:14 AM

The core of audio and video processing lies in understanding the basic process and optimization methods. 1. The basic process includes acquisition, encoding, transmission, decoding and playback, and each link has technical difficulties; 2. Common problems such as audio and video aberration, lag delay, sound noise, blurred picture, etc. can be solved through synchronous adjustment, coding optimization, noise reduction module, parameter adjustment, etc.; 3. It is recommended to use FFmpeg, OpenCV, WebRTC, GStreamer and other tools to achieve functions; 4. In terms of performance management, we should pay attention to hardware acceleration, reasonable setting of resolution frame rates, control concurrency and memory leakage problems. Mastering these key points will help improve development efficiency and user experience.

Using the Translator facade for Localization in Laravel. Using the Translator facade for Localization in Laravel. Jul 21, 2025 am 01:06 AM

TheTranslatorfacadeinLaravelisusedforlocalizationbyfetchingtranslatedstringsandswitchinglanguagesatruntime.Touseit,storetranslationstringsinlanguagefilesunderthelangdirectory(e.g.,en,es,fr),thenretrievethemviaLang::get()orthe__()helperfunction,suchas

Go for Image Manipulation Libraries Go for Image Manipulation Libraries Jul 21, 2025 am 12:23 AM

Common Go image processing libraries include standard library image packages and third-party libraries, such as imaging, bimg, and imagick. 1. The image package is suitable for basic operations; 2. Imaging has a complete function and a simple API, which is suitable for most needs; 3. Bimg is based on libvips, has strong performance, which is suitable for large images or high concurrency; 4. Imagick binds ImageMagick, which is powerful but has heavy dependencies. Quickly implement image scaling and cropping. You can use the imaging library to complete it through a few lines of code in Resize and CropAnchor functions, and support multiple parameter configurations. Adding filters or adjusting tones can be achieved through the color transformation function provided by imagination, such as Graysc

Implement a linked list in Java Implement a linked list in Java Jul 20, 2025 am 03:31 AM

The key to implementing a linked list is to define node classes and implement basic operations. ①First create the Node class, including data and references to the next node; ② Then create the LinkedList class, implementing the insertion, deletion and printing functions; ③ Append method is used to add nodes at the tail; ④ printList method is used to output the content of the linked list; ⑤ deleteWithValue method is used to delete nodes with specified values and handle different situations of the head node and the intermediate node.

Java Virtual Threads Performance Benchmarking Java Virtual Threads Performance Benchmarking Jul 21, 2025 am 03:17 AM

Virtual threads have significant performance advantages in highly concurrency and IO-intensive scenarios, but attention should be paid to the test methods and applicable scenarios. 1. Correct tests should simulate real business, especially IO blocking scenarios, and use tools such as JMH or Gatling to compare platform threads; 2. The throughput gap is obvious, and it can be several times to ten times higher than 100,000 concurrent requests, because it is lighter and efficient in scheduling; 3. During the test, it is necessary to avoid blindly pursuing high concurrency numbers, adapting to non-blocking IO models, and paying attention to monitoring indicators such as latency and GC; 4. In actual applications, it is suitable for web backend, asynchronous task processing and a large number of concurrent IO scenarios, while CPU-intensive tasks are still suitable for platform threads or ForkJoinPool.

Advanced Java Collection Framework Optimizations Advanced Java Collection Framework Optimizations Jul 20, 2025 am 03:48 AM

To improve the performance of Java collection framework, we can optimize from the following four points: 1. Choose the appropriate type according to the scenario, such as frequent random access to ArrayList, quick search to HashSet, and concurrentHashMap for concurrent environments; 2. Set capacity and load factors reasonably during initialization to reduce capacity expansion overhead, but avoid memory waste; 3. Use immutable sets (such as List.of()) to improve security and performance, suitable for constant or read-only data; 4. Prevent memory leaks, and use weak references or professional cache libraries to manage long-term survival sets. These details significantly affect program stability and efficiency.

SQL for Predictive Analytics SQL for Predictive Analytics Jul 20, 2025 am 02:02 AM

In predictive analysis, SQL can complete data preparation and feature extraction. The key is to clarify the requirements and use SQL functions reasonably. Specific steps include: 1. Data preparation requires extracting historical data from multiple tables and aggregating and cleaning, such as aggregating sales volume by day and associated promotional information; 2. The feature project can use window functions to calculate time intervals or lag features, such as obtaining the user's recent purchase interval through LAG(); 3. Data segmentation is recommended to divide the training set and test set based on time, such as sorting by date with ROW_NUMBER() and marking the collection type proportionally. These methods can efficiently build the data foundation required for predictive models.

Go for Scientific Computing and Numerical Analysis Go for Scientific Computing and Numerical Analysis Jul 23, 2025 am 01:53 AM

Go language can be used for scientific calculations and numerical analysis, but it needs to be understood. The advantage lies in concurrency support and performance, which is suitable for parallel algorithms such as distributed solution, Monte Carlo simulation, etc.; community libraries such as gonum and mat64 provide basic numerical calculation functions; hybrid programming can be used to call C/C and Python through Cgo or interface to improve practicality. The limitation is that the ecosystem is not as mature as Python, the visualization and advanced tools are weaker, and some library documents are incomplete. It is recommended to select appropriate scenarios based on Go features and refer to source code examples to use them in depth.

See all articles