package?com.moon.jeeems.bs;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;

import?com.moon.jeeems.db.DBUtils;

public?class?CodeLogBS?{

	public?boolean?CheckCodeIsIn（String?code）{
		Connection?conn?=?null;
		PreparedStatement?ps?=?null;
		ResultSet?rs?=?null;
		try?{
			conn?=?DBUtils.getConnection（）;
			ps?=?conn
					.prepareStatement（“select?code?from?code_log?where?code=?“）;
			ps.setString（1?code）;
			rs=ps.executeQuery（）;
			if?（rs.next（））?{
				System.out.println（“注冊碼已經存在...不能用..“）;
				return?false;
			}else?{
				System.out.println（“注冊碼不存在...可用..“）;
				return?true;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}finally{
			DBUtils.close（rs）;
			DBUtils.close（ps）;
			DBUtils.close（conn）;
		}
		return?false;
	}
	
	public?boolean?CheckEquIdIsInGcbj（String?equId）{
		Connection?conn?=?null;
		PreparedStatement?ps?=?null;
		ResultSet?rs?=?null;
		try?{
			conn?=?DBUtils.getConnection（）;
			ps?=?conn
					.prepareStatement（“select?id?from?equ_log?where?equId=?“）;
			ps.setString（1?equId）;
			rs=ps.executeQuery（）;
			if?（rs.next（））?{
				int?id?=?rs.getInt（1）;
				ps?=?conn.prepareStatement（“select?id?from?gcbj_log?where?id=?“）;
				ps.setInt（1?id）;
				rs=ps.executeQuery（）;
				if（rs.next（））{
					System.out.println（“設備存在.....“）;
					return?true;
				}else{
					System.out.println（“設備存在...沒有附件....“）;
					return?false;
				}
			}else?{
				System.out.println（“設備不存在.....“）;
				return?false;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}finally{
			DBUtils.close（rs）;
			DBUtils.close（ps）;
			DBUtils.close（conn）;
		}
		return?false;
	}
}

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

?????文件???????5227??2009-04-27?08:55??項目源程序\jeeems\.classpath

?????文件????????470??2009-05-10?14:16??項目源程序\jeeems\.myhibernatedata

?????文件????????291??2009-05-20?23:08??項目源程序\jeeems\.mymetadata

?????文件????????262??2009-04-27?08:55??項目源程序\jeeems\.mystrutsdata

?????文件???????1717??2009-04-27?08:55??項目源程序\jeeems\.project

?????文件????????138??2009-04-27?16:48??項目源程序\jeeems\.settings\org.eclipse.core.resources.prefs

?????文件????????420??2009-04-27?08:55??項目源程序\jeeems\.springBeans

?????文件???????1783??2009-04-29?17:15??項目源程序\jeeems\src\com\moon\jeeems\bs\CodeLogBS.java

?????文件???????1800??2009-04-29?17:52??項目源程序\jeeems\src\com\moon\jeeems\bs\EquKindLogBS.java

?????文件???????1783??2009-05-17?16:52??項目源程序\jeeems\src\com\moon\jeeems\bs\EquLogBS.java

?????文件???????3721??2009-05-05?21:37??項目源程序\jeeems\src\com\moon\jeeems\bs\SuggestService.java

?????文件????????815??2009-04-28?22:35??項目源程序\jeeems\src\com\moon\jeeems\dao\AccidentLogDAO.java

?????文件????????449??2009-04-27?08:55??項目源程序\jeeems\src\com\moon\jeeems\dao\BuyEquLogDAO.java

?????文件????????754??2009-05-21?13:00??項目源程序\jeeems\src\com\moon\jeeems\dao\CodeLogDAO.java

?????文件????????544??2009-05-03?15:49??項目源程序\jeeems\src\com\moon\jeeems\dao\CommentLogDAO.java

?????文件????????577??2009-04-27?08:55??項目源程序\jeeems\src\com\moon\jeeems\dao\DeptLogDAO.java

?????文件????????883??2009-05-06?22:03??項目源程序\jeeems\src\com\moon\jeeems\dao\DestLogDAO.java

?????文件???????1351??2009-05-22?16:53??項目源程序\jeeems\src\com\moon\jeeems\dao\EmpLogDAO.java

?????文件????????635??2009-04-27?08:55??項目源程序\jeeems\src\com\moon\jeeems\dao\EquKindLogDAO.java

?????文件???????1528??2009-05-12?15:32??項目源程序\jeeems\src\com\moon\jeeems\dao\EquLogDAO.java

?????文件????????818??2009-05-07?22:39??項目源程序\jeeems\src\com\moon\jeeems\dao\GcbjLogDAO.java

?????文件????????735??2009-04-28?15:00??項目源程序\jeeems\src\com\moon\jeeems\dao\HelpLogDAO.java

?????文件???????3670??2009-05-18?14:33??項目源程序\jeeems\src\com\moon\jeeems\dao\hibernate\AccidentLogDAOHibernate.java

?????文件???????1960??2009-04-27?08:55??項目源程序\jeeems\src\com\moon\jeeems\dao\hibernate\BuyEquLogDAOHibernate.java

?????文件???????5148??2009-05-21?13:06??項目源程序\jeeems\src\com\moon\jeeems\dao\hibernate\CodeLogDAOHibernate.java

?????文件???????2598??2009-05-05?21:55??項目源程序\jeeems\src\com\moon\jeeems\dao\hibernate\CommentLogDAOHibernate.java

?????文件????????407??2009-04-27?08:55??項目源程序\jeeems\src\com\moon\jeeems\dao\hibernate\DAObase.java

?????文件???????4026??2009-05-21?00:12??項目源程序\jeeems\src\com\moon\jeeems\dao\hibernate\DeptLogDAOHibernate.java

?????文件???????5424??2009-05-06?22:02??項目源程序\jeeems\src\com\moon\jeeems\dao\hibernate\DestLogDAOHibernate.java

?????文件??????10161??2009-05-22?16:54??項目源程序\jeeems\src\com\moon\jeeems\dao\hibernate\EmpLogDAOHibernate.java

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