• silverlight通过WCF连接数据库之增删改查


     1 using System;
     2 using System.Collections.Generic;
     3 using System.Linq;
     4 using System.Runtime.Serialization;
     5 using System.ServiceModel;
     6 using System.Text;
     7 
     8 namespace HouseShopping.Web.APPData.Login
     9 {
    10     // 注意: 使用“重构”菜单上的“重命名”命令,可以同时更改代码和配置文件中的接口名“ILoginAndResister”。
    11     [ServiceContract]
    12     public interface ILoginAndResister
    13     {
    14         [OperationContract]
    15         void OpenSQL();
    16         [OperationContract]
    17         void CloseSQL();
    18         [OperationContract]
    19         string QuerySQL(string UserName, string pwd);
    20         [OperationContract]
    21         int AddUsers(string Username, string pwd);
    22         [OperationContract]
    23         int UpdateUsers(string Username, string pwd);
    24         [OperationContract]
    25         int DeleteUsers(string Username);
    26     }
    27 }
    ILoginAndRegister
      1 using System;
      2 using System.Collections.Generic;
      3 using System.Data;
      4 using System.Data.SqlClient;
      5 using System.Linq;
      6 using System.Runtime.Serialization;
      7 using System.ServiceModel;
      8 using System.Text;
      9 
     10 namespace HouseShopping.Web.APPData.Login
     11 {
     12     // 注意: 使用“重构”菜单上的“重命名”命令,可以同时更改代码、svc 和配置文件中的类名“LoginAndResister”。
     13     // 注意: 为了启动 WCF 测试客户端以测试此服务,请在解决方案资源管理器中选择 LoginAndResister.svc 或 LoginAndResister.svc.cs,然后开始调试。
     14     public class LoginAndResister : ILoginAndResister
     15     {
     16         SqlConnection strCon = new SqlConnection(@"server=.MySql;database=AnJuKe_DB;user id=sa;password=123;");
     17         //server=SQLServer服务器名称;database=数据库名称;uid=用户名;pwd=密码"
     18         public void OpenSQL()
     19         {
     20             strCon.Open();
     21         }
     22 
     23         public void CloseSQL()
     24         {
     25             strCon.Close();
     26         }
     27         public string QuerySQL(string UserName, string pwd)
     28         {
     29             try
     30             {
     31                 OpenSQL();
     32                 string strSql = string.Format("select * from T_Users where Name like '%{0}%' and Password like '%{1}%'", UserName, pwd);
     33                 DataSet ds = new DataSet();
     34                 SqlDataAdapter s = new SqlDataAdapter(strSql, strCon);
     35                 s.Fill(ds);
     36                 return ds.GetXml();
     37             }
     38             catch (Exception ex)
     39             {
     40                 throw ex;
     41             }
     42             finally
     43             {
     44                 CloseSQL();
     45             }
     46         }
     47         public int AddUsers(string Username, string pwd)
     48         {
     49 
     50             try
     51             {
     52                 OpenSQL();
     53                 string strInsert = "insert into T_Users values('" + Username + "','" + pwd + "')";
     54                 SqlCommand cmd = new SqlCommand(strInsert, strCon);
     55                 return cmd.ExecuteNonQuery();
     56             }
     57             catch (Exception ex)
     58             {
     59                 throw ex;
     60             }
     61             finally
     62             {
     63                 CloseSQL();
     64             }
     65 
     66         }
     67         public int UpdateUsers(string Username, string pwd)
     68         {
     69 
     70             try
     71             {
     72                 OpenSQL();
     73                 string strUpdate = "UPDATE T_Users SET Password = '" + pwd + "' WHERE Name = '" + Username + "'";
     74                 SqlCommand cmd = new SqlCommand(strUpdate, strCon);
     75                 return cmd.ExecuteNonQuery();
     76             }
     77             catch (Exception ex)
     78             {
     79                 throw ex;
     80             }
     81             finally
     82             {
     83                 CloseSQL();
     84             }
     85         }
     86         public int DeleteUsers(string Username)
     87         {
     88             try
     89             {
     90                 OpenSQL();
     91                 string strDelete = "delete from T_Users where Name='" + Username + "'";
     92                 SqlCommand cmd = new SqlCommand(strDelete, strCon);
     93                 return cmd.ExecuteNonQuery();
     94             }
     95             catch (Exception ex)
     96             {
     97                 throw ex;
     98             }
     99             finally
    100             {
    101                 CloseSQL();
    102             }
    103         }
    104     }
    105 }
    LoginAndRegister
     1 using System;
     2 using System.Collections.Generic;
     3 using System.IO;
     4 using System.Net;
     5 using System.Windows;
     6 using System.Windows.Controls;
     7 using System.Windows.Documents;
     8 using System.Windows.Ink;
     9 using System.Windows.Input;
    10 using System.Windows.Media;
    11 using System.Windows.Media.Animation;
    12 using System.Windows.Shapes;
    13 using System.Xml;
    14 using HouseShopping.MyLoginService;
    15 
    16 namespace HouseShopping.MyClasses
    17 {
    18     public class UsersManageClass
    19     {
    20       private  LoginAndResisterClient client;
    21       private TextBlock tb;
    22         private string Username;
    23         public void BeginRegister( string UserName,string pwd)
    24         {           
    25             client = new LoginAndResisterClient();
    26             client.AddUsersCompleted += client_AddUsersCompleted;
    27             client.AddUsersAsync(UserName, pwd);
    28         }
    29         void client_AddUsersCompleted(object sender, AddUsersCompletedEventArgs e)
    30         {
    31             if (Convert.ToInt32(e.Result) > 0)
    32             {
    33                 MessageBox.Show("注册成功!恭喜你!", "注册", MessageBoxButton.OK);
    34               
    35             }
    36         }
    37         public void BeginLogin(string username, string pwd, TextBlock tbIn)
    38         {
    39             tb = tbIn;
    40             Username = username;
    41             client = new LoginAndResisterClient();
    42             client.QuerySQLCompleted += client_QuerySQLCompleted;
    43             client.QuerySQLAsync(username, pwd);
    44         }
    45         void client_QuerySQLCompleted(object sender, QuerySQLCompletedEventArgs e)
    46         {
    47             List<Information> inforList = new List<Information>();
    48             using (XmlReader xReader = XmlReader.Create(new StringReader(e.Result)))
    49             {
    50                 inforList.Clear();
    51                 //XmlReader读取XML数据
    52                 while (xReader.ReadToFollowing("Table"))
    53                 {
    54                     xReader.ReadToDescendant("Id");
    55                     int Id = xReader.ReadElementContentAsInt();
    56                     xReader.ReadToDescendant("Name");
    57                     string name = xReader.ReadContentAsString();
    58                     xReader.ReadToDescendant("Password");
    59                     string pwd = xReader.ReadContentAsString();
    60                     Information carlocation = new Information() { Id = Id, Name = name, Pwd = pwd };
    61                     inforList.Add(carlocation);
    62                 }
    63             }
    64             if (inforList.Count > 0)
    65             {
    66                 MessageBox.Show("登录成功!恭喜你!", "登录", MessageBoxButton.OK);
    67                 tb.Text = Username+"欢迎你";
    68             }
    69             else
    70                 MessageBox.Show("登录失败!", "登录", MessageBoxButton.OK);  
    71         }
    72         public class Information
    73         {
    74             public int Id { get; set; }
    75             public string Name { get; set; }
    76             public string Pwd { get; set; }
    77         }
    78     }
    79 }
    UsersManage
     1   private void btnLogin_Click(object sender, RoutedEventArgs e)
     2          {
     3              UsersManageClass usermanage = new UsersManageClass();
     4              usermanage.BeginLogin(txtName.Text.Trim(), txtPwd.Password.Trim(),tbLogin);
     5          }
     6          
     7          private void btnRegister_Click(object sender, RoutedEventArgs e)
     8          {          
     9              UsersManageClass usermanage = new UsersManageClass();
    10              usermanage.BeginRegister(txtName.Text.Trim(), txtPwd.Password.Trim());
    11          }
    12         
    调用
      1 using System;
      2 using System.Collections.Generic;
      3 using System.Data;
      4 using System.Data.SqlClient;
      5 using System.Linq;
      6 using System.Runtime.Serialization;
      7 using System.ServiceModel;
      8 using System.Text;
      9 
     10 namespace Test1.Web.APPData
     11 {
     12     // 注意: 使用“重构”菜单上的“重命名”命令,可以同时更改代码、svc 和配置文件中的类名“login”。
     13     // 注意: 为了启动 WCF 测试客户端以测试此服务,请在解决方案资源管理器中选择 login.svc 或 login.svc.cs,然后开始调试。
     14     public class Login : ILogin
     15     {
     16         SqlConnection strCon = new SqlConnection(@"server=.MySql;database=AnJuKe_DB;user id=sa;password=123;");
     17         //server=SQLServer服务器名称;database=数据库名称;uid=用户名;pwd=密码"
     18         public void OpenSQL()
     19         {
     20             strCon.Open();
     21         }
     22 
     23         public void CloseSQL()
     24         {
     25             strCon.Close();
     26         }
     27         public string QuerySQL(string UserName,string pwd)
     28         {
     29             try
     30             {
     31                 OpenSQL();
     32                 string strSql = string.Format("select * from T_Users where Name like '%{0}%' and Password like '%{1}%'",UserName,pwd);
     33                 DataSet ds = new DataSet();
     34                 SqlDataAdapter s = new SqlDataAdapter(strSql, strCon);
     35                 s.Fill(ds);
     36                 return ds.GetXml();
     37             }
     38             catch (Exception ex)
     39             {
     40                 throw ex;
     41             }
     42             finally
     43             {
     44                 CloseSQL();
     45             }
     46         }
     47         public int  AddUsers(string Username, string pwd)
     48         {
     49           
     50             try
     51             {              
     52                 OpenSQL();
     53                 string strInsert = "insert into T_Users values('"+Username +"','"+pwd+"')";
     54                 SqlCommand cmd = new SqlCommand(strInsert, strCon);
     55              return  cmd.ExecuteNonQuery();              
     56             }
     57             catch (Exception ex)
     58             {
     59                 throw ex;
     60             }
     61             finally
     62             {
     63                 CloseSQL();               
     64             }
     65 
     66         }
     67         public int UpdateUsers(string Username, string pwd)
     68         {
     69 
     70             try
     71             {
     72                 OpenSQL();
     73                 string strUpdate = "UPDATE T_Users SET Password = '"+pwd+"' WHERE Name = '"+Username+"'";
     74                 SqlCommand cmd = new SqlCommand(strUpdate, strCon);
     75               return  cmd.ExecuteNonQuery();
     76             }
     77             catch (Exception ex)
     78             {
     79                 throw ex;
     80             }
     81             finally
     82             {
     83                 CloseSQL();
     84             }
     85         }
     86         public int DeleteUsers(string Username)
     87         {
     88             try
     89             {
     90                 OpenSQL();
     91                 string strDelete = "delete from T_Users where Name='"+Username+"'";               
     92                 SqlCommand cmd = new SqlCommand(strDelete, strCon);
     93                 return cmd.ExecuteNonQuery();
     94             }
     95             catch (Exception ex)
     96             {
     97                 throw ex;
     98             }
     99             finally
    100             {
    101                 CloseSQL();
    102             }
    103         }
    104     }
    105 }
    增删改查
  • 相关阅读:
    用一条UPDATE语句交换两列的值
    js之事件冒泡和事件捕获详细介绍
    C# String与string的区别
    setTimeout()和setInterval()方法的区别?
    jQuery的.bind()、.live()和.delegate()之间区别
    在Hyper-V虚拟机中使用Wi-Fi上网
    调整框架的尺寸,是否显示滚动条,跳出框架
    调整框架的尺寸
    查看jquery绑定的事件函数
    Onload,Onunload,onbeforeunload,$(window).load(function() {})和$(document).ready(function(){})
  • 原文地址:https://www.cnblogs.com/rockman/p/3301440.html
Copyright © 2020-2023  润新知