asp.netÁ¬½ÓSQLserver2005ÎÊÌâ
string userpossword;
SqlConnection conn = new SqlConnection("server=.\\SQL2005;uid=sa;pwd=sa;database=TongXunLuDB");
string strcon = "select userpassword from UserLoginInfo where username='admin'";
conn.Open();
SqlCommand cmd = new SqlCommand(strcon,conn);
SqlDataReader dr = cmd.ExecuteReader() ;
userpossword = dr["userpassword"].ToString();
return userpossword;
ÕâÊÇÁ¬½ÓµÄº¯Êý£¬Á¬½ÓÓ¦¸ÃûÓÖÎÊÌ⣬¾ÍÊÇdatareader±äÁ¿ÖÐûÓÐÖµ£¬ÔÚ²éѯ·ÖÎöÆ÷ÖÐÖ´ÐÐÉÏÃæµÄSQLÓï¾ä¿ÉÒÔ²é³öÀ´½á¹û£¬µ«Êǵ½Õâ¾ÍûÓнá¹û£¬drÀïÃæµÄ×Ö¶ÎûÓÖÎÊÌ⣬Õâµ½µ×ΪʲôÄØ£¬Õâô¼òµ¥µÄµØ·½£¬£¬£¬
µ¥²½µ÷ÊÔ¡£¡£¡£
µ÷ÁË£¬²»ÐË°¡
ÊÔ×ÅÕâÑùдһÏ£¡
SqlDataReader dr = cmd.ExecuteReader() ;
if(dr.Read())
{
userpossword = dr["userpassword"].ToString();
}
return userpossword;
ºÜ²»´í°¡¡£¶¥¡£¡£
Ïà¹ØÎÊ´ð£º
ASP.NET MVC¼Ü¹¹·¢²¼ÁË,ÄãÓÃÁËÂð£¿
»¹ÔÚѧϰÖÐ
ÎÒÒ²ÔÚѧϰ¡£ÂòÊ飬Ìý½Ì³Ì£¬¿´ÍøÉÏ×ÊÁÏ£¬ÏÂÔØÀý×Ó£¬¸Ð¾õÌý²»´íµÄ£¬²»¹ý±ÈÆ𹤳§Ä£Ê½£¬ËƺõÑ·É«Á˵㡣¡£¡£»¶Óµ½ÎÒ²©¿Í»¥Ïàѧϰ
¶¼ÓÃÁË5¸ö°æ±¾ÁË ´Ó PV1 µ½beta ......
<script type="text/javascript" src="js/Dialog.js"></script>
<script type="text/javascript">
function zOpenD()
{
va ......
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......
֮ǰÓöµ½Ò»¸öÎÊÌâ¡£
ÓÚÊÇ×öÁËÒÔÏÂʵÑ飺
Ò³Ãæ¼ÓÔغó£¬Ìá½»Ò»¸öAjaxÇëÇó(ÔݳÆΪajax1)£¬ÇëÇóµÄÏß³ÌÔÚ·þÎñÆ÷Éϱ»Ë¯Ãß10ÃëÖÓ¡£
µã»÷Ò³ÃæÉÏÒ»¸öbutton£¬´¥·¢ÁíÒ»¸öAjaxÇëÇó(ajax2)¡£
µ±Ã»ÓÐʹÓÃsession£¬ÔÚ·þÎñÆ÷δ´ ......