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

public?class?JDBV{
	Connection?conn?=?null;

	public?void?getConnection（）?{
		String?dbURL?=?“jdbc:sqlserver://localhost:1433;DatabaseName=example“;
		String?username?=?“sa“;
		String?password?=?“123456“;
		try?{
			//?forName?加載一個類，把它加載到內存中
			Class.forName（“com.microsoft.sqlserver.jdbc.SQLServerDriver“）;
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}
		try?{
			//?建立連接?，創建連接
			conn?=?DriverManager.getConnection（dbURL?username?password）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
	}

	public?ResultSet?query（String?sql）?{
		getConnection（）;
		try?{
			Statement?stmt?=?conn.createStatement（）;
			ResultSet?rs?=?stmt.executeQuery（sql）;
			return?rs;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
			return?null;
		}
	}

	public?int?update（String?sql）?{
		getConnection（）;
		try?{
			Statement?stmt?=?conn.createStatement（）;
			int?i?=?stmt.executeUpdate（sql）;
			return?i;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
			return?0;
		}
	}
	public?static?void?main（String?args[]）{
		JDBV?j?=?new?JDBV（）;
		ResultSet?rs=j.query（“select?*?from?student“）;
		Scanner?sc?=?new?Scanner（System.in）;?
		String?name?=?sc.next（）;
		try?{
			while（rs.next（））{
				System.out.println（rs.getString（name））;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????????345??2009-07-14?18:58??JDBC\.classpath
?????文件?????????380??2009-07-14?18:58??JDBC\.project
?????文件????????2569??2009-07-14?18:58??JDBC\bin\JDBV.class
?????文件????????1487??2009-07-14?18:58??JDBC\bin\System\Bank.class
?????文件????????1279??2009-07-14?18:58??JDBC\bin\System\BankPrice.class
?????文件????????1174??2009-07-14?18:58??JDBC\bin\System\Boss.class
?????文件????????1768??2009-07-14?18:58??JDBC\bin\System\Card.class
?????文件????????2495??2009-07-14?18:58??JDBC\bin\System\HairSystem.class
?????文件????????2111??2009-07-14?18:58??JDBC\bin\System\Tool.class
?????文件?????????543??2009-07-14?18:58??JDBC\bin\System\Typpe.class
?????文件????????5168??2009-07-14?18:58??JDBC\bin\System\UseTool.class
?????文件????????4653??2009-07-14?18:58??JDBC\bin\System\UseTool2.class
?????文件????????1764??2009-07-14?18:58??JDBC\bin\System\X.class
?????文件????????3452??2009-07-14?18:58??JDBC\bin\System\cash.class
?????文件??????253122??2009-07-14?18:58??JDBC\sqldriver\sqljdbc.jar
?????文件????????1676??2009-07-14?18:58??JDBC\src\JDBV.java
?????文件?????????996??2009-07-14?18:58??JDBC\src\System\Bank.java
?????文件?????????640??2009-07-14?18:58??JDBC\src\System\BankPrice.java
?????文件?????????577??2009-07-14?18:58??JDBC\src\System\Boss.java
?????文件?????????883??2009-07-14?18:58??JDBC\src\System\Card.java
?????文件????????1946??2009-07-14?18:58??JDBC\src\System\HairSystem.java
?????文件????????1767??2009-07-14?18:58??JDBC\src\System\Tool.java
?????文件?????????175??2009-07-14?18:58??JDBC\src\System\Typpe.java
?????文件????????4853??2009-07-14?18:58??JDBC\src\System\UseTool.java
?????文件????????4142??2009-07-14?18:58??JDBC\src\System\UseTool2.java
?????文件????????1012??2009-07-14?18:58??JDBC\src\System\X.java
?????文件????????3507??2009-07-14?18:58??JDBC\src\System\cash.java