web课堂代码.docx
- 文档编号:4634141
- 上传时间:2023-05-07
- 格式:DOCX
- 页数:70
- 大小:144.25KB
web课堂代码.docx
《web课堂代码.docx》由会员分享,可在线阅读,更多相关《web课堂代码.docx(70页珍藏版)》请在冰点文库上搜索。
web课堂代码
SqlHelper类
usingSystem;
usingSystem.Collections.Generic;
usingSystem.Linq;
usingSystem.Web;
usingSystem.Data;
usingSystem.Data.SqlClient;
usingSystem.Configuration;
///
///SqlHelper的摘要说明
///
publicclassSqlHelper
{
//staticstringconnstr="server=172.17.81.246;database=musicbar;uid=web;pwd=web";
//staticstringconnstr=System.Configuration.ConfigurationManager.ConnectionStrings["mystring"].ConnectionString;
//staticstringconnstr="server=(local);database=musicbar;IntegratedSecurity=SSPI";
privatestaticstringconnstr=ConfigurationManager.ConnectionStrings["localConnectionString"].ConnectionString.ToString();
publicSqlHelper()
{
//
//TODO:
在此处添加构造函数逻辑
//
}
///
///insertdeleteupdate
///
///
///
publicstaticintExecuteNonQuery(stringsql)
{
SqlConnectionconn=newSqlConnection(connstr);
SqlCommandcomm=newSqlCommand(sql,conn);
conn.Open();
intret=comm.ExecuteNonQuery();
conn.Close();
returnret;
}
///
///select,表
///
///
///
publicstaticDataTableExecuteQuery(stringsql)
{
SqlConnectionconn=newSqlConnection(connstr);
SqlDataAdapterda=newSqlDataAdapter(sql,conn);
DataSetds=newDataSet();
da.Fill(ds);
returnds.Tables[0];
}
///
///SELECT,只取结果中的第一行,第一列的值
///
///
///
publicstaticObjectExecuteScalar(stringsql)
{
SqlConnectionconn=newSqlConnection(connstr);
SqlCommandcomm=newSqlCommand(sql,conn);
conn.Open();
objectret=comm.ExecuteScalar();
conn.Close();
returnret;//null
}
}
JavaScript举例
DOCTYPEhtmlPUBLIC"-//W3C//DTDXHTML1.0Transitional//EN""http:
//www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
//www.w3.org/1999/xhtml">
functioncloseme()
{
if(window.confirm("你真的关闭吗?
"))
window.close();
else{
window.location.hreg=""}
}
functionopenme()
{
window.open("");
}
varleft=50;
vartop=50;
functionmove()
{
vardiv=window.document.getElementById("smallwindows");
left+=1;
top+=1;
div.style.left=left;
div.style.top=top;
}
vart=setInterval(move,1000);
functionstop()
{
clearInterval(t);
}
id="Button2"type="button"value="打开"onclick="openme()"/>
id="Button3"type="button"value="停止"onclick="stop()"/>
absolute;left: 198px">