jdbc2

Student:
.

package Ajdbc1;

public class Student {
    private String name;
    private String sex;
    private Integer age;
    private String address;

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    @Override
    public String toString() {
        return "Student{" +
                "name='" + name + '\'' +
                ", sex='" + sex + '\'' +
                ", age=" + age +
                ", address='" + address + '\'' +
                '}';
    }
}

/
数据库工具类
/

package Ajdbc1;

import jichu3.Stu;

import java.sql.*;
import java.util.ArrayList;
import java.util.List;

public class DBUtil {

    private static String url="jdbc:mysql://localhost:3306/task";
    public static String userName="root";
    public static String password="123456";
    public static String className="com.mysql.jdbc.Driver";
    private DBUtil(){}//构造方法私有化
    static {     //静态代码块在类执行的时候就要初始化
        try {
            Class.forName(className);
        }catch (ClassNotFoundException e){
            e.printStackTrace();
        }
    }
    //取连接
    public static Connection getConn(){
        Connection conn=null;
        try {
            conn= DriverManager.getConnection(url,userName,password);
        }catch (Exception e){
            e.printStackTrace();
        }
        return conn;
    }
    //关闭资源
    public static void close(ResultSet rs, Statement stm,Connection conn){
        if (rs!=null){
            try{
                rs.close();
            }catch (SQLException e){
                e.printStackTrace();
            }
        }
        if (stm!=null){
            try{
                stm.close();
            }catch (SQLException e){
                e.printStackTrace();
            }
        }
        if (conn!=null){
            try{
                conn.close();
            }catch (SQLException e){
                e.printStackTrace();
            }
        }
    }
    //添加
    public static int add(Student stu){
        Connection conn=null;
        Statement stm=null;
        int result=0;
        try {
            conn=DBUtil.getConn();
            stm=conn.createStatement();
            String sql="insert into student(name,sex) values('"+stu.getName()+"','"+stu.getSex()+"')";
            result=stm.executeUpdate(sql);//凡是数据库的修改，都使用executeUpdate，返回值代表成功的条数
        }catch (Exception e){
            e.printStackTrace();
        }finally {
            DBUtil.close(null,stm,conn);
        }
        return result;
    }
    //根据id查询
    public static Student queryById(int id){
        Connection conn=null;
        Statement stm=null;
        ResultSet rs=null;
        Student stu=null;
        try {
            conn=DBUtil.getConn();
            stm=conn.createStatement();
            String sql="select * from student where id="+id;
            rs=stm.executeQuery(sql);
            if (rs.next()){
              stu=new Student();
              stu.setName(rs.getString("name"));
              stu.setSex(rs.getString("sex"));
              stu.setAge(rs.getInt("age"));
            }
        }catch (Exception e){
            e.printStackTrace();
        }finally {
            DBUtil.close(rs,stm,conn);
        }
        return stu;
    }
    //查询所有
    public static List<Student> getAllStu(){
        Connection conn=null;
        Statement stm=null;
        ResultSet rs=null;
        Student stu=null;
        List<Student> stuList=new ArrayList<Student>();//集合
        try {
            conn=DBUtil.getConn();
            stm=conn.createStatement();
            String sql="select * from student";
            rs=stm.executeQuery(sql);
            while (rs.next()){
                stu=new Student();
                stu.setAge(rs.getInt("age"));
                stu.setSex(rs.getString("sex"));
                stu.setName(rs.getString("name"));
                stu.setAddress(rs.getString("address"));
                stu.setId(rs.getInt("id"));
                stuList.add(stu);
            }
        }catch (Exception e){
            e.printStackTrace();
        }finally {
            DBUtil.close(rs,stm,conn);
        }
        return stuList;
    }

    //修改
    public static int xiugai(Student stu){
        Connection conn=null;
        Statement stm=null;
        int rs=0;
        try {
            conn=DBUtil.getConn();
            stm=conn.createStatement();
           String sql=" UPDATE student SET age='"+stu.getAge()+"'," +
                    "name='"+stu.getName()+"',address='"+stu.getAddress()+"'," +
                    "sex='"+stu.getSex()+"' WHERE id='"+stu.getId()+"'";
            rs=stm.executeUpdate(sql);

        }catch (Exception e){
            e.printStackTrace();
        }finally {
            DBUtil.close(null,stm,conn);
        }
        return rs;
    }
    //删除
    public static int shanchu(int id){
        Connection conn=null;
        Statement stm=null;
        int rs=0;
        Student stu=null;
        try {
            conn=DBUtil.getConn();
            stm=conn.createStatement();
            String sql="delete from student where id="+id;
            rs=stm.executeUpdate(sql);

        }catch (Exception e){
            e.printStackTrace();
        }finally {
            DBUtil.close(null,stm,conn);
        }
        return rs;
    }
}

/
/

package Ajdbc1;

import java.util.List;

public class Test2 {
    public static void main(String[] args) {
        //添加
        /*Student stu=new Student();
        stu.setSex("男");
        stu.setName("海绵宝宝啊");

        int result = DBUtil.add(stu);
        if (result>0){
            System.out.println("添加成功");
        }else {
            System.out.println("添加失败");
        }*/
/*//根据id查
        Student student = DBUtil.queryById(4);
        if (student!=null){
            System.out.println("查询成功："+student);
        }else {
            System.out.println("查询失败");
        }

        //查询所有
        List<Student> stuList=DBUtil.getAllStu();
        if (stuList.size()!=0){//
            stuList.forEach(stu -> System.out.println("查询成功："+stu));
           *//* for (Student stu:stuList){
                System.out.println("查询成功："+stu);
            }*//*
        }
        else {
            System.out.println("没有数据");
        }*/

     /*   //修改
        Student stu=new Student();
        stu.setSex("男");
        stu.setName("居居酱啊");
        stu.setAddress("南宁");
        stu.setAge(21);
        stu.setId(4);
        int xiugai = DBUtil.xiugai(stu);
        if (xiugai>0){
            System.out.println("修改成功");
        }else {
            System.out.println("修改失败");
        }*/

        //删除
        int shanchu = DBUtil.shanchu(6);
        if (shanchu>0){
            System.out.println("删除成功");
        }else {
            System.out.println("删除失败");
        }
    }

}

。
/
/
/

package Ajdbc1;

import java.sql.*;

public class Test1 {
    public static void main(String[] args) {
        Connection conn=null;
        Statement stm=null;
        ResultSet rs=null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            conn=DBUtil.getConn();
            stm=conn.createStatement();
            rs=stm.executeQuery("select * from student");
            while (rs.next()){
               // int sid=rs.getInt("sid");
                int age=rs.getInt("age");
                String address=rs.getString("address");
                String name=rs.getString("name");
                String sex=rs.getString("sex");
                System.out.println(age+"  "+address+" "+name+"  "+sex);
            }
        }catch (Exception e){
            e.printStackTrace();
        }finally {
            DBUtil.close(rs,stm,conn);
        }
    }
}