service1.asmx.cs

图书馆里系统 很好的计算机毕业设计的参考 资料 里面有PPT和 文档资料 大家来顶一下

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.Web;
using System.Web.Services;
using System.Data .SqlClient ;

namespace WS1
{
	/// <summary>
	/// Service1 的摘要说明。
	/// </summary>
	public class Service1 : System.Web.Services.WebService
	{
		public Service1()
		{
			//CODEGEN: 该调用是 ASP.NET Web 服务设计器所必需的
			InitializeComponent();
		}
	private	DataSet ds;

		#region 组件设计器生成的代码
		
		//Web 服务设计器所必需的
		private IContainer components = null;
				
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
		}

		/// <summary>
		/// 清理所有正在使用的资源。
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if(disposing && components != null)
			{
				components.Dispose();
			}
			base.Dispose(disposing);		
		}
		
		#endregion

	//向数据库添加记录！

		[WebMethod]
		public bool Add(string ISBN,string Title,string au,string pub,string b)
		{
			SqlConnection sc=new SqlConnection ();
			sc.ConnectionString ="Server=HOME;DataBase=Book;Uid=sa;Pwd=";
			SqlCommand cmd=new SqlCommand ();
			cmd.CommandText ="insert into books values('"+ISBN+"','"+Title+"','"+au+"','"+pub+"','"+b+"')";
			cmd.Connection =sc;
			sc.Open ();
			if(cmd.ExecuteNonQuery ()>0)
			{
				sc.Close ();
				return true;
			}
			else
			{
				sc.Close ();
				return false;
			}
		}
	//向数据库中更新记录
      [WebMethod]
		public bool Update(string ISBN,string Title,string au,string pub,string b)
		{
			SqlConnection sc=new SqlConnection ();
			sc.ConnectionString ="Server=HOME;DataBase=Book;Uid=sa;Pwd=";
			SqlCommand cmd=new SqlCommand ();
			cmd.CommandText ="update books set Title='"+Title+"',Author='"+au+"',Publisher='"+pub+"',Brief='"+b+"' where ISBN='"+ISBN+"'";
			cmd.Connection =sc;
			sc.Open ();
			if(cmd.ExecuteNonQuery ()>0)
			{
				sc.Close ();
				return true;
			}
			else
			{
				sc.Close ();
				return false;
			}
		}
		//删除数据库中的记录

		[WebMethod]
		public bool Delete(string ISBN)
		{
			
		

				SqlConnection sc=new SqlConnection ();
				sc.ConnectionString ="Server=HOME;DataBase=Book;Uid=sa;Pwd=";
				SqlCommand cmd=new SqlCommand ();
				cmd.CommandText ="delete  from books where ISBN='"+ISBN+"'";
				cmd.Connection =sc;
				sc.Open ();
				if(cmd.ExecuteNonQuery ()>0)
				{
					sc.Close ();
					return true;
				}
				else
				{
					sc.Close ();
					return false;
				}
			
			
		}
		//查看数据库中的信息
		[WebMethod]
		public DataSet See()
		{
			SqlConnection sc=new SqlConnection ();
			sc.ConnectionString ="Server=HOME;DataBase=Book;Uid=sa;Pwd=";
			string str="select * from books ";
			SqlDataAdapter sa=new SqlDataAdapter(str,sc); 
			ds=new DataSet ();
			if(sa.Fill(ds)>0)
			{
				return ds;
			}
			else{return ds;}
            
		}
	//查看数据库中的单条信息
		[WebMethod]
		public DataSet See1(string ISBN)
		{
			try
			{
				SqlConnection sc=new SqlConnection ();
				sc.ConnectionString ="Server=HOME;DataBase=Book;Uid=sa;Pwd=";
				string str="select * from books where ISBN='"+ISBN+"' ";
				SqlDataAdapter sa=new SqlDataAdapter(str,sc); 
				ds=new DataSet ();
				if(sa.Fill(ds)>0)
				{
					return ds;
				}
				else{return ds;}
			}
			catch(FormatException e)
			{
				throw new Exception("ISBN 输入不正确，请重新输入ISBN !",e); 
			}
			
		}
	}
}