|
|
请使用QQ关联注册PLM之家,学习更多关于内容,更多精彩原创视频供你学习!
您需要 登录 才可以下载或查看,没有账号?注册
x
- $ a5 P0 p/ h8 S. `1 [
- MySQLConnect::MySQLConnect()" F; k4 w' U) Q
- {8 c& ^, V+ M L
, k R3 v9 g; K O! e- if (mysql_library_init(0, nullptr, nullptr))
- A* l( K/ G; }8 |2 v! Q - {( f3 w2 _* o( f- ]: m
- uc1601("CAPI初始化失败", 1);
@7 _( z4 h; T' }3 `1 E - }
3 t t$ N9 |2 A6 d4 f0 z3 U - if (mysql_init(&mysql) == nullptr)
' a* r/ ^7 v; C9 A* `$ ] - {
" C+ ~. ~* J, f, Z - uc1601("初始化数据库变量失败", 1);$ c* v/ k: l4 b
0 V* b, Y, A! \7 U. _* g/ p- }
/ @' K9 J7 Q p - if (mysql_options(&mysql, MYSQL_SET_CHARSET_NAME, "gbk"))
! s+ b, h9 ^$ @: b' G - {
6 n# H: O+ C |! p6 i8 B P - uc1601("设置连接选项失败", 1);
; h. u8 c! G2 z* t! @ - }
$ H8 `& B/ y, G ] Y# W7 R - }: k& R; e8 F% }! \- a$ w5 e
- / o2 d: r% K: A/ _8 \% n2 a
- bool MySQLConnect::ConnectDatabase()
7 o4 C0 m9 E( F8 _* D; i' e9 s - {
; t8 o V7 \" N+ \. } - //初始化mysql% a. W, G: o6 ?) S- Q) O% }
- ) n: v/ { u. Z/ q
- mysql_init(&mysql); 3 O* ]5 j" w3 r
- 3 ~# A( h7 N. I4 r9 |0 u+ N( V3 P
- //这个非常重要,否则打印出现乱码" f- @" T% ]' h p- G
- if (!mysql_set_character_set(&mysql, "gbk"))
& `9 m6 r; K+ r J$ T2 S" B - {
5 c0 i8 |* \: w6 F; m0 f - char msg[256];
% C/ \3 d( z# t) f f8 u - sprintf_s(msg, "Charset for the connection : %s\n", mysql_character_set_name(&mysql));
. `" ^2 @2 C$ m, H7 H5 Z - uc1601(msg, 0);
& D s: G7 r I% r( D5 X) T - }$ ]( ^- l7 L0 A$ i0 G/ L; K0 K
-
5 ]8 D' ?- j# L J6 C* F/ f - //连接mysql,数据库
1 a3 A& n( m' C' B. H1 D0 F - if (!(mysql_real_connect(&mysql,MYSQL_HOSTNAME , MYSQL_USERNAME,MYSQL_PASSWORD,MYSQL_DBNAME, MYSQL_DBPORT, NULL, 0))) + {6 n" S/ I Z0 B6 [/ A
- {
% B! L4 H% H' @* q X2 r% `5 y - char msg[1024];
* X% a- r' s3 z5 G! P - sprintf(msg,"Error connecting to database:%s\n", mysql_error(&mysql));+ o- X* T% y/ X! h6 t
- uc1601(msg, 1);2 T5 b/ S* M; x: H3 W
- return false;
0 e8 G+ Q9 |, n: |% e4 T- _) N - }) q8 v6 g I; b, |! c
- else- Y9 j" p5 g% L3 P8 D: \ F6 B. S
- {' \: m/ o" @" _$ b
- uc1601("数据库连接成功", 0);
* P5 S% f O( B# w | - return true;8 F+ K% z% V7 _# A- {
- }6 q, Z: d, E( {- U- N
-
2 \, R) e1 [* s2 a3 O1 S - }1 s, V; N) V r
复制代码
0 w0 A! J* D( m: j' d O+ Z5 K9 I3 X
5 o6 m& J2 K$ P9 |8 r' U9 bMySQL 链接数据库的方法,出现乱码,注意设置字符集& h# G' |# s1 ]8 B7 l4 {
% [2 M. t6 i) T/ E+ [
2 W% v- ~) K9 f$ r
|
|