- 浏览: 429851 次
- 性别:
- 来自: 北京
文章分类
- 全部博客 (144)
- java (32)
- Flex (11)
- linux (15)
- 思维至上 (2)
- 生活 (4)
- spring2.5.5 (3)
- Design pattern (0)
- jdk1.6 (1)
- erlang (14)
- mysql (5)
- nginx (10)
- 互联网 (1)
- 用户体验 (0)
- jvm (8)
- hibernate (0)
- oracle (0)
- mvn (2)
- 23种常用设计模式详细讲解及实例 (1)
- nosql (1)
- mongodb (2)
- thrift (1)
- 负载均衡 (1)
- Objective-c (1)
- fuck (1)
- resin (3)
- log4j (2)
- android (1)
- jps (0)
- lucene (2)
- rsync (1)
- python (1)
- java性能分析 (1)
- spring (1)
- zookeeper (2)
- error (1)
- 算法 (1)
- hudson (1)
- svn (1)
- maven (1)
- svn server (2)
- swap linux (1)
- 协同过滤 (1)
- 邮件系统 (1)
最新评论
-
cheetah747:
我也遇到这个问题了,不过我是直接把第三方jar放到工程文件的l ...
JAVA NoClassDefFoundError: -
dxm1986:
hillfallshore 写道亲 你这是杜撰的小说吗?完全是 ...
面试有感 -
dxm1986:
mengda1027 写道从实习生到高级java到架构师,是在 ...
面试有感 -
dxm1986:
kljjack 写道一个编程十几年,每年看几十本技术书籍,技术 ...
面试有感 -
dxm1986:
轻指飞扬 写道呵呵,挺好玩的~ 我怎么感觉你招人不是很有诚意嘛 ...
面试有感
erlang连接到mysql数据库
一,驱动的下载与安装
1. 下载erlang-mysql-driver
下载地址如下:
svn checkout http://erlang-mysql-driver.googlecode.com/svn/trunk/ mysql
(如果你没有安装SVN,附件中提供源码下载)
2. 对src下面的所有源码进行编译
erlc *.erl
3. 然后在mysql 下面创建ebin,并将src 下面的所有*.beam拷贝到ebin 下面
4. 将mysql整个文件夹拷贝到erlang/lib下面
二, 操作数据库
1 连接mysql:
mysql:start_link(PoolId, "localhost", "root", "password", "databasename").
2 mysql:connect(PoolId, Host, ?PORT, User, Password, Database, undefined,
Reconnect).%%建立一个连接
3 数据操作
添加:
mysql:fetch(PoolId,<<”insert into….”>>).
查询:
mysql:fetch(p1,<<"select * from user">>).
4 接收到数据后怎么处理
fetch(PoolId, "select * from user") -> Result
%%% Result = {data, MySQLRes} | {updated, MySQLRes} |
%%% {error, MySQLRes}
n 查询:{data, MySQLRes} = fetch(PoolId, <<"select * from user">>).
Ø 获取字段名称信息:
FieldInfo = mysql:get_result_field_info(MysqlRes).
Ø 获取字段值:
AllRows = mysql:get_result_rows(MysqlRes)
n 更新:
{updated,UD} = mysql: fetch(PoolId, <<"update * from user">>).
AffectedRow = mysql:get_result_affected_rows(UD).%%获得影响的记录数
n 出错
{error,Err} = fetch(PoolId, <<"update * from user">>).
Reason = mysql:get_result_reason(MysqlRes).%%出错原因
- erlang-mysql-driver-read-only.rar (46.4 KB)
- 下载次数: 139
评论
<p> </p>
<p> </p>
<p class="MsoListParagraph"><span lang="EN-US"><strong>一,</strong></span><span><strong>驱动的下载与安装</strong></span></p>
<p class="MsoListParagraph" style="margin-left: 21.0pt; text-indent: 0cm;"><span lang="EN-US"> </span></p>
<p class="MsoListParagraph"><span><span style="font-size: 12.0pt;" lang="EN-US"><span>1.<span style="font: 7.0pt ;">
</span></span></span></span><span>下载</span><span style="font-size: 12.0pt;" lang="EN-US">e</span><span><span lang="EN-US">rlang-mysql-driver</span></span><span></span></p>
<p class="MsoListParagraph" style="margin-left: 42.0pt; text-indent: 0cm;"><span><span lang="EN-US"><span> </span></span></span><span><span>下载地址如下:</span></span><span></span></p>
<p class="MsoListParagraph" style="margin-left: 42.0pt; text-indent: 0cm;"><span><span lang="EN-US"><span> </span></span></span><span><span lang="EN-US">svn checkout http://erlang-mysql-driver.googlecode.com/svn/trunk/
<span> </span>mysql</span></span></p>
<p class="MsoListParagraph" style="margin-left: 42.0pt; text-indent: 0cm;"><span><span lang="EN-US"> <span style="color: #339966;"><strong>(如果你没有安装SVN,附件中提供源码下载)</strong></span></span></span></p>
<p class="MsoListParagraph"><span><span lang="EN-US"><span>2.<span style="font: 7.0pt ;">
</span></span></span></span><span><span lang="EN-US"><span> </span></span></span><span><span>对</span></span><span><span lang="EN-US">src</span></span><span><span>下面的所有源码进行编译</span></span><span></span></p>
<p class="MsoListParagraph" style="margin-left: 42.0pt; text-indent: 0cm;"><span><span lang="EN-US"><span> </span>erlc *.erl</span></span></p>
<p class="MsoListParagraph" style="margin-left: 21.0pt; text-indent: 0cm;"><span><span lang="EN-US"> </span></span></p>
<p class="MsoListParagraph"><span><span lang="EN-US"><span>3.<span style="font: 7.0pt ;">
</span></span></span></span><span><span lang="EN-US"><span> </span></span></span><span><span>然后在</span></span><span><span lang="EN-US">mysql </span></span><span><span>下面创建</span></span><span><span lang="EN-US">ebin</span></span><span><span>,并将</span></span><span><span lang="EN-US">src </span></span><span><span>下面的所有</span></span><span><span lang="EN-US">*.beam</span></span><span><span>拷贝到</span></span><span><span lang="EN-US">ebin<span> </span></span></span><span><span>下面</span></span><span></span></p>
<p class="MsoListParagraph"><span><span lang="EN-US"><span>4.<span style="font: 7.0pt ;">
</span></span></span></span><span><span lang="EN-US"><span> </span></span></span><span><span>将</span></span><span><span lang="EN-US">mysql</span></span><span><span>整个文件夹拷贝到</span></span><span><span lang="EN-US">erlang/lib</span></span><span><span>下面</span></span><span></span></p>
<p class="MsoListParagraph" style="margin-left: 21.0pt; text-indent: 0cm;"><span><span lang="EN-US"> </span></span></p>
<p class="MsoListParagraph"><span><span lang="EN-US"><strong>二,</strong><span style="font: 7.0pt ;"><strong>
</strong></span></span></span><span><span><strong>操作数据库</strong></span></span><span></span></p>
<p class="MsoListParagraph"><span><span lang="EN-US"><span>1<span style="font: 7.0pt ;">
</span></span></span></span><span><span><strong>连接</strong></span></span><span><span lang="EN-US"><strong>mysql:</strong></span></span></p>
<p class="MsoListParagraph" style="margin-left: 63.0pt; text-indent: 0cm;"><span><span lang="EN-US">mysql:start_link(</span></span><span lang="EN-US">PoolId</span><span><span lang="EN-US">,
"localhost", "root", "password", "databasename").</span></span></p>
<p class="MsoListParagraph" style="margin-left: 63.0pt; text-indent: 0cm;"><span lang="EN-US"> </span></p>
<p class="MsoListParagraph"><span lang="EN-US"><span style="white-space: pre;"> </span>2<span> </span>mysql:connect(PoolId,
Host, ?PORT, User, Password, Database, undefined,</span></p>
<p class="MsoListParagraph" style="margin-left: 21.0pt; text-indent: 0cm;"><span lang="EN-US"><span> </span><span>
</span>Reconnect).<strong>%%</strong></span><span><strong>建立一个连接</strong></span></p>
<p class="MsoListParagraph" style="margin-left: 21.0pt; text-indent: 0cm;"><span lang="EN-US"> </span></p>
<p class="MsoNormal" style="margin-left: 21.0pt;"><span lang="EN-US">3<span> </span></span><span><strong>数据操作</strong></span></p>
<p class="MsoNormal" style="margin-left: 21.0pt;"><span lang="EN-US"><span> </span></span><span><strong>添加:</strong></span></p>
<p class="MsoListParagraph" style="margin-left: 63.0pt; text-indent: 0cm;"><span lang="EN-US">mysql:fetch(PoolId,<<”insert into….”>>).</span></p>
<p class="MsoListParagraph" style="margin-left: 63.0pt; text-indent: 0cm;"><span> <strong>查询:</strong></span></p>
<p class="MsoListParagraph" style="margin-left: 63.0pt; text-indent: 0cm;"><span lang="EN-US">mysql:fetch(p1,<<"select * from
user">>).</span></p>
<p class="MsoListParagraph" style="margin-left: 63.0pt; text-indent: 0cm;"> </p>
<p class="MsoListParagraph" style="margin-left: 63.0pt; text-indent: 0cm;">
</p>
<p class="MsoListParagraph" style="margin-left: 21pt; text-indent: 0cm; text-align: left;"><span lang="EN-US"><strong>4 </strong></span><span style=""><strong>接收到数据后怎么处理</strong></span></p>
<p class="MsoListParagraph" style="margin-left: 21pt; text-align: left;"><span lang="EN-US"><span style=""> </span>fetch(PoolId,
"select * from user") -> Result</span></p>
<p class="MsoListParagraph" style="margin-left: 21pt; text-align: left;"><span lang="EN-US"><span style=""> </span>%%%<span style=""> </span>Result = {data, MySQLRes} | {updated,
MySQLRes} |</span></p>
<p class="MsoListParagraph" style="margin-left: 21pt; text-indent: 0cm; text-align: left;"><span lang="EN-US"><span style=""> </span>%%%<span style=""> </span>{error, MySQLRes}</span></p>
<p class="MsoListParagraph" style="margin-left: 21pt; text-indent: 0cm; text-align: left;"><span lang="EN-US"> </span></p>
<p class="MsoListParagraph" style=""><span style="font-family: Wingdings;" lang="EN-US"><span style="">n<span style='font: 7.0pt "Times New Roman";'> </span></span></span><span style=""><strong>查询</strong>:</span><span lang="EN-US">{data,
MySQLRes} = fetch(PoolId, <<"select * from user">>).</span></p>
<p class="MsoListParagraph" style=""><span style="font-family: Wingdings;" lang="EN-US"><span style="">Ø<span style='font: 7.0pt "Times New Roman";'> </span></span></span><span style="">获取字段名称信息</span><span lang="EN-US">:</span></p>
<p class="MsoListParagraph" style="margin-left: 42pt; text-indent: 0cm; text-align: left;"><span lang="EN-US"><span style=""> </span><span style="">
</span>FieldInfo = mysql:get_result_field_info(MysqlRes).</span></p>
<p class="MsoListParagraph" style=""><span style="font-family: Wingdings;" lang="EN-US"><span style="">Ø<span style='font: 7.0pt "Times New Roman";'> </span></span></span><span style="">获取字段值:</span></p>
<p class="MsoListParagraph" style="margin-left: 42pt; text-indent: 0cm; text-align: left;"><span lang="EN-US"><span style=""> </span><span style="">
</span>AllRows<span style=""> </span>=
mysql:get_result_rows(MysqlRes)</span></p>
<p class="MsoListParagraph" style="margin-left: 21pt; text-indent: 0cm; text-align: left;"><span lang="EN-US"><span style=""> </span></span></p>
<p class="MsoListParagraph" style=""><span style="font-family: Wingdings;" lang="EN-US"><span style="">n<span style='font: 7.0pt "Times New Roman";'> </span></span></span><span style=""><strong>更新</strong></span><span lang="EN-US"><strong>:</strong></span></p>
<p class="MsoListParagraph" style="margin-left: 78.15pt; text-indent: 0cm; text-align: left;"><span lang="EN-US">{updated,UD} = mysql: fetch(PoolId, <<"update
<span style=""> </span>* from user">>).</span></p>
<p class="MsoListParagraph" style="margin-left: 21pt; text-indent: 0cm; text-align: left;"><span lang="EN-US"><span style=""> </span><span style="">
</span><span style=""> </span><span style=""> </span>AffectedRow = mysql:get_result_affected_rows(UD).%%</span><span style="">获得影响的记录数</span></p>
<p class="MsoListParagraph" style="margin-left: 21pt; text-indent: 0cm; text-align: left;"><span lang="EN-US"> </span></p>
<p class="MsoListParagraph" style=""><span style="font-family: Wingdings;" lang="EN-US"><span style="">n<span style='font: 7.0pt "Times New Roman";'> <strong> </strong></span></span></span><span style=""><strong>出错</strong></span></p>
<p class="MsoListParagraph" style="margin-left: 78.15pt; text-indent: 0cm; text-align: left;"><span lang="EN-US">{error,Err} = fetch(PoolId, <<"update
<span style=""> </span>* from user">>).</span></p>
<p class="MsoListParagraph" style="margin-left: 78.15pt; text-indent: 0cm; text-align: left;"><span lang="EN-US">Reason<span style=""> </span>= mysql:get_result_reason(MysqlRes).%%</span><span style="">出错原因</span></p>
</div><br/>注意mysql:start_link的第八个参数encoding,设置为utf8,以支持中文
发表评论
-
erlang for 循环
2011-05-05 13:41 2612erlang怎么执行for循环? - ... -
erlang常见问题一二三
2011-04-07 08:37 2174最近在从事erlang开发过程中遇到了几个问题,在这里一一记录 ... -
erlang编译一直出错,出错,错。。。。。
2011-03-10 17:44 1120之前在内网(windows)进行编译erlang的时候 ... -
erlang connect to mongodb
2011-03-03 15:43 4150erlang connect to mongodb ... -
erlang talk to java
2011-03-02 16:58 1234Erlang: Let’s talk to java ... -
Erlang/OTP简介
2011-02-23 10:28 2246简单介绍 OTP (Open Telecom Platfo ... -
MochiWeb在linux下安装注意问题
2011-02-17 11:47 1449MochiWeb在linux下安装注意问题 (20 ... -
linux下面Erlang,Mochiweb的安装
2011-02-17 11:40 3286linux 下面安装erlang 1 去erl ... -
Mochiweb的设计分析续
2011-02-16 15:05 1482这都是在headers函数中进行的,还是看mochi ... -
Mochiweb的设计分析
2011-02-16 15:03 1709Mochiweb的设计分析 March 15th, ... -
erlang入门笔记
2011-02-12 11:15 2335erlang入门笔记 2008-06-20 ... -
Programming Erlang 第6章 编译和运行(完整)
2011-02-11 17:55 5693编译和运行 译者: gashero ... -
ERLang简介
2011-02-11 17:53 1720Erlang入门 (2008-02-17 ...
相关推荐
erlang 连接 mysql 源码下载
编译的ERLANG使用MYSQL的beam文件~~也包括源文件
Erlang与Mysql对接,必须添加的。
erlang 连接学习例子 最简单的通讯例子
使用erlang语言实现连接ElasticSearch服务器的客户端代码
erlang具有良好的高并发性 支持热更新 本代码适合初学者更快的上手
erlang语言的mysql驱动接口,需要的收藏之
英雄远征erlang源码 + MySql 数据库
通过该接口直接调用各种sql语句
英雄远征服务器端erlang源码,用mysql数据库
介绍客户端允许连接到MySQL服务器并执行SQL查询。 它提供了连接池机制以提高并发效率。 客户端是用Erlang编写的,并且非常接近MySQL Connector / C接口。 它可以称为MySQL Connector / Erlang,但在功能上有一些限制...
ErlPort 是一个Erlang 库,用来帮助连接 Erlang 与其他编程语言。目前支持的是 Python 和 Ruby。Erlang 库使用 Erlang 端口协议 来简化Erlang 语言和 Erlang 外部术语格式 的连接,设置良好的数据类型映射。 ...
从 Erlang 到 CERL 到 Golang
PGO ... 要尝试pgo只需通过替换要连接到的数据库的host , database , user和password值来修改config/example.config即可: [ { pgo , [{ pools , [{ default , #{ pool_size => 10 , host =>
Erlang MySQL connection Driver
1、数据信息采用基于HTML5的大负载架构设计(Erlang)的长连接推送技术,高效且节省资源; 2、提供金融短讯、操作建议、经验秘籍等栏目功能; 3、应用运行时可设置是否待机功能,应用在后台运行时根据设置可关闭在线...
erlang入门电子书 erlang编程 Introducing Erlang,作者Simon.St.Laurent
它使用连接到PostgreSQL数据库。 使用docker设置Erlang.org 跑步: 码头工人组成 然后连接到并享受。 Erlang / OTP 使用Erlang / OTP 18.3。 请按照上的说明安装Erlang / OTP。 配置ops.config 编辑文件rel/ops...
远古封神Server(erlang源码)+文档+mongodb数据库 远古封神Server(erlang源码)+文档+mongodb数据库
erlang 安装包