JDBC入门操作

import java.sql.Date;

public class Student {
    private String sno;
    private String sname;
    private String ssex;
    private Date sbirthda;
    private String sClass;

    public Student() {
    }

    public Student(String sno, String sname, String ssex, Date sbirthda, String sClass) {
        this.sno = sno;
        this.sname = sname;
        this.ssex = ssex;
        this.sbirthda = sbirthda;
        this.sClass = sClass;
    }

    public String getSno() {
        return sno;
    }

    public void setSno(String sno) {
        this.sno = sno;
    }

    public String getSname() {
        return sname;
    }

    public void setSname(String sname) {
        this.sname = sname;
    }

    public String getSsex() {
        return ssex;
    }

    public void setSsex(String ssex) {
        this.ssex = ssex;
    }

    public Date getSbirthda() {
        return sbirthda;
    }

    public void setSbirthda(Date sbirthda) {
        this.sbirthda = sbirthda;
    }

    public String getsClass() {
        return sClass;
    }

    public void setsClass(String sClass) {
        this.sClass = sClass;
    }

    @Override
    public String toString() {
        return
                sno + "," + sname + ","+ ssex + ","+ sbirthda + ","+ sClass ;
    }
}


import Day01.Text03.Student;

import java.sql.*;

public class Deom {
    public static void main(String[] args) {
        Connection conn = null;
        Statement statement = null;
        ResultSet resultSet = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql:///my_db", "root", "hao");
            statement = conn.createStatement();
            String sql = "select * from student";
            resultSet = statement.executeQuery(sql);
            Student student = new Student();
            while (resultSet.next()) {
                String sno = resultSet.getString("Sno");
                String sname = resultSet.getString("sname");
                String ssex = resultSet.getString("Ssex");
                Date sbirthday = resultSet.getDate("Sbirthday");
                String sClass = resultSet.getString("SClass");
                student.setSno(sno);
                student.setSname(sname);
                student.setSsex(ssex);
                student.setSbirthda(sbirthday);
                student.setsClass(sClass);
                System.out.println(student);
            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            if (resultSet!=null){
                try {
                    resultSet.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            if (statement!=null){
                try {
                    resultSet.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            if (conn!=null){
                try {
                    resultSet.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }
    }
}