jdbc的基础用法01

java 数据库 连接

jdbc全称：java data base connection

package com.test.utils;


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


public class JdbcTest {
	
	public static void main(String[] args) throws SQLException, ClassNotFoundException {
		
		Class.forName("com.mysql.jdbc.Driver");
		//DriverManager.registerDriver(new Driver());
		Connection conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb4", "root", "123456");
		Statement stat =conn.createStatement();
		ResultSet rs =stat.executeQuery("select * from tb_user");
		
		while(rs.next()){
			int id = rs.getInt(1);
			String name = rs.getString(2);
			String gender = rs.getString(3);
			String addr = rs.getString(4);
			System.out.println(name + "性别"+gender+"地址："+addr);
		}
	}

}