2408671535 javaJDBC-CSDN博客

文章详细展示了如何在Java中使用JDBC进行数据库操作，包括插入、更新和查询数据，以FengPu包中的`fp`类为例，通过`DriverManager.getConnection()`建立连接，使用PreparedStatement处理SQL语句。

package FengPu;

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

public class fp {public static void main(String[] args)throws ClassNotFoundException, SQLException {
    insert();
//        update();
    delete();
    query();
}

    private static void query() {

    }

    private static void delete() {

    }

    private static void update() throws ClassNotFoundException, SQLException {
        Class.forName("com.mysql.jdbc.Driver");
        Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbc?useUnicode=true&characterEncoding=utf-8","root","123456");
        String sql = "update s set name = ?,age=? where id = 1";
        PreparedStatement preparedStatement = connection.prepareStatement(sql);
        preparedStatement.setString(1,"冯浦");
        preparedStatement.setInt(2,21);
        int i = preparedStatement.executeUpdate();
        System.out.println(i);
        connection.close();
        preparedStatement.close();

    }

    private static void insert() throws ClassNotFoundException, SQLException {
//        2.加载mysql驱动
        Class.forName("com.mysql.jdbc.Driver");
//        3.获取连接对象
        Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbc?useUnicode=true&characterEncoding=utf-8","root","123456");
//        4.获取执行sql语句的对象
        String sql = "insert into s(name,age)value(?,?)";
        PreparedStatement preparedStatement = connection.prepareStatement(sql);
//        给占位符赋值
        preparedStatement.setInt(2,21);
        preparedStatement.setString(1,"冯浦");
//        5.执行sqlyuju
        int i = preparedStatement.executeUpdate();
//        6.解析结果
        System.out.println(i);
        connection.close();
        preparedStatement.close();




    }
}