TAG:
<P>iTbulo.COM <BR> <BR>偶也不知道算不算,反正我自己随时写的用,很粗浅的,适合跟我一样的新手收藏,指不定就用得上呢!</P> <P>一组是我这两天写留言本的另组是以前VS2003写投票用的</P> <P>高手看见的话,麻烦把好的解决方案说下,谢谢哦!!新手的话,共同学习了!!</P> <P>--------下面是我最近写个留言本用的------------<BR> public static OleDbConnection con()<BR> {//数据库连接类<BR> OleDbConnection con = new OleDbConnection(ConfigurationManager.ConnectionStrings["book"].ConnectionString);<BR> return con;<BR> }<BR> public static bool insert(string que)<BR> { //根据传进来的SQL语句执行插入操作<BR> OleDbConnection con = odb.con();<BR> con.Open();<BR> OleDbCommand cmd = new OleDbCommand(que,con);<BR> int count = Convert.ToInt32(cmd.ExecuteNonQuery());<BR> if (count > 0)<BR> return true;<BR> else<BR> return false;<BR> con.Close();<BR> }<BR> public static DataTable ds(string que)<BR> {//返回一个装载了SQL制定留言的数据表,<BR> OleDbConnection con = odb.con();<BR> OleDbDataAdapter oda = new OleDbDataAdapter();<BR> oda.SelectCommand=new OleDbCommand(que,con);<BR> DataSet ds = new DataSet();<BR> oda.Fill(ds,"thc");<BR> return ds.Tables["thc"];<BR> con.Close();<BR> }<BR> public static bool img(string que)<BR> {//根据传来的条件查询该项是否有内容,有就返回true<BR> OleDbConnection con = odb.con();<BR> con.Open();<BR> OleDbCommand cmd = new OleDbCommand(que,con);<BR> if (cmd.ExecuteScalar().ToString() != "")<BR> return true;<BR> else<BR> return false;<BR> con.Close();<BR> }<BR> public static string scr(string que)<BR> {//同样是根据传来的SQL语句返回一个字段的值,我不太喜欢把SQL语句做在内中,感觉不灵活 <BR> OleDbConnection con = odb.con();<BR> con.Open();<BR> OleDbCommand cmd = new OleDbCommand(que,con);<BR> return cmd.ExecuteScalar().ToString();<BR> }</P> <P>-----------下面是以前2003的时候用的----------<BR>public static SqlConnection con()<BR> {//(静态)初始化链接,因为数据库路径在web.config文件里面,所以这里返回的是哪个字符串,这是VS2003的数据库连接初始实例<BR> SqlConnection con=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["con"]);<BR> return con;<BR> }<BR> public static bool chklog(string name,string pwd)<BR> {//判断数据库里是否存在这个用户,返回真或则假<BR> SqlConnection con=db.con();<BR> con.Open();<BR> SqlCommand cmd=new SqlCommand("select count(*) from admin where name='"+name+"' and pwd='"+pwd+"'",con);<BR> int count=Convert.ToInt32(cmd.ExecuteScalar());<BR> if(count>0) <BR> {<BR> return true;<BR> }<BR> else<BR> {<BR> return false;<BR> }<BR> }<BR> public static string chkqx(string name,string pwd)<BR> {//判断当前用户的权限,并返回权限<BR> SqlConnection con=db.con();<BR> con.Open();<BR> SqlCommand cmd=new SqlCommand("select qx from admin where name='"+name+"' and pwd='"+pwd+"'",con);<BR> string qx=Convert.ToString(cmd.ExecuteScalar());<BR> return qx;<BR> }<BR> public static DataTable fill(string query)<BR> {//根据传来的SQL语句查询出数据并填充一个表给查询对象<BR> SqlConnection con=db.con();<BR> SqlDataAdapter sda=new SqlDataAdapter();<BR> sda.SelectCommand=new SqlCommand(query,con);<BR> DataSet ds=new DataSet();<BR> sda.Fill(ds,"vote");<BR> return ds.Tables["vote"];<BR> <BR> }<BR> public static string title(int ID)<BR> {//(静态)根据传来的ID返回该投票项标题<BR> SqlConnection con=db.con();<BR> con.Open();<BR> SqlCommand cmd=new SqlCommand("select xiang from votemaster where id='"+ID+"'",con);<BR> return cmd.ExecuteScalar().ToString();<BR> }<BR> public static void delete(string query)<BR> {//(静态)执行指定的删除行为<BR> SqlConnection con=db.con();<BR> con.Open();<BR> SqlCommand cmd=new SqlCommand(query,con);<BR> cmd.ExecuteNonQuery();<BR> }<BR> public static void update(string query)<BR> {//(静态)执行指定的更新行为<BR> SqlConnection con=db.con();<BR> con.Open();<BR> SqlCommand cmd=new SqlCommand(query,con);<BR> cmd.ExecuteNonQuery();<BR> }<BR> public static int cid(string query)<BR> {//(静态)根据执行的语句查询出当前数据库最新的一个ID<BR> SqlConnection con=db.con();<BR> con.Open();<BR> SqlCommand cmd=new SqlCommand(query,con);<BR> int id=Convert.ToInt32(cmd.ExecuteScalar());<BR> return id;<BR> }<BR> public static bool insert(string query)<BR> {//插入操作<BR> SqlConnection con=db.con();<BR> con.Open();<BR> SqlCommand cmd=new SqlCommand(query,con); <BR> int count=Convert.ToInt32(cmd.ExecuteNonQuery());<BR> if(count>0)<BR> {<BR> return true;<BR> }<BR> else<BR> {<BR> return false;<BR> }<BR> }<BR> public static int typ(int id)<BR> {//根据出来的ID,返回该ID所属于的投票属于多选还是单选<BR> SqlConnection con=db.con();<BR> con.Open();<BR> SqlCommand cmd=new SqlCommand("select typ from votemaster where id='"+id+"'",con);<BR> int typ=Convert.ToInt32(cmd.ExecuteScalar());<BR> return typ;<BR> }<BR> public static string count()<BR> {//返回总访问人数<BR> SqlConnection con=db.con();<BR> con.Open();<BR> SqlCommand cmd=new SqlCommand("select coun from countline",con);<BR> string count=cmd.ExecuteScalar().ToString();<BR> return count;<BR> }<BR> public static string rengyi(string query)<BR> {//查询任意单字段,返回字段值的一个静态方法<BR> SqlConnection con=db.con();<BR> con.Open();<BR> SqlCommand cmd=new SqlCommand(query,con);<BR> return cmd.ExecuteScalar().ToString();<BR> }<BR> public static bool vlog(string query)<BR> {//查询任意单字段,返回真与假的一个静态方法<BR> SqlConnection con=db.con();<BR> con.Open();<BR> SqlCommand cmd=new SqlCommand(query,con);<BR> int count=Convert.ToInt32(cmd.ExecuteScalar());<BR> if(count>0)<BR> {<BR> return true;<BR> }<BR> else<BR> {<BR> return false;<BR> }<BR> }<BR><a href="http://thcjp.cnblogs.com/archive/2006/06/18/428775.html" target="_blank" >http://thcjp.cnblogs.com/archive/2006/06/18/428775.html</A></P> (iwgh) |