Consulta a db en varios lenguajes.

Por Francisco Rosales

C#

using System;
using System.Data;
using System.Data.OleDb;

namespace proyecto.Logic
{
public class GetLista
{
private OleDbConnection conn;
private OleDbCommand comm;
public GetLista()
{
conn = new OleDbConnection();
conn.ConnectionString = "oracleString";
conn.Open();
comm = new OleDbCommand();
comm.Connection = conn;
string sql = "SELECT * FROM list";
comm.CommandText = sql;
int registro = comm.ExecuteNonQuery();
}
}
}

ActionScript 3

package {
import pl.mooska.asql.*;
public class ASQLTest extends Sprite
{
private var conn:Asql = new Asql();
public function ASQLTest()
{
conn.addEventListener(SQLEvent.CONNECT, handleConnect);
conn.addEventListener(SQLEvent.SQL_DATA, getList);
conn.connect("urldb","user","pass","schema",3306);
}
private function handleConnect ( evt:SQLEvent ) :void
{
conn.query("SELECT * FROM list");
}
private function getList ( evt:SQLEvent ) :void
{
trace("data > " + evt.data.toString());
conn.disconnect();
}
}
}


Pablo Morales

hacer una conexion a un mysql y devolver un array con los registros con Zend Framework (php)

$db = new Zend_Db_Adapter_Pdo_Mysql

(array('host' => 'localhost' , 'username' => 'desarrollo' , 'password' => 'testinpass' , 'dbname' => 'sistemas'));
$query = $db->select()->from('personal')->where('personal_id="' . $request['idPersonal'] . '"');
$rows = $db->fetchAll($query);
?>

Hugo Arregui

Java + Hibernate (HQL)
getSession().createQuery("FROM User user WHERE id =
:id").setInteger("id", 1).uniqueResult();


Cesar Casas

Bien groncho en java

Connection conexion = DriverManager.getConnection ("jdbc:mysql://localhost

/usuarios","userdb", "passdb");
Statement s = conexion.createStatement();
ResultSet rs = s.executeQuery ("select * from Users where username='"+user+"' and password='"+pass+"');

new User(rs.next());