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

import?javax.swing.JOptionPane;

public?class?DB?{

	Connection?conconn=null;
	Statement?stmt;
	ResultSet?rs?;
	PreparedStatement?preSql;
	public?DB（）?{
		//?TODO?Auto-generated?constructor?stub
		
//		try?{
//			Class.forName（“com.microsoft.sqlserver.jdbc.SQLServerDriver“）;
//				
//			}
//			catch（Exception?e）
//		{}
	}
	
	void?open（Connection?con）{//***
//		try?{
//			String?url=“jdbc:sqlserver://localhost:1433;DatabaseName=master“;
//			String?user=“sa“;
//			String?password=“meiyou345“;
//		??con?=?DriverManager.getConnection（url?user?password）;
			this.con?=?con;//***
			
//		}
//		catch（SQLException?e）?{	
//		}
	}
	
	void?close（）{
		
		try?{
			stmt.close（）;
//			con.close（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		
	}
	
	boolean?yanzheng（String?nameString?pswd）{
		String?sql?=?“select?*?from?std?where?username?=‘“+name+“‘“;
		try?{
			stmt=con.createStatement（）;
			rs?=?stmt.executeQuery（sql）;
			while（rs.next（））{
				String?temp?=?rs.getString（2）;
				if（temp.equals（pswd））
					return?true;
			}
			
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		
		
		return?false;
	}


	boolean?zhucezhanghao（Register?register）?{
		String?sqlStr=“insert?into?std?values（??）“;
		int?ok=0;
		?try?{
			?preSql?=?con.prepareStatement（sqlStr）;
			?preSql.setString（1register.getname（））;
			?preSql.setString（2register.getpassword（））;
			?ok=preSql.executeUpdate（）;
//			?con.close（）;
		?}
		?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
//				e.printStackTrace（）;
				JOptionPane.showMessageDialog（null?“注冊錯(cuò)誤！“）;
			}
		?if（ok!=0）
		?{
			?JOptionPane.showMessageDialog（null?“注冊成功！“）;
			?Login?login?=?new?Login（con）;
		?}
		return?true;
		
		???}
?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????
	??boolean?xiugaimima（Register?register）?{
		??String?sqlQ=“update?std?set?userpassword=??where?username=??“;
	int?ok=0;
			?try?{
				?preSql?=?con.prepareStatement（sqlQ）;
				?
				?preSql.setString（1register.getpassword（））;
				?preSql.setString（2register.getname（））;
				?ok=preSql.executeUpdate（）;
		?????????JOptionPane.showMessageDialog（null?“修改成功!“）;
				?
			?}
			?catch?（SQLException?e）?{
					//?TODO?Auto-generated?catch?block
//					e.printStackTrace（）;
					JOptionPane.showMessageDialog（null?“修改錯(cuò)誤！“）;
				}
			return?true;
	??}
?}



?

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????????301??2018-12-02?13:55??StudentsManagementSystem\.classpath

?????文件????????400??2018-12-02?13:55??StudentsManagementSystem\.project

?????文件????????598??2018-12-02?13:55??StudentsManagementSystem\.settings\org.eclipse.jdt.core.prefs

?????文件???????2906??2019-01-06?19:46??StudentsManagementSystem\bin\DB.class

?????文件???????1348??2019-01-06?19:46??StudentsManagementSystem\bin\GetSQLServerConnection.class

?????文件???????3172??2019-01-06?19:46??StudentsManagementSystem\bin\HandleStudInfo.class

?????文件???????3197??2019-01-06?19:46??StudentsManagementSystem\bin\Login.class

?????文件????????639??2019-01-06?19:46??StudentsManagementSystem\bin\Main.class

?????文件???????1616??2019-01-06?19:46??StudentsManagementSystem\bin\MainManagementView.class

?????文件???????2418??2019-01-06?19:46??StudentsManagementSystem\bin\MyManagementView.class

?????文件????????693??2019-01-06?19:46??StudentsManagementSystem\bin\Register.class

?????文件???????1287??2019-01-06?19:46??StudentsManagementSystem\bin\StudInfo.class

?????文件???????6545??2019-01-06?19:46??StudentsManagementSystem\bin\StudInfoManagementView.class

?????文件???????3392??2019-01-06?19:46??StudentsManagementSystem\bin\xiugaimima.class

?????文件???????3032??2019-01-06?19:46??StudentsManagementSystem\bin\zhuce.class

?????文件???????2821??2018-12-19?17:37??StudentsManagementSystem\src\DB.java

?????文件????????667??2018-12-05?22:20??StudentsManagementSystem\src\GetSQLServerConnection.java

?????文件???????2859??2018-12-05?18:26??StudentsManagementSystem\src\HandleStudInfo.java

?????文件???????2669??2018-12-05?22:22??StudentsManagementSystem\src\Login.java

?????文件????????250??2018-12-05?22:29??StudentsManagementSystem\src\Main.java

?????文件????????886??2018-12-05?22:22??StudentsManagementSystem\src\MainManagementView.java

?????文件???????1454??2018-12-05?22:06??StudentsManagementSystem\src\MyManagementView.java

?????文件????????305??2018-12-05?18:52??StudentsManagementSystem\src\Register.java

?????文件????????879??2018-12-03?21:16??StudentsManagementSystem\src\StudInfo.java

?????文件???????7129??2018-12-05?21:32??StudentsManagementSystem\src\StudInfoManagementView.java

?????文件???????2630??2018-12-19?17:42??StudentsManagementSystem\src\xiugaimima.java

?????文件???????2210??2018-12-05?20:34??StudentsManagementSystem\src\zhuce.java

?????文件??????56093??2018-12-21?21:46??StudentsManagementSystem\學(xué)生信息管理系統(tǒng)演示.pptx

?????文件????????339??2018-12-05?20:09??StudentsManagementSystem\學(xué)生管理系統(tǒng)數(shù)據(jù)庫.sql

?????文件???????1039??2019-06-23?00:38??StudentsManagementSystem\說明.txt

............此處省略8個(gè)文件信息