package?Dao;
import?java.sql.*;

import?javax.websocket.Session;

import?h.Zz;

public?class?HzDao?{
	public?static?Connection?getConnection（）?throws?ClassNotFoundException
			SQLException?{
		Class.forName（“com.microsoft.sqlserver.jdbc.SQLServerDriver“）;
		Connection?conn?=?DriverManager.getConnection（
				“jdbc:sqlserver://localhost:1433;DatabaseName=PC?Store;“?“hz“
				“123“）;
		return?conn;
	}

	public?void?deleteHz（int?id）{
	
		try?{
			Connection?connect?=?getConnection（）;
			PreparedStatement?ps;
			ResultSet?rs;
			
			String?sql=“select?*?from??GouWuChe?where?number=“+id;
			ps=?connect.prepareStatement（sql）;
			rs=ps.executeQuery（）;
????????	if（rs.next（））
????????	{
????????		sql=“delete?from??GouWuChe?where?number=“+id;
????			ps=?connect.prepareStatement（sql）;
????			ps.executeUpdate（）;
????????	}
			
			sql?=?“delete?from??pc_message?where?id=“+id;
????????????ps=?connect.prepareStatement（sql）;
????????????ps.executeUpdate（）;???
		}?catch?（Exception?e）?{
			
			e.printStackTrace（）;
		}?
		
	}
	
	public?void?inputHz（int?ZhangHaoint?number）{
	
		try?{
			Connection?connect?=?getConnection（）;
			ResultSet?rs;
			String?sql?=?“select?*?from??GouWuChe?where?ZhangHao=??and?number=?“;
????????????PreparedStatement?ps?=?connect.prepareStatement（sql）;
????????????ps.setInt（1?ZhangHao）;
????????????ps.setInt（2?number）;
????????	rs=ps.executeQuery（）;
????????	if（!rs.next（））
????????	{
????????		sql?=?“insert?into?GouWuChe?values（??）“;
????????????????ps?=?connect.prepareStatement（sql）;
????????????????ps.setInt（1?ZhangHao）;
????????????????ps.setInt（2?number）;
????????????????ps.executeUpdate（）;?
????????????????System.out.print（ZhangHao+“?“+number）;
????????	}
????		
		}?catch?（Exception?e）?{
			
			e.printStackTrace（）;
		}?
		
	}
}
	

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

?????文件????????842??2018-05-17?12:39??HZ\.classpath

?????文件????????902??2018-05-17?12:39??HZ\.project

?????文件????????567??2018-05-17?12:39??HZ\.settings\.jsdtscope

?????文件????????364??2018-05-17?12:39??HZ\.settings\org.eclipse.jdt.core.prefs

?????文件????????458??2018-05-17?12:39??HZ\.settings\org.eclipse.wst.common.component

?????文件????????345??2018-05-17?12:39??HZ\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2018-05-17?12:39??HZ\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2018-05-17?12:39??HZ\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????2688??2018-07-07?23:20??HZ\build\classes\Dao\HzDao.class

?????文件???????1618??2018-07-07?23:20??HZ\build\classes\Dao\YonghuDao.class

?????文件???????1987??2018-07-07?23:20??HZ\build\classes\h\Zz.class

?????文件????????858??2018-07-07?23:20??HZ\build\classes\s\cc.class

?????文件????????875??2018-07-07?23:20??HZ\build\classes\s\HH.class

?????文件???????2435??2018-07-07?23:20??HZ\build\classes\s\lj.class

?????文件???????2401??2018-06-20?16:59??HZ\PC?Store.sql

?????文件???????1847??2018-06-20?13:01??HZ\src\Dao\HzDao.java

?????文件????????789??2018-06-28?14:31??HZ\src\Dao\YonghuDao.java

?????文件???????1212??2018-06-16?13:41??HZ\src\h\Zz.java

?????文件????????474??2018-06-19?20:59??HZ\src\s\cc.java

?????文件????????462??2018-06-29?12:24??HZ\src\s\HH.java

?????文件???????2602??2018-06-19?21:05??HZ\src\s\lj.java

?????文件???????1638??2018-06-17?16:28??HZ\WebContent\Delete.jsp

?????文件????????694??2018-06-19?21:55??HZ\WebContent\deleteBean.jsp

?????文件???????1443??2018-06-28?14:39??HZ\WebContent\denglu.jsp

?????文件???????6308??2018-06-24?22:14??HZ\WebContent\GouWuChe.jsp

?????文件???????3359??2018-06-24?22:14??HZ\WebContent\GouWuChengGong.jsp

?????文件???????4569??2018-06-24?22:14??HZ\WebContent\GouWuXinXi.jsp

?????文件?????659213??2017-08-25?09:38??HZ\WebContent\hh.jpg

?????文件????????810??2018-06-20?11:50??HZ\WebContent\inputBean.jsp

?????文件???????3022??2018-06-16?15:13??HZ\WebContent\Insert.jsp

............此處省略36個文件信息