使用JDBC操作数据库

使用JDBC操作数据库

1.概述

2.JDBC访问数据库步骤

3.连接数据库代码

public class JDBC {
    public static void main(String[] args) throws Exception {
        //引入mysql驱动jar包
        //1.加载数据库驱动
        Class.forName("com.mysql.jdbc.Driver");

        //2.连接数据库
        Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/smbms", "root", "1234");

        //3.创建Statement对象
        Statement statement = connection.createStatement();

        //4.执行sql语句,查询语句用executeQuery(),返回的是查询结果集.更改语句用executeUpdate(),返回的是更改影响的行数
        String sql1="select * from smbms_user";
        String sql2="insert into smbms_user (userCode,userName) values('madongmei','马冬梅')";
        String sql3="delete from smbms_user where id=15";
        String sql4="update smbms_user set userName='管理员' where id=1";

        int i = statement.executeUpdate(sql2);
        ResultSet resultSet = statement.executeQuery(sql1);


        //5.遍历结果集
        while (resultSet.next()){
            int id = resultSet.getInt("id");
            String userCode = resultSet.getString("userCode");
            String username = resultSet.getString("userName");
            System.out.println(id+"--"+userCode+"--"+username);
        }
    }
}

4.总结