MySQL jdbc增删改查

步骤

public class MySql {    public static void main(String[] args) {        //连接数据库的驱动        String driver = "com.mysql.jdbc.Driver";        //URL指向要访问的数据库名        String url = "jdbc:mysql://localhost:3306/calzz";        //MYSQL的用户名        String user = "root";        //MySQL的密码        String password = "123456";        try {            Class.forName(driver);//加载驱动            Connection connection = DriverManager.getConnection(url,user,password);//连接数据库            if(!connection.isClosed()){                //数据库操作类                Statement statement = connection.createStatement();                String sql;                //执行语句                //增//              sql = "insert into student (name,age,sex) values('李四',23,1)";//              statement.execute(sql);//              //删//              sql = "delete from student where name = '张三'";//              statement.execute(sql);                //改//              sql = "update student set age = 23,sex = 0 where name ='李四'";//              statement.execute(sql);                //查     使用其他方法                sql = "select name,age,sex from student where age>10";//              statement.execute(sql);                ResultSet resultSet = statement.executeQuery(sql);                resultSet.first();//先把游标移到第一位                while(!resultSet.isAfterLast()){//判断是否移到最后                    String name = resultSet.getString("age");                    System.out.println(name);                    resultSet.next();                }                statement.close();                connection.close();            }else{                System.out.println("请打开数据库连接");            }        } catch (ClassNotFoundException e) {            // TODO Auto-generated catch block            e.printStackTrace();        } catch (SQLException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }    }}