package?com.lovo.util;

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

public?final?class?JdbcUtils?{
	
	private?static?final?String?url?=?“jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=minibook“;
	static?{
		try?{
			Class.forName（“com.microsoft.jdbc.sqlserver.SQLServerDriver“）;
		}?catch?（ClassNotFoundException?e）?{
			System.out.println（“加載驅動失敗“）;
			e.printStackTrace（）;
		}
	}

	private?JdbcUtils（）?{

	}

	private?static?Connection?conn?=?null;

	public?static?Connection?getConnection（）?throws?SQLException?{
			conn?=?DriverManager.getConnection（url?“sa“?“sa“）;
		return?conn;
	}

	public?static?void?free（Connection?conn?Statement?st?ResultSet?rs）?{

		try?{
			if?（rs?!=?null）?{
				rs.close（）;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}?finally?{
			rs?=?null;
			try?{
				if?（st?!=?null）?{
					st.close（）;
				}
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}?finally?{
				st?=?null;
				try?{
					if?（conn?!=?null）?{
						conn.close（）;
					}
				}?catch?（SQLException?e）?{
					e.printStackTrace（）;
				}
			}

		}
	}
}

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

?????文件????????340??2009-12-31?13:24??minibook\.classpath

?????文件????????297??2010-01-03?17:55??minibook\.mymetadata

?????文件???????1226??2009-12-28?21:58??minibook\.project

?????文件????????838??2009-12-29?19:18??minibook\html\delete.html

?????文件???????4253??2009-12-29?19:18??minibook\html\good.html

?????文件????????838??2009-12-29?19:18??minibook\html\insert.html

?????文件???????2294??2009-12-29?23:04??minibook\html\login.html

?????文件??????21772??2009-12-29?19:18??minibook\html\login.jpg

?????文件????????994??2009-12-29?23:03??minibook\html\register.html

?????文件????????859??2009-12-29?22:26??minibook\html\search.html

?????文件??????10752??2009-12-29?19:18??minibook\html\Thumbs.db

?????文件????????838??2009-12-29?19:18??minibook\html\update.html

?????文件????????784??2009-12-29?19:18??minibook\html\WelcomeError.html

?????文件???????1866??2009-12-29?19:18??minibook\html\WelcomeError.jpg

?????文件????????251??2009-12-29?15:02??minibook\lib\guoxin\com\lovo\minibook\dao\factory\UserDataFactory.java

?????文件????????230??2009-12-29?15:02??minibook\lib\guoxin\com\lovo\minibook\dao\factory\UserFactory.java

?????文件????????817??2009-12-29?15:02??minibook\lib\guoxin\com\lovo\minibook\dao\imp\UserDataImp.java

?????文件????????682??2009-12-29?15:02??minibook\lib\guoxin\com\lovo\minibook\dao\imp\UserImp.java

?????文件????????617??2009-12-29?15:02??minibook\lib\guoxin\com\lovo\minibook\dao\UserDAO.java

?????文件????????792??2009-12-29?15:02??minibook\lib\guoxin\com\lovo\minibook\dao\UserDataDAO.java

?????文件????????628??2009-12-29?15:02??minibook\lib\guoxin\com\lovo\minibook\po\User.java

?????文件????????854??2009-12-29?15:02??minibook\lib\guoxin\com\lovo\minibook\po\UserData.java

?????文件???????1249??2009-12-29?15:58??minibook\lib\guoxin\JdbcUtils.java

?????文件???????3753??2009-12-29?15:58??minibook\lib\guoxin\UserDataImp.java

?????文件???????3995??2009-12-29?15:58??minibook\lib\guoxin\UserImp.java

?????文件????????248??2009-12-29?15:00??minibook\lib\huyu\com\lovo\minibook\dao\factory\UserDataFactory.java

?????文件????????227??2009-12-29?15:00??minibook\lib\huyu\com\lovo\minibook\dao\factory\UserFactory.java

?????文件????????817??2009-12-29?15:00??minibook\lib\huyu\com\lovo\minibook\dao\imp\UserDataImp.java

?????文件???????3067??2009-12-29?15:00??minibook\lib\huyu\com\lovo\minibook\dao\imp\UserImp.java

?????文件????????724??2009-12-29?15:00??minibook\lib\huyu\com\lovo\minibook\dao\UserDAO.java

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