ÔõÑù½«MySQLÊý¾Ý¿â±¸·ÝÎļþÓÃʱ¼äÃüÃû
ÔõÑù½«MySQLÊý¾Ý¿â±¸·ÝÎļþÓÃʱ¼äÃüÃû ¸÷λ´óϺ Ö¸µãÏ ×îºÃÊÇ´úÂë »òÕßʵÀý!
±¸·ÝÎļþÄã°®ÔõôÃüÃû²»¾ÍÔõôÃüÃûÂð£¿ÕâÓÐʲôÎÊÌâÄØ¡£
Java code:
// ¶ÁÈ¡ÊôÐÔÖµ
public static Properties getPprVue(String properName) {
InputStream inputStream = mysql_util.class.getClassLoader().getResourceAsStream(properName);
Properties p = new Properties();
try {
p.load(inputStream);
inputStream.close();
} catch (IOException e) {
e.printStackTrace();
}
return p;
}public String backupMysql() {
Properties pros = getPprVue("prop.properties");
// ÕâÀïÊǶÁÈ¡µÄÊôÐÔÎļþ£¬Ò²¿ÉÒÔÖ±½ÓʹÓÃ
String username = pros.getProperty("username");
String password = pros.getProperty("password");
// µÃµ½MYSQLµÄÓû§ÃûÃÜÂëºóµ÷Óà mysql µÄ cmd:
String mysqlpaths = pros.getProperty("mysqlpath");
String databaseName = pros.getProperty("databaseName");
String address = pros.getProperty("address");
String sqlpath = pros.getProperty("sql");
File backupath = new File(sqlpath);
if (!backupath.exists()) {
backupath.mkdir();
}
StringBuffer sb = new StringBuffer();
sb.app
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿
ÃÜÂëÐ޸ķ½·¨£º
1.ÒÔϵͳ¹ ......
´ó¼Ò°ïÎÒ¿´Ï°ɣ¬±¾À´Êý¾Ý¿âûÓж«Î÷£¬ÄÜÏÔʾûÓж«Î÷µÄÐÅÏ¢£¬µ«ÊÇÎÒÌí¼ÓÁËÒ»ÌõÄÚÈݺó£¬×ÖûÁË£¬µ«ÊÇͼƬҲÎÞ·¨ÏÔʾ£¬ºì²æ²æÒ²Ã»ÓУ¬Ôõô»ØÊ°¡£¿
PHP code:
<?php
$str="select * from product wh ......
PHPCMSÆóÒµ»ÆÒ³2008·ÖÒ³ÎÊÌâ
ÎÒÓÃÒÔÏ·½Ê½Ç󯽾ùÊý
{get sql="SELECT DISTINCT c.*,
(select round(avg(sort1)) from `phpcms_yp_dp` where userid=c.userid) avgsort1,
(select round(avg(avgp ......