jdbc连接mysql数据库

package com.hetester.jdbc;

import java.sql.*;

public class JDBCTest {
    public static void main(String[] args) {
        Connection conn=null;
        Statement stat=null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
//            Driver driver=new com.mysql.jdbc.Driver();
//            DriverManager.registerDriver(driver);
            String url="jdbc:mysql://192.168.31.229:3306/my_first";
            String user="root";
            String passwd="Ruantong@123";
            conn=DriverManager.getConnection(url,user,passwd);
            stat =conn.createStatement();
            String sql="insert into my_first(name) values('chen1')";
            int count=stat.executeUpdate(sql);
            System.out.println(count==1 ?"保存成功":"保存失败");

            String sqlAdd="select id,name from my_first";
            ResultSet rs=stat.executeQuery(sqlAdd);
            while (rs.next()){
                int id=rs.getInt("id");
                String name=rs.getString("name");
                System.out.println(id+"\t"+name);
            }
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } finally {
            try {
                if (stat != null){
                    stat.close();
                }
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
            try {
                if (conn != null){
                    conn.close();
                }
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
//        } catch (ClassNotFoundException e) {
//            e.printStackTrace();

    }
}