package?contect;
import?java.util.Scanner;
import?java.sql.SQLException;
public?class?Add?extends?tection{

	public?void?add（）
	{
		Scanner?in?=?new?Scanner（System.in）;
		try?{
			
			rs=sm.executeQuery（“select?count（*）?from?phone“）;
			while（rs.next（））
			{
				int?c=rs.getInt（1）;
				if（c>14）{
				System.out.println（“存儲空間已滿！！“）;
			?????}
				
				else?{
			System.out.print（“請輸入聯系人信息:“?+?“\n“）;
			System.out.print（“姓名:“）;
			String?s1?=?in.next（）;

			rs?=?sm.executeQuery（“select?姓名?from?phone?where?姓名=‘“+?s1?+?“‘“）;
			
			if?（rs.next（））?{
				
				?System.out.println（“姓名重復！！“）;
				?
					continue;

			}

			System.out.print（“電話號碼：“）;
			int?s2?=?in.nextInt（）;

			rs?=?sm.executeQuery（“select?電話號碼?from?phone?where?電話號碼=“+s2）;
			if（rs.next（））?{

					System.out.println（“電話號碼重復！！“）;
					break;
				
			}

			System.out.print（“分類：“）;
			String?s3?=?in.next（）;
			System.out.print（“電子郵件：“）;
			String?s4?=?in.next（）;
			System.out.println（“儲存？?1.是；2.否；“）;
			int?m?=?in.nextInt（）;
			if?（m?==?1）?{

				sm?=?conn.createStatement（）;
				String?sql?=?“insert?into?phone?values（‘“?+?s1
						+?“‘“?+?s2?+?“‘“?+?s3?+?“‘‘“?+?s4
						+?“‘）“;

				sm.executeUpdate（sql）;
				System.out.println（“添加成功！“）;

				break;
			}
			if?（m?==?2）
				break;}}
			}
			
		catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????2819??2009-12-29?11:07??tection.java

?????文件???????1468??2009-12-29?11:02??Add.java

?????文件????3145728??2009-12-31?10:35??contect.mdf

?????文件????1048576??2009-12-31?10:35??contect_log.ldf

?????文件????????553??2009-12-29?11:03??Delect.java

?????文件????????587??2009-12-29?11:03??Diol.java

?????文件???????1069??2009-12-29?11:03??Edit.java

?????文件???????2066??2009-12-29?11:00??fenlei.java

?????文件????????737??2009-12-29?11:03??name.java

-----------?---------??----------?-----??----

??????????????4203603????????????????????9