简介：C/C++学习，请私信我 “代码” 获取六种语言连接mysql数据库的代码展示，在小编的尝试的过程中，无论是语言环境搭建、mysql依赖库的导入还是代码的风格，各种语言都各有千秋。接下来，我们就让这些语言一一登场吧。C ...
|
C/C++学习，请私信我 “代码” 获取 六种语言连接mysql数据库的代码展示，在小编的尝试的过程中，无论是语言环境搭建、mysql依赖库的导入还是代码的风格，各种语言都各有千秋。接下来，我们就让这些语言一一登场吧。
C/C++学习，请私信我 “代码” 获取 Java（最具噱头的语言）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 = "123456"; 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); } } } }
#ifndef C_MYSQL_H_#define C_MYSQL_H_#include <stdio.h>#include <stdlib.h>#include <winsock2.h>#include <windows.h>#include <mysql.h>void execute_sql(char* sql);#endifc_mysql.c 文件 #include "c_mysql.h"#define HOST "localhost"#define USERNAME "root"#define PASSWORD "123456"#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!"); return; } mysql_query(&connection, "set names gbk"); result = mysql_query(&connection, sql); if (result) { printf("Error:query failed!"); mysql_close(&connection); return; } result_pointer = mysql_store_result(&connection); if (result_pointer) { row = mysql_num_rows(result_pointer); for (i = 1; i < row + 1; i++) { result_row = mysql_fetch_row(result_pointer); printf("|%s|%s|", result_row[0] ,result_row[1]); } } mysql_close(&connection); system("pause");}
C/C++学习，请私信我 “代码” 获取 写C语言的时候，使用&、*、->这些符号感觉特别爽。C++（最神秘莫测的语言）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);#endifc++_mysql.cpp #include "c++_mysql.h"#define HOST "localhost"#define USERNAME "root"#define PASSWORD "123456"#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:3306", "root", "123456"); 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");}
C/C++学习，请私信我 “代码” 获取 C++这个mysql连接的方式，其API与Java的相似度极高，粗略估计大约有90%左右。因此C++的程序除了异常捕捉和内存清理与Java有些区别之外，其它的代码非常相似。但用->感觉瞬间高大上很多php（最低调奢华的语言）PHP虽然近期也很火，但是总觉得它有点低调，但又不失内涵。作为网站制作最适合的语言之一，它总是默默的在发挥自己的力量。<?php $mysql_server_name="localhost"; $mysql_username="root"; $mysql_password="123456"; $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"]."|"; } mysql_close($connection);?>
C/C++学习，请私信我 “代码” 获取 如果仔细观察会发现，PHP的API与C语言非常相似，这是因为PHP是使用DLL来扩展的mysql操作导致的。此外，PHP与前面三个不同的是，它不是编译型语言，是一种服务端的脚本语言。C#（最具潜力的语言） C#最近虽然也算火爆，但却似乎一直有些力不从心的感觉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="123456";charset="utf8";pooling=true"); MySqlCommand command = new MySqlCommand(); command.Connection = connection; command.CommandText = "select * from test"; try { command.Connection.Open(); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Console.WriteLine("|" + reader.GetInt32("id") + "|" + reader.GetString("name") + "|"); } Console.ReadLine(); } catch (Exception) { Console.WriteLine("query failed!"); } finally { command.Connection.Close(); } } }}
C/C++学习，请私信我 “代码” 获取 C#的API有些特别，而且看到有command就难免让人联想到command模式，不知这API里面的实现是否是command设计模式。总的来说，C#和Java的mysql操作API还是差别比较大的.python（最高端大气上档次的语言）# coding=utf-8import MySQLdbimport syshost = "localhost"user = "root"password = "123456" 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[1] + "|") cursor.close() connection.close() sys.exit()
C/C++学习，请私信我 “代码” 获取 到此，六种语言的简单展示就结束了。就本次语言小旅游来说，小编更喜欢C/C++这块地，高端的编码样式直接征服了小编不知道各位猿友有没有对哪个怦然心动呢？（版权声明，原文出自出处：左潇龙的技术博客）
C/C++学习，请私信我 “代码” 获取 本文仅代表作者个人观点，不代表巅云官方发声，对观点有疑义请先联系作者本人进行修改，若内容非法请联系平台管理员，邮箱2522407257@qq.com。更多相关资讯，请到巅云www.rzxsoft.cn学习互联网营销技术请到巅云建站www.rzxsoft.cn。 |
