jdbc:连接mysql数据库并实现查询功能

jdbc连接数据库方法及步骤

1、注册驱动
2、获取数据库连接
3、获取数据库操作对象
4、执行SQL语句
5、处理查询结果集
6、释放资源

package JDBC;
/*
 * jdbc:连接数据库查询功能
 */
import java.sql.Connection;

import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class TestDemo01 {

	public static void main(String[] args) throws Exception{
		// TODO Auto-generated method stub
		//加载数据库驱动
			Class.forName("com.mysql.jdbc.Driver");
			
			//通过url,user,password连接到数据库，获取到连接对象
			Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/s_t", "root", "111111");
			String sql = "select * from student";
			//进行数据库的数据操作
			Statement stmt = conn.createStatement();
			//实现数据查询
			ResultSet rs = stmt.executeQuery(sql);
			//获取数据
			while(rs.next()){
			//按照列获取数据
				String sno = rs.getString("sno");
				String name = rs.getString("name");
				String sex = rs.getString("sex");
				int age = rs.getInt("age");
				
				String department = rs.getString("department");
				String address = rs.getString("address");
				System.out.println(sno+" "+name+" "+sex+" "+age+" "+department+" "+address);
			}
			//释放资源，关闭数据库
			rs.close();
			stmt.close();
			conn.close();
			
		
	}

}

运行结果