JDBC

package text;

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


public class ConnectorUpdata {

    public static void main(String[] args) {
	
	
	Connection conn=null;
	Statement sql=null;
	String 	sqlStr=null;
	ResultSet re =null;
	// TODO 自动生成的方法存根
//	public static String uri="jdbc:mysql://127.0.0.1:3306/guanggao_db?user=root"
//		+ "&password=root&useSSL=false&serverTimezone=UTC&characterEncoding=utf-8";
	String url = "jdbc:mysql://127.0.0.1:3306/students?useSSL=false&serverTimezone=UTC&characterEncoding=utf-8";

	// jdbc:mysql://localhost:3306/students?useSSL=false&serverTimezone=UTC
	String user = "root";
	String password = "root";
	try {
	    // 注册驱动
	    DriverManager.registerDriver(new com.mysql.cj.jdbc.Driver());

	    //Class.forName("com.mysql.cj.jdbc.Driver");
	    System.out.println("加载成功！！！");

	} catch (Exception e) {
	    // TODO 自动生成的 catch 块
	    e.printStackTrace();
	    System.out.println("加载失败");
	}
	try {
	    // 获取连接
	    conn = DriverManager.getConnection(url, user, password);
	    System.out.println("连接成功！！！");
	} catch (SQLException e) {
	    System.out.println("连接失败！！");
	} catch (Exception e) {
	    System.out.println("连接失败啊");
	}
	
	//获取数据库的操作对象
	try {
	    sql= conn.createStatement();

	    //sqlStr="insert into mess(number,name,birthday,height) values('R1018','张小飞','1999-03-01',1.56)";
	    sqlStr="select * from mess";
	  //  int count =sql.executeUpdate(sqlStr);
	   re= sql.executeQuery(sqlStr);
	   // System.out.println(count==1?"保存成功":"保存失败");
	   while(re.next()) {
	      String number= re.getString(1);
	      String name = re.getString(2);
	      String birthday = re.getString(3);
	      String height = re.getString(4);
	      System.out.println(number+","+name+","+birthday+","+height);
	   }
	} catch (SQLException e) {
	    // TODO 自动生成的 catch 块
	    e.printStackTrace();
	}finally {

	    try {
		if(sql!=null) {
		    sql.close();
		}
		    
	    } catch (Exception e) {
		// TODO: handle exception
	    }
	    
	    try {
		if(conn!=null) {
		    conn.close();
		}
	    } catch (Exception e) {
		// TODO: handle exception
	    }
	    
	    
	    }
	    
	}
	
	
    }