javaWeb:jdbc都操作CRUD，jdbc工具类

1.CRUD是什么？

是对jdbc的操作：jdbc的增删改查

2.jdbc的CRUD之保存：

String sql = “insert into user values(‘4’,‘我是’,777)”;//插入语句
String sql = “insert into user values(‘4’,5,777)”;
对应了：表：数据类型

varchar(45):可以是字符串/也可以放数字
int ：整型

int num = stmt.executeUpdate(sql); //执行sql语句
executeUpdate(sql)：更新表

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

public class Domew {


    public static void main(String[] args) throws ClassNotFoundException, SQLException {

try{
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/new_schema", "root", "your-password");

        Statement stmt = conn.createStatement();//创建执行sql对象

        String sql = "insert into user values('4','我是',777)";//插入语句

        int num = stmt.executeUpdate(sql); //执行sql语句
        if (num > 0) {
            System.out.println("保存成功！");
        }} catch (ClassNotFoundException e) {
    e.printStackTrace();
} catch (SQLException throwables) {
    throwables.printStackTrace();
}


    }
    }

效果：

3.jdbc的CRUD之修改：

原来基础上加：
String sql=“update user set username=‘1’,password='1’where idusers=555”;//更新表

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

public class Domew {


    public static void main(String[] args) throws ClassNotFoundException, SQLException {

try{
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/new_schema", "root", "your-password");

        Statement stmt = conn.createStatement();//创建执行sql对象

       // String sql = "insert into user values('4','我是',777)";//插入语句

    String sql="update user set username='1',password='1'where idusers=555";//更新表
        int num = stmt.executeUpdate(sql); //执行sql语句
        if (num > 0) {
            System.out.println("保存成功！");
        }} catch (ClassNotFoundException e) {
    e.printStackTrace();
} catch (SQLException throwables) {
    throwables.printStackTrace();
}


    }
    }

效果：

4.删除：编写sql语句

String sql=“delete from user where idusers=555”;(删除指定的列)

5.查询多条记录或一条记录:

String sql=“select *from user”;//查询语句
System.out.println(rs.getString(“password”)+" “+ rs.getString(“username”)+” "+rs.getInt(“IDUSERS”));//

rs.getString(“password”)//列名,返回列名的对应的数据

一条记录:

  String sql="select *from user where idusers=777";//这个语句

import java.sql.*;

public class Domew {


    public static void main(String[] args) throws ClassNotFoundException, SQLException {

try{
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/new_schema", "root", "your-password");

        Statement stmt = conn.createStatement();//创建执行sql对象

       // String sql = "insert into user values('4','我是',777)";//插入语句

  //  String sql="update user set username='1',password='1'where idusers=555";//更新表

    //String sql="delete from user where idusers=555";

    String sql="select *from user";

    ResultSet rs= stmt.executeQuery(sql); //执行sql语句


       while (rs.next()) {           //如果表还有下一个,继续
            System.out.println("保存成功！");

            System.out.println(rs.getString("password")+" "+ rs.getString("username")+" "+rs.getInt("IDUSERS"));


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


    }
    }

效果:

6.jdbc工具类：抽取:

注册和连接，可以放入一个类中，想用它，就调用它就可以了

类：TYBU

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

public class TYBU {



private static final String driverClassName;
private  static  final String url;
private static final String password;

private static final String usernane;
static {
url="jdbc:mysql://localhost:3306/new_schema";
    driverClassName="com.mysql.jdbc.Driver";
password="your-password";

usernane="root";
}


public static void loadDriver() throws ClassNotFoundException {

    try{
    Class.forName(driverClassName);

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


}

public static Connection getConnection(){


    Connection conn=null;
    try {
        loadDriver();

        conn= DriverManager.getConnection(url,usernane,password);
    } catch (ClassNotFoundException | SQLException e) {
        e.printStackTrace();
    }
return conn;


}}

测试：

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class TYBU1 {


    public static void main(String[] args) throws SQLException {


        Connection conn=TYBU.getConnection();//调用类的方法


        Statement stmt = conn.createStatement();
        String sql="select *from user";
        ResultSet rs= stmt.executeQuery(sql);
        while (rs.next()){


            System.out.println(rs.getString("password")+" "+ rs.getString("username")+" "+rs.getInt("IDUSERS"));

        }
        




    }



}

结果：