ÅжÏMySQLÁ¬½ÓÊÇ·ñÓÐЧ
²Î¼û¹Ù·½²Î¿¼£¬µÚ25Õ£ºAPIºÍ¿â
25.2.3.49. mysql_ping()
int
mysql_ping(MYSQL *mysql)
ÃèÊö
¼ì²éÓë·þÎñÆ÷µÄÁ¬½ÓÊÇ·ñ¹¤×÷¡£Èç¹ûÁ¬½Ó¶ªÊ§£¬½«×Ô¶¯³¢ÊÔÔÙÁ¬½Ó¡£
¸Ãº¯Êý¿É±»ÏÐÖÃÁ˽ϳ¤Ê±¼äµÄ¿Í»§¶ËʹÓã¬ÓÃÒÔ¼ì²é·þÎñÆ÷ÊÇ·ñÒѹرÕÁËÁ¬½Ó£¬²¢ÔÚ±ØÒªÊ±ÔÙ´ÎÁ¬½Ó¡£
·µ»ØÖµ
Èç¹ûÓë·þÎñÆ÷µÄÁ¬½ÓÓÐЧ·µ»Ø0
¡£Èç¹û³öÏÖ´íÎ󣬷µ»Ø·Ç0
Öµ¡£·µ»ØµÄ·Ç0
Öµ²»±íʾMySQL
·þÎñÆ÷±¾ÉíÊÇ·ñÒѹرգ¬Á¬½Ó¿ÉÄÜÒòÆäËûÔÒòÖÕ¶Ë£¬ÈçÍøÂçÎÊÌâµÈ¡£
´íÎó
·
CR_COMMANDS_OUT_OF_SYNC
ÒÔ²»Ç¡µ±µÄ˳ÐòÖ´ÐÐÁËÃüÁî¡£
·
CR_SERVER_GONE_ERROR
MySQL
·þÎñÆ÷²»¿ÉÓá£
·
CR_UNKNOWN_ERROR
³öÏÖδ֪´íÎó¡£
MySQL-pythonÖÐÓë¸ÃAPI¶ÔÓ¦µÄÊÇconn.ping()
Ïà¹ØÎĵµ£º
<?php
/*
*PHP¹ÜÀíMYSQLµÄÊý¾Ý¿âÀà
ʹÓ÷½·¨£º$dbConn = new DbConn([$Êý¾Ý¿âÃû(¿ÉÑ¡)]);
ÔÊÐí·µ»ØµÄ·½·¨£º
Execute($sql) //Ö´ÐÐSQLÓï¾ä£¬Ã»Óзµ»ØÖµ;
getRs($sql) //·µ»Ø²éѯÓï¾äµÄ¼Ç¼£¬Ò»Ìõ;
getRsArray($sql) //·µ» ......
½¨Á¢Ìõ¼þÊ×ÏÈÒ»¶¨ÒªÈ·¶¨×Ô¼ºµÄmysql£¬tomcat,eclipseÁ¬½ÓÊÇÕýÈ·µÄ¡£
index.jspºÜ¼òµ¥£¬¾ÍÒ»¸öÌø×ª¡£
<%
response.sendRedirect("lg.jsp");
%>
lg.jsp ʵÏֵǼ¿ò¼Ü
<%@ page contentType="text/html; charset=utf-8" %>
<html>
<head>
<title>
login
</title>
</hea ......
package com.project.ajaxs;
import java.io.BufferedReader;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.io.OutputStream;
import java.io.OutputStreamWriter;
import java.util.Calendar;
import java.uti ......