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

public?class?DbConn?{
	Connection?con?=?null;?
	ResultSet?rs?=?null;?
	Statement?stmt=null;
	//數據庫連接字符串初始化
	String?url=“jdbc:sqlserver://localhost:1433;DatabaseName=supermkt“;
	//賬號密碼初始化
	String?username?=?“sa“;
	String?password?=?“sa123“;
	String?driver=“com.microsoft.sqlserver.jdbc.SQLServerDriver“;
	/**
	?*?構成方法
	?*?@param?driver驅動
	?*?@param?url鏈接字符
	?*?@param?username用戶名
	?*?@param?password密碼
	?*/
	public?DbConn（）?{
		try{
			Class.forName（driver）;
			con?=?DriverManager.getConnection（url?username?password）;
			stmt?=?con.createStatement（ResultSet.TYPE_SCROLL_INSENSITIVEResultSet.CONCUR_READ_ONLY）;	
		}catch（ClassNotFoundException?e）
		{
			e.printStackTrace（）;
		}
		catch（SQLException?e）
		{
			e.printStackTrace（）;
		}

	}
	/**
	?*?查詢獲取結果集
	?*?@param?sql
	?*?@return
	?*/
	public?ResultSet?executeQuery（String?sql）?{
		try?{
			rs?=?stmt.executeQuery（sql）;
		}?catch?（SQLException?er）?{
			System.err.println（er.getMessage（））;
		}
		return?rs;
	}
	/**
	?*?執行sql語句，返回受影響行數
	?*?@param?sql
	?*?@return
	?*/
	public?int?executeUpdate（String?sql）?{?
		int?result?=?0;
		try?{
			result?=?stmt.executeUpdate（sql）;
		}?catch?（SQLException?ex）?{
			System.err.println（ex.getMessage（））;
		}
		return?result;
	}
	
	/**
	?*?執行sql語句
	?*?@param?sql
	?*?@return
	?*/
	public?boolean?execute（String?sql）?{
		boolean?result?=?false;
		try?{
			result?=?stmt.execute（sql）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?result;
	}
	/**
	?*?獲取一行一列數據
	?*?@param?sql
	?*?@return
	?*/
	public?object?getOnlyOne（String?sql）{
		object?str=null;
		ResultSet?rs=executeQuery（sql）;
		try?{
			if（rs.first（））{
				str=rs.getobject（1）;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?str;
	}
	/**
	?*?判斷是否有查詢結果
	?*?@param?sql
	?*?@return
	?*/
	public?boolean?checkTrue（String?sql）{
		ResultSet?rs=executeQuery（sql）;
		try?{
			if（rs.next（））{
				return?true;
			}else{
				return?false;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
			return?false;
		}
	}
	//數據庫連接關閉
	public?void?close（）?{
		try?{
			if?（con?!=?null）
				con.close（）;
		}?catch?（Exception?e）?{
			System.out.print（e）;
		}
		try?{
			if?（rs?!=?null）
				rs.close（）;
		}?catch?（Exception?e）?{
			System.out.println（e）;
		}
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-06-02?11:14??jar包和其他\
?????文件?????1470766??2017-01-08?22:27??jar包和其他\Jar包導入錄像.zip
?????文件??????654891??2016-09-21?11:21??jar包和其他\sqljdbc41.jar
?????目錄???????????0??2017-06-02?11:14??數據庫\
?????文件?????5561936??2017-01-02?22:26??數據庫\sqlserver數據庫配置和腳本導入錄像.zip
?????文件???????11608??2017-06-02?11:12??數據庫\supermkt.sql
?????目錄???????????0??2017-06-02?11:13??源代碼\
?????文件?????????367??2017-06-02?10:27??源代碼\.classpath
?????文件?????????384??2017-06-02?10:27??源代碼\.project
?????目錄???????????0??2017-06-02?11:13??源代碼\.settings\
?????文件?????????598??2017-06-02?10:27??源代碼\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2017-06-02?11:13??源代碼\bin\
?????文件????????3130??2017-06-02?10:28??源代碼\bin\DbConn.class
?????文件????????1932??2017-06-02?10:27??源代碼\bin\LoginFrm$LoginSubmit.class
?????文件?????????837??2017-06-02?10:27??源代碼\bin\LoginFrm$Reset.class
?????文件????????3134??2017-06-02?10:27??源代碼\bin\LoginFrm.class
?????文件?????????690??2017-06-02?10:27??源代碼\bin\MainFrm$backlog.class
?????文件?????????680??2017-06-02?10:27??源代碼\bin\MainFrm$mcustomer.class
?????文件?????????668??2017-06-02?10:27??源代碼\bin\MainFrm$mgoods.class
?????文件?????????668??2017-06-02?10:27??源代碼\bin\MainFrm$morder.class
?????文件?????????672??2017-06-02?10:27??源代碼\bin\MainFrm$msupply.class
?????文件?????????668??2017-06-02?10:27??源代碼\bin\MainFrm$updpwd.class
?????文件????????3042??2017-06-02?10:27??源代碼\bin\MainFrm.class
?????文件????????1456??2017-06-02?11:10??源代碼\bin\McustomerFrm$1.class
?????文件????????2409??2017-06-02?11:10??源代碼\bin\McustomerFrm$AddAction.class
?????文件?????????764??2017-06-02?11:10??源代碼\bin\McustomerFrm$CheckAction.class
?????文件????????1739??2017-06-02?11:10??源代碼\bin\McustomerFrm$DelAction.class
?????文件?????????629??2017-06-02?11:10??源代碼\bin\McustomerFrm$ResAction.class
?????文件????????2920??2017-06-02?11:10??源代碼\bin\McustomerFrm$UpdAction.class
?????文件????????6521??2017-06-02?11:10??源代碼\bin\McustomerFrm.class
?????文件????????1634??2017-06-02?10:27??源代碼\bin\MgoodsFrm$1.class
............此處省略31個文件信息