asp.netÊý¾Ý¿â²Ù×÷Àà(´æ´¢¹ý³Ì´¦Àí)
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.ComponentModel;
namespace SQLHelper
{
/// <summary>
/// Class1 µÄժҪ˵Ã÷¡£
/// </summary>
public class SQLHelper
{
// Á¬½ÓÊý¾ÝÔ´
private SqlConnection myConnection;
private readonly string RETURNVALUE = "RETURNVALUE";
/// <summary>
/// ´ò¿ªÊý¾Ý¿âÁ¬½Ó.
/// </summary>
private void Open()
{
// ´ò¿ªÊý¾Ý¿âÁ¬½Ó
if (myConnection == null)
{
myConnection = new SqlConnection(ConfigurationSettings.AppSettings["SQLCONNECTIONSTRING"].ToString());
}
if(myConnection.State == ConnectionState.Closed)
{
try
{
///´ò¿ªÊý¾Ý¿âÁ¬½Ó
myConnection.Open();
}
catch(Exception ex)
{
SystemError.SystemLog(ex.Message);
}
finally
{
///¹Ø±ÕÒѾ´ò¿ªµÄÊý¾Ý¿âÁ¬½Ó
}
}
}
/// <summary>
/// ¹Ø±ÕÊý¾Ý¿âÁ¬½Ó
/// </summary>
public void Close()
{
///ÅжÏÁ¬½ÓÊÇ·ñÒѾ´´½¨
if(myConnection != null)
{
///ÅжÏÁ¬½ÓµÄ״̬ÊÇ·ñ´ò¿ª
if(myConnection.State == ConnectionState.Open)
{
myConnection.Close();
&
Ïà¹ØÎĵµ£º
ASP.NET δ±»ÊÚȨ·ÃÎÊËùÇëÇóµÄ×ÊÔ´¡£Ç뿼ÂÇÊÚÓè ASP.NET ÇëÇó±êʶ·ÃÎÊ´Ë×ÊÔ´µÄȨÏÞ¡£ASP.NET ÓÐÒ»¸öÔÚÓ¦ÓóÌÐòûÓÐÄ£ÄâʱʹÓõĻù½ø³Ì±êʶ(ͨ³££¬ÔÚ IIS 5 ÉÏΪ {MACHINE}\ASPNET£¬ÔÚ IIS 6 ÉÏÎªÍøÂç·þÎñ)¡£Èç¹ûÓ¦ÓóÌÐòÕýÔÚͨ¹ý Ä£Ä⣬Ôò±êʶ½«ÎªÄäÃûÓû§(ͨ³£Îª IUSR_MACHINENAME)»ò¾¹ýÉí·ÝÑéÖ¤µÄÇëÇóÓû§¡£
ÈôÒªÊÚÓè ......
//postÇëÇó
string name = Request["name"].toString();
string name =Request.Form.Get("name").toString();
//getÇëÇó
string name = Request.QueryString["name"].toString();
µ«ÎÒ·¢ÏÖ ÎÞÂÛÊÇ·ñÊÇpostÓëget´«Öµ
¶¼¿ÉÓÃstring name = Request["name"].toString();
±íµ¥Ìá½»ÖÐgetºÍpost·½Ê½µ ......
½éÉÜ
»º´æÊÇÔÚÄÚ´æ´æ´¢Êý¾ÝµÄÒ»Ïî¼¼Êõ£¬Ò²ÊÇASP.NETÖÐÌṩµÄÖØÒªÌØÐÔÖ®Ò»¡£ÀýÈçÄã¿ÉÒÔÔÚ¸´ÔÓ²éѯµÄʱºò»º´æÊý¾Ý£¬ÕâÑùºóÀ´µÄÇëÇó¾Í²»ÐèÒª´ÓÊý¾Ý¿âÖÐÈ¡Êý¾Ý£¬¶øÊÇÖ±½Ó´Ó»º´æÖлñÈ¡¡£Í¨¹ýʹÓûº´æ¿ÉÒÔÌá¸ßÓ¦ÓóÌÐòµÄÐÔÄÜ¡£
Ö÷ÒªÓÐÁ½ÖÖÀàÐ͵Ļº´æ£º
1.Êä³ö»º´æOutput caching
2.Êý¾Ý»º´æData caching
1. Êä³ö»º´æ(Output ......
Õâ¸öÊôÐÔÊÇÓÃÀ´ÑéÖ¤¿Í»§¶ËÓû§µÄÊäÈëµÄ,ÓÃÀ´ÑéÖ¤Óû§µÄÊäÈëÖÐÊÇ·ñÓÐΣÏÕ×Ö·ûµÄ,Õâ¸öÊôÐÔµÄĬÈÏֵΪtrue,΢ÈíÖ®ËùÒÔÕâô×öÊÇΪÁËÌá¸ßasp.net³ÌÐòµÄ°²È«ÐÔ,ËùÒԺܶà³ÌÐòÔ±¼´Ê¹²»ÖªµÀÔõôÀ´·ÀÓùºÚ¿ÍµÄ¹¥»÷,asp.netµÄһЩĬÈÏÊôÐÔµÈÄÚÈÝÒѾ¶Ô°²È«½øÐÐÁË¿ØÖÆ,ÕâÒ²ÊÇΪʲôasp.netµÄ³ÌÐòÏà¶ÔÀ´Ëµ±È½Ï°²È«µÄÔÒò!
¡¡¡¡¼ÈÈ»Õâ¸öÊô ......
Ò»£¬JS¶¯Ì¬´´½¨±íµ¥
var result = " <form method='post' action='../xiazai.aspx'><table width='100%' border='0' cellpadding='0' cellspacing='1' bgcolor='#BDB4A2'>"+
"&l ......