如何从select查询返回值？

import MySQLdb

# 连接数据库
conn = MySQLdb.connect(host='localhost', user='root', password='password', db='mydatabase')

# 创建游标对象
cursor = conn.cursor()

# 执行select查询
cursor.execute("SELECT * FROM mytable")

# 获取结果集
results = cursor.fetchall()

# 遍历结果集
for row in results:
    # 处理每一行数据
    print(row)

# 关闭游标和数据库连接
cursor.close()
conn.close()

import org.hibernate.Session;
import org.hibernate.query.Query;

// 获取Hibernate会话对象
Session session = HibernateUtil.getSessionFactory().openSession();

// 执行select查询
Query query = session.createQuery("FROM MyEntity");
List<MyEntity> results = query.list();

// 遍历结果集
for (MyEntity entity : results) {
    // 处理每个实体对象
    System.out.println(entity);
}

// 关闭会话
session.close();

-- 创建存储过程
DELIMITER //
CREATE PROCEDURE GetEmployees()
BEGIN
    SELECT * FROM employees;
END //
DELIMITER ;

-- 调用存储过程
CALL GetEmployees();