package?com.bookonline.DB;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.SQLException;


public?class?DB?{
	public?static?DB?conn=null;
	public?static?DB?newInstance（）{
		if（conn==null）{
			conn=new?DB（）;
		}
		return?conn;
	}
	
	public?static?Connection?getConnection（）?{
		try?{
			Class.forName（“com.microsoft.sqlserver.jdbc.SQLServerDriver“）.newInstance（）;
			Connection?conn?=?DriverManager.getConnection（“jdbc:sqlserver://192.168.1.238:1433;databasename=train““sa“?“123“）;
			return?conn;
		}?catch?（InstantiationException?e）?{
			e.printStackTrace（）;
		}?catch?（IllegalAccessException?e）?{
			e.printStackTrace（）;
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?null;
	}
	
	public?static?void?closeConnection（Connection?conn）{		
		try?{
			if（conn!=null）?conn.close（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}		
	}
}

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

?????文件????????914??2016-05-16?14:59??Train\.classpath

?????文件???????1330??2016-05-16?14:59??Train\.project

?????文件????????522??2016-05-16?14:59??Train\.settings\.jsdtscope

?????文件?????????74??2016-05-16?14:59??Train\.settings\com.genuitec.eclipse.core.prefs

?????文件???????1009??2016-05-16?14:59??Train\.settings\com.genuitec.eclipse.j2eedt.core.prefs

?????文件????????144??2016-05-16?14:59??Train\.settings\org.eclipse.core.resources.prefs

?????文件????????364??2016-05-16?14:59??Train\.settings\org.eclipse.jdt.core.prefs

?????文件????????473??2016-05-16?14:59??Train\.settings\org.eclipse.wst.common.component

?????文件????????414??2016-05-16?14:59??Train\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2016-05-16?14:59??Train\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2016-05-16?14:59??Train\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????3679??2016-05-16?14:59??Train\SQL\train_sqlserver.sql

?????文件????????953??2016-05-16?14:59??Train\src\com\bookonline\DB\DB.java

?????文件????????942??2016-05-16?14:59??Train\src\com\bookonline\JavaBean\TicketBean.java

?????文件???????4088??2016-05-16?14:59??Train\src\com\bookonline\JavaBean\TicketDao.java

?????文件???????1211??2016-05-16?14:59??Train\src\com\bookonline\JavaBean\UserBean.java

?????文件???????5449??2016-05-16?14:59??Train\src\com\bookonline\JavaBean\UserDao.java

?????文件???????1490??2016-05-16?14:59??Train\src\com\bookonline\Servlet\AddServlet.java

?????文件???????2411??2016-05-16?14:59??Train\src\com\bookonline\Servlet\AddTrainServlet.java

?????文件???????1832??2016-05-16?14:59??Train\src\com\bookonline\Servlet\BookServlet.java

?????文件???????1841??2016-05-16?14:59??Train\src\com\bookonline\Servlet\LoginServlet.java

?????文件???????1881??2016-05-16?14:59??Train\src\com\bookonline\Servlet\ModifyServlet.java

?????文件???????2198??2016-05-16?14:59??Train\src\com\bookonline\Servlet\NewUser.java

?????文件???????2562??2016-05-16?14:59??Train\src\com\bookonline\Servlet\NoparamServlet.java

?????文件???????2406??2016-05-16?14:59??Train\src\com\bookonline\Servlet\PasswordServlet.java

?????文件???????2328??2016-05-16?14:59??Train\src\com\bookonline\Servlet\QueryServlet.java

?????文件???????1436??2016-05-16?14:59??Train\src\com\bookonline\Servlet\ViewServlet.java

?????文件???????1095??2016-05-16?14:59??Train\src\javaz\filter\EncodeFilter.java

?????文件???????1191??2016-05-16?14:59??Train\WebRoot\adderror.jsp

?????文件???????4673??2016-05-16?14:59??Train\WebRoot\addtrain.jsp

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