六种流行的语言大餐---C、C++、python、Java、php、C#你更喜欢哪一个呢？

package cn.zxl.jmysql;

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

public class JMysql {
    
    private static final String DRIVER = "com.mysql.jdbc.Driver";
    private static final String URL = "jdbc:mysql://localhost/test";
    private static final String USERNAME = "root";
    private static final String PASSWORD = "一二三四五六";
    private static final String SQL = "select * from test";
    
    public static void main( String[] args ) {
        Connection connection = null;
        Statement statement = null;
        ResultSet resultSet = null;
        try {
            Class.forName(DRIVER);
            connection = DriverManager.getConnection(URL, USERNAME, PASSWORD);
            statement = connection.createStatement();
            resultSet = statement.executeQuery(SQL);
            while (resultSet.next()) {
                System.out.println("|" + resultSet.getString("id") + "|" + resultSet.getString("name") + "|");
            }
        } catch (Exception e) {
            System.out.println("query failed!");
        } finally {
            try {
                resultSet.close();
                statement.close();
                connection.close();
            } catch (Exception e) {
                throw new RuntimeException(e);
            }
        }
    }
    
}

《c_mysql.h》
#ifndef C_MYSQL_H_
#define C_MYSQL_H_

#include <stdio.h>
#include <stdlib.h>
#include <winsock二.h>
#include <windows.h>
#include <mysql.h>

void execute_sql(char* sql);

#endif

《c_mysql.c》
#include "c_mysql.h"

#define HOST "localhost"
#define USERNAME "root"
#define PASSWORD "一二三四五六"
#define DATABASE "test"

int main()
{
    char *sql = "select * from test";
    execute_sql(sql);
    return 0;
}

void execute_sql(char* sql)
{
    MYSQL connection;
    MYSQL_RES *result_pointer;
    MYSQL_ROW result_row;
    int result, row, column, i, j;
    mysql_init(&connection);
    if (NULL == mysql_real_connect(&connection, HOST, USERNAME, PASSWORD, DATABASE, 0, NULL, CLIENT_FOUND_ROWS))
    {
        printf("Error:connection failed!\n");
        return;
    }
    mysql_query(&connection, "set names gbk");
    result = mysql_query(&connection, sql);
    if (result)
    {
        printf("Error:query failed!\n");
        mysql_close(&connection);
        return;
    }
    result_pointer = mysql_store_result(&connection);
    if (result_pointer)
    {
        row = mysql_num_rows(result_pointer);
        for (i = 一; i < row + 一; i++)
        {
            result_row = mysql_fetch_row(result_pointer);
            printf("|%s|%s|\n", result_row[0] ,result_row[一]);
        }
    }
    mysql_close(&connection);
    system("pause");
}

《c++_mysql.h》
#ifndef C___MYSQL_H_
#define C___MYSQL_H_

#include <iostream>
#include <mysql_connection.h>   
#include <mysql_driver.h>   
#include <statement.h>
using namespace sql;   
using namespace std;

void execute_sql(const SQLString sql);

#endif

《c++_mysql.cpp》
#include "c++_mysql.h"

#define HOST "localhost"
#define USERNAME "root"
#define PASSWORD "一二三四五六"
#define DATABASE "test"

int main()
{
    const SQLString sql = "select * from test";
    execute_sql(sql);
    return 0;
}

void execute_sql(const SQLString sql)
{
    mysql::MySQL_Driver *driver;   
    Connection *connection;   
    Statement *statement;   
    ResultSet *result_set;   
    driver = mysql::get_mysql_driver_instance();   
    connection = driver->connect("tcp://localhost:三三0六", "root", "一二三四五六");   
    statement = connection->createStatement();   
    statement->execute("use test");  
    statement->execute("set names gbk");
    result_set = statement->executeQuery(sql);   
    while(result_set->next())   
    {   
        cout << "|" << result_set->getInt("id") << "|" << result_set->getString("name") << "|" << endl;   
    }   
    delete statement;   
    delete connection;  
    system("pause");
}

<?php
    $mysql_server_name="localhost";
    $mysql_username="root";
    $mysql_password="一二三四五六";
    $mysql_database="test";
    
    $connection = mysql_connect($mysql_server_name, $mysql_username,$mysql_password);
    if(!$connection) {
        echo "connection failed!";
        return;
    }
    mysql_set_charset("gbk",$connection);
    mysql_select_db($mysql_database, $connection);
    $sql="select * from test";
    $result=mysql_query($sql, $connection);
    while($row = mysql_fetch_array($result)) {
        echo "|".$row["id"]."|".$row["name"]."|\n";
    }
    mysql_close($connection);
?>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MySql.Data.MySqlClient;

namespace CSMysql
{
    class Program
    {
        static void Main(string[] args)
        {
            MySqlConnection connection = new MySqlConnection("Database='test';Data Source='localhost';User Id='root';Password='一二三四五六';charset='utf八';pooling=true");
            MySqlCo妹妹and co妹妹and = new MySqlCo妹妹and();
            co妹妹and.Connection = connection;
            co妹妹and.Co妹妹andText = "select * from test";
            try
            {
                co妹妹and.Connection.Open();
                MySqlDataReader reader = co妹妹and.ExecuteReader();
                while (reader.Read())
                {
                    Console.WriteLine("|" + reader.GetInt三二("id") + "|" + reader.GetString("name") + "|");
                }
                Console.ReadLine();
            }
            catch (Exception)
            {
                Console.WriteLine("query failed!");
            }
            finally
            {
                co妹妹and.Connection.Close();
            }
        }
    }
}

# coding=utf⑻
import MySQLdb
import sys
 
host = 'localhost'
user = 'root'
password  = '一二三四五六'   
db   = 'test'
 
 
if __name__ == '__main__':
    connection = MySQLdb.connect(host,user,password,db);
    try:
        connection.ping()
    except:
        print ('failed to connect MySQL.')
    sql = 'select * from test'
    cursor = connection.cursor()
    cursor.execute(sql)
    for row in cursor:
        print ("|" + str(row[0]) + "|" + row[一] + "|")
    cursor.close()
    connection.close()
    sys.exit()