JAVA的JDBC入门代码

JAVA的JDBC入门代码

package com.test;

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

public class Jdbc01 {

	public static void main(String[] args) throws Exception  {
		// TODO Auto-generated method stub
		//1:注册驱动
		Class.forName("com.mysql.jdbc.Driver");
		//2获取连接Connection
		//Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test1", "root", "123456");
		Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test1?useSSL=true", "root", "123456");
		//3获取执行sql语句的Statement对象
		Statement  smt=	conn.createStatement();
		//4执行SQL语句并返回结果
		ResultSet rs =  smt.executeQuery("select * from biao "); 
		//5处理结果集
		while(rs.next()) {
		  System.out.println(rs.getObject("id"));
		  System.out.println(rs.getObject("name"));
		  System.out.println(rs.getObject("sex"));
		}
		//6关闭Connection
		rs.close();
		smt.close();
		conn.close();
	}

}