本文共 1537 字，大约阅读时间需要 5 分钟。

package jdbc01;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import com.mysql.cj.jdbc.Driver;//向表中添加一条记录public class JdbcDemo4 {
   public static void main(String[] args) throws Throwable {
   	Statement stmt=null;	Connection conn = null;	ResultSet rs = null;	try {
   		//1.注册驱动		Class.forName("com.mysql.cj.jdbc.Driver");		//2.获取数据库的连接对象		conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/ceshi?serverTimezone=GMT%2B8", "root","123456");		//3.定义sql		String sql= "select * from student";		//4.获取执行sql的对象		stmt = conn.createStatement();        //5.执行sql		rs = stmt.executeQuery(sql);		 //6.处理结果        //循环判断游标是否是最后一行末尾。        while(rs.next()){
               //获取数据            //6.2 获取数据            int id = rs.getInt(1);            String name = rs.getString("name");            double balance = rs.getDouble(3);            System.out.println(id + "---" + name + "---" + balance);        }     	} catch (ClassNotFoundException e) {
   		// TODO Auto-generated catch block		e.printStackTrace();	}finally {
           //stmt.close();        //7. 释放资源        //避免空指针异常        if(stmt != null){
               try {
                   stmt.close();            } catch (SQLException e) {
                   e.printStackTrace();            }        }        if(conn != null){
               try {
                   conn.close();            } catch (SQLException e) {
                   e.printStackTrace();            }        }    }}}

转载地址：http://ndezi.baihongyu.com/