The most basic JDBC template and database garbled code processing

Beginners JDBC

public class JDBCDemo1 {
    
    public static void main(String[] args) throws Exception {
    
        //1. The load driver 
        Class.forName("com.mysql.jdbc.Driver");
        //2、 Get the connection object 
        Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "123456");
        //3. Access to perform SQL object 
        Statement statement = connection.createStatement();
        //4. perform SQL sentence , And receive the results 
        int result = statement.executeUpdate("insert into user(userid,username,sex)values(1,' Zhang San ',' male ');");
        /*// Above statement There is injection risk , The execution efficiency is not very high  // The following methods can effectively avoid SQL The risk of Injection , To compile the first , Post run  String sql="insert into user(userid,username,sex)values(5,' Sun Qi ',' male ')"; PreparedStatement statement = connection.prepareStatement(sql); int result =statement.executeUpdate();*/
        // Processing results 
        if(result == 1){
    
            System.out.println(" Registered successfully ！");
        }else {
    
            System.out.println(" Registration failed ！");
        }
        // Release resources 
        statement.close();
        connection.close();
    }
}

If the Chinese characters inserted into the database appear garbled , You can change the code above to get the connection to ：
Connection connection = DriverManager.getConnection(“jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8”, “root”, “123456”);
explain ： The problem of garbled code is not the problem of this code , But when you install the database, you choose mysql Default characters provided latin1, When using the modified character set , Even if the character set you choose when creating the database is utf-8, Use JDBC There will still be garbled code when inserting data about Chinese , You can open your own mysql Check the installation directory my.ini The configuration file ： Disk character :\Program Files\MySQL\MySQL Server 5.1

Tips

The above is just my own opinion , Any similarity is purely accidental . If there is a mistake , Please understand , Don't spray ！ If there is gain or doubt , Comments are welcome on thumb up ！