package?com.mtt.db;

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

public?class?DBhelper?{


	String?driverName?=?“com.microsoft.sqlserver.jdbc.SQLServerDriver“;?//?加載JDBC驅動
	String?dbURL?=?“jdbc:sqlserver://localhost:1433;?DatabaseName=UserManagement“;?//?連接服務器和數據庫test
	String?userName?=?“sa“;?//?默認用戶名
	String?userPwd?=?“123“;?//?密碼
	Connection?dbConn=null;
	ResultSet?rs=null;
	PreparedStatement?ps=null;
	String?sql=null;
	
	public?void?excute（）
	{
		try?{
			Class.forName（driverName）;
			dbConn?=?DriverManager.getConnection（dbURL?userName
					userPwd）;
			System.out.println（“成功“）;
			ps=dbConn.prepareStatement（sql）;
			rs=ps.executeQuery（）;		
		}?catch?（Exception?e）?{
			//?TODO:?handle?exception
			//e.printStackTrace（）;
			return;
		}finally{
			
			try?{
				if（rs!=null）
				{
					rs.close（）;
				}
				if（ps!=null）
				{
					ps.close（）;
				}
				if（dbConn!=null）
				{
					dbConn.close（）;
				}
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				//e.printStackTrace（）;
				return;
			}
		}
	}
	public?void?updata（String[]?data）
	{
		sql=“update?users?set?username=‘“+data[1]+“‘email=‘“+data[2]+“‘grade=“+data[3]+“password=‘“+data[4]+“‘?where?id=“+data[0]+“;“;
		excute（）;
	}
	
	public?void?insert（String[]?data）
	{
		sql=“insert?into?users?values（“+data[0]+“‘“+data[1]+“‘‘“+data[2]+“‘“+data[3]+“‘“+data[4]+“‘）;“;
		excute（）;
	}
	
	public?void?deletedata（String?id）
	{
		sql=“delete?from?users?where?id=“+id+“;“;
		excute（）;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2016-06-05?15:10??項目\
?????目錄???????????0??2016-06-05?15:10??項目\Database_Design\
?????文件?????????379??2014-04-03?21:27??項目\Database_Design\.classpath
?????文件?????????391??2014-04-03?21:27??項目\Database_Design\.project
?????目錄???????????0??2016-06-05?15:10??項目\Database_Design\.settings\
?????文件?????????629??2014-04-03?21:27??項目\Database_Design\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2016-06-05?15:10??項目\Database_Design\bin\
?????目錄???????????0??2016-06-05?15:10??項目\Database_Design\bin\com\
?????目錄???????????0??2016-06-05?15:10??項目\Database_Design\bin\com\mtt\
?????目錄???????????0??2016-06-05?15:10??項目\Database_Design\bin\com\mtt\db\
?????文件????????2990??2014-04-03?21:27??項目\Database_Design\bin\com\mtt\db\DBhelper.class
?????文件????????3537??2014-04-03?21:27??項目\Database_Design\bin\com\mtt\db\DBTableModel.class
?????目錄???????????0??2016-06-05?15:10??項目\Database_Design\bin\com\mtt\view\
?????文件????????3059??2014-04-03?21:27??項目\Database_Design\bin\com\mtt\view\Insertframe.class
?????文件????????3637??2014-04-03?21:27??項目\Database_Design\bin\com\mtt\view\Mainframe.class
?????文件????????3227??2014-04-03?21:27??項目\Database_Design\bin\com\mtt\view\Resetframe.class
?????目錄???????????0??2016-06-05?15:10??項目\Database_Design\src\
?????目錄???????????0??2016-06-05?15:10??項目\Database_Design\src\com\
?????目錄???????????0??2016-06-05?15:10??項目\Database_Design\src\com\mtt\
?????目錄???????????0??2016-06-05?15:10??項目\Database_Design\src\com\mtt\db\
?????文件????????1683??2014-04-03?21:27??項目\Database_Design\src\com\mtt\db\DBhelper.java
?????文件????????2536??2014-04-03?21:27??項目\Database_Design\src\com\mtt\db\DBTableModel.java
?????目錄???????????0??2016-06-05?15:10??項目\Database_Design\src\com\mtt\view\
?????文件????????2251??2014-04-03?21:27??項目\Database_Design\src\com\mtt\view\Insertframe.java
?????文件????????2582??2014-04-03?21:27??項目\Database_Design\src\com\mtt\view\Mainframe.java
?????文件????????2389??2014-04-03?21:27??項目\Database_Design\src\com\mtt\view\Resetframe.java
?????文件?????????818??2014-04-03?21:52??項目\DB_SQL.txt
?????文件??????584207??2012-02-18?03:45??項目\sqljdbc4.jar
?????文件?????????181??2014-04-03?21:57??項目\使用說明.txt