MysqlµÄDBHelper.cs
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using MySql.Data.MySqlClient;
namespace i_salesDAL
{
public class DBHelper
{
//Òýµ¼Êý¾Ý¿âÁ¬½ÓÊý¾Ý¿âµ÷ÓÃWeb.ConfigÎļþ
private static MySqlConnection connection;
//´´½¨Á¬½Ó
public static MySqlConnection Connection
{
get
{
MySqlConnection myConn = new MySqlConnection("server=localhost;user id=root;password=root;database=google;CharSet=gb2312;");
string connectionString = myConn.ConnectionString;
if (connection == null)
{
connection = new MySqlConnection(connectionString);
//´ò¿ªÁ¬½Ó
connection.Open();
}
else if (connection.State == System.Data.ConnectionState.Closed)
{
connection.Open();
}
else if (connection.State == System.Data.ConnectionState.Broken)
{
connection.Close();
connection.Open();
}
return connection;
}
}
//£¨Î޲Σ©·µ»ØÖ´ÐеÄÐÐÊý(ɾ³ýÐ޸ĸüÐÂ)
public static int ExecuteCommand(string safeSql)
{
MySqlCommand cmd = new MySqlCommand(safeSql, Connection);
int result = cmd.ExecuteNonQuery();
return result;
}
//£¨ÓвΣ©
public static int ExecuteCommand(string sql, params MySqlParameter[] values)
{
MySqlCommand cmd = new MySqlCommand(sql, Connection);
cmd.Parameters.AddRange(values);
return cmd.ExecuteNonQuery();
}
//£¨Î޲Σ©·µ»ØµÚÒ»ÐеÚÒ»ÁÐ(ɾ³ýÐ޸ĸüÐÂ)
public static int GetScalar(string safeSql)
{
MySqlCommand cmd = new MySqlCommand(safeSql, Con
Ïà¹ØÎĵµ£º
1,ÔÚwindow×Ô´øµÄ·À»ðǽÀïµÄÀýÍâÌí¼Ó3306¶Ë¿Ú£¬ÎªTCP
2£¬½ñÌìÔÚÓÃÔ¶³ÌÁ¬½ÓMysql·þÎñÆ÷µÄÊý¾Ý¿â£¬²»¹ÜÔõôŪ¶¼ÊÇÁ¬½Ó²»µ½£¬´íÎó´úÂëÊÇ1130£¬ERROR 1130: Host 192.168.2.159 is not allowed to connect to this MySQL server
²ÂÏëÊÇÎÞ·¨¸øÔ¶³ÌÁ¬½ÓµÄÓû§È¨ÏÞÎÊÌâ¡£½á¹ûÕâÑù×Ó²Ù×÷mysql¿â£¬¼´¿É½â¾ö¡£ÔÚ±¾»úµÇÈëmysqlºó£¬¸ ......
¼ÇµÃǰÌìÓÐÈËÎÊÎÒ£¬ Memcache ºÍ MySQL ×Ô¼ºµÄ Query Cache ÓÐÉ¶Çø±ð? ÎÒÕâÑù»Ø´ðµÄ£¬Ç°ÕßÊÇɽկÖеÄÕ½¶·»ú£¬ºóÕßÊǹٷ½µÄÕ½¶·»ú¡£
ÐÂÊֻشðÎÊÌ⣬´íÁËι֡£¹þ¹þ¹þ¡£
ºÃÏñϸ½ÚÉϵIJî±ð»¹ÊÇÓеġ£
MemcacheÓŵãÈçÏ£º
1. ÀíÂÛÉÏ¿ÉÒÔÖ§³ÅÎÞÏÞ²¢·¢ÒµÎñ²Ù×÷¡£
2. ¿ÉÒÔÆôÓõ¥¶ÀµÄʵÀýÀ´»º´æ¾Þ¶àµÄÊý¾Ý¡££¨µ± ......
ÓкܶàÅóÓÑËäÈ»°²×°ºÃÁË MySQL µ«È´²»ÖªÈçºÎʹÓÃËü¡£ÔÚÕâÆªÎÄÕÂÖÐÎÒÃǾʹÓÁ¬½Ó MySQL¡¢ÐÞ¸ÄÃÜÂë¡¢Ôö¼ÓÓû§µÈ·½ÃæÀ´Ñ§Ï°Ò»Ð© MySQL µÄ³£ÓÃÃüÁî¡£
Ò»¡¢Á¬½ÓMySQL¡£
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë
1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡£
¡¡¡¡Ê×ÏÈÔÚ´ò¿ª DOS ´°¿Ú£¬È»ºó½øÈëĿ¼ mysql\bin£¬ÔÙ¼üÈëÃüÁîmysql -u ......
http://www.cnblogs.com/neonlight/archive/2008/08/25/1276178.html
½üÒ»¶Îʱ¼ä£¬ºÜ¶à²¿ÃÅͬÊ·´Ó³ÔÚʹÓÃmysqlµÄ¹ý³Ì³öÏÖÊý¾Ý¿âÁ¬½Ó×Ô¶¯¶Ï¿ªµÄÎÊÌ⣬ÎÒ¶Ô¸ÃÎÊÌâ×öÁËһЩʵÑé¡£
¹ØÓÚmysql×Ô¶¯¶Ï¿ªµÄÎÊÌâÑо¿½á¹ûÈçÏ£¬ÔÚmysqlÖÐÓÐÏà¹Ø²ÎÊýÉ趨£¬µ±Êý¾Ý¿âÁ¬½Ó¿ÕÏÐÒ»¶¨Ê±¼äºó£¬·þÎñÆ÷¾Í
»á¶Ï¿ªµÈ´ý³¬Ê±µÄÁ¬½Ó£º
1¡¢Ïà¹Ø²Î ......
package com.google.i_sales.service.data;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashSet;
import java.util.List;
import java.util.Locale;
import java.uti ......