JDBC入门

package com.itheima.test;

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

public class MainTest {

	public static void main(String[] args) {
		
		
		try {
			
			//1.注册驱动
			DriverManager.registerDriver(new com.mysql.jdbc.Driver());
			
			//2.建立连接
			Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/student","root","yang521314..");
			
			/*DriverManager.getConnection("jdbc:mysql://localhost/test?user=monty&password=greatsqldb");*/
			
			//3.创建statement，跟数据库打交道，一定要用到statement
			Statement st = conn.createStatement();
			
			//4.执行查询,得到结果集
			String sql="select * from tables";
			ResultSet rs = st.executeQuery(sql);
			
			//5.遍历查询每一条
			while(rs.next()){
				int id = rs.getInt("id");
				String name = rs.getString("name");
				int age = rs.getInt("age");
				
				System.out.println("id=" + id + " name=" + name + " age=" + age);
			}
			
			rs.close();
			st.close();
			conn.close();
			
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}

}

查询结果：