webgis 考核.docx

DBservicesusing System;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Runtime.Serialization;usingSystem.ServiceModel;usingSystem.Text;usingSystem.Data.SqlClient;usingSystem.Data.OleDb;usingSystem.Data;namespace test13.Web{ // 注意: 使用“重构”菜单上的“重命名”命令，可以同时更改代码、svc 和配置文件中的类名“DBService”。 // 注意: 为了启动 WCF 测试客户端以测试此服务，请在解决方案资源管理器中选择DBService.svc或DBService.svc.cs，然后开始调试。public class DBService : IDBService {public void DoWork() { }publicboolQuerSQL(string userName, string passWord) {try {SqlConnection conn = new SqlConnection(Data Source=D410-26;Initial Catalog=Data;Integrated Security=SSPI);conn.Open();stringsql = select * from register_info where register_info.userName=@username and register_info.passWord=@pwd;SqlCommandcmd = new SqlCommand(sql, conn);cmd.Parameters.AddWithValue(@username, userName);cmd.Parameters.AddWithValue(@pwd, passWord);SqlDataAdapter da = new SqlDataAdapter(cmd);DataTabledt = new DataTable();da.Fill(dt);if (dt.Rows.Count 0) {return true; }else {return false; } }catch (Exception ex) {return false; } }publicboolcreateUser(string userName, string passWord, string Email, string Sex) {try { //连接数据库SqlConnection conn = new SqlConnection(Data Source=D410-26;Initial Catalog=Data;Integrated Security=SSPI);conn.Open(); //打开数据库 //设置command属性SqlCommand com = new SqlCommand();com.Connection = conn;com.CommandType = CommandType.Text; //操作数据库com.CommandText = insert into register_info([userName],[passWord],[Email],[Sex]) values ( + userName + , + passWord + , + Email + , + Sex + );com.ExecuteNonQuery();conn.Close();return true; }catch (Exception ex) {return false; } } }}IDservicesusing System;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Runtime.Serialization;usingSystem.ServiceModel;usingSys