jdbc

package DBTest;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class MySQLTest {
    public static void main(String[] args) {
        // 1. 导入驱动类
        try {
            Class.forName("com.mysql.jdbc.Driver");
        // 2.建立连接
            try {
                Connection con =  DriverManager.getConnection("jdbc:mysql://localhost:3306/new_db","root","");
        // 3.负责执行sql语句
                PreparedStatement pstm = con.prepareStatement("insert into proudct(name) values('computer')");
                int count = pstm.executeUpdate();
                if(count > 0 ) {
                    System.out.println("插入数据成功！");
                }else {
                    System.out.println("失败！");
                }

        // 4. 关闭
                con.close();
                pstm.close();

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