package?student;

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

public?class?DBConnect?{	
	public?Statement?stmt?=?null;?
	
	
	public?static?Connection?getConnection（）{
		Connection?con=null;
		try?{
			Class.forName（“com.mysql.jdbc.Driver“）;
			String?url=“jdbc:mysql://localhost:3306/sushe?useUnicode=true&characterEncoding=UTF-8“;
			String?user=“root“;
			String?password=“root“;
			con=DriverManager.getConnection（url?user?password）;
			
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
		return?con;
		
	}
	public??ResultSet?DBQuery（String?sqlText）?{
		Connection?conn1=null;
		ResultSet?rs=null;
		java.sql.Statement?stmt=null;
		try{
			conn1=getConnection（）;
			stmt=conn1.createStat

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

?????文件????????741??2018-06-11?08:48??SusheManage\.classpath

?????文件???????1044??2018-06-11?08:48??SusheManage\.project

?????文件????????567??2018-06-11?08:48??SusheManage\.settings\.jsdtscope

?????文件????????303??2018-06-11?08:48??SusheManage\.settings\org.eclipse.jdt.core.prefs

?????文件????????485??2018-06-11?08:48??SusheManage\.settings\org.eclipse.wst.common.component

?????文件????????305??2018-06-11?08:48??SusheManage\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2018-06-11?08:48??SusheManage\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2018-06-11?08:48??SusheManage\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????1749??2018-06-14?07:59??SusheManage\build\classes\student\DBConnect.class

?????文件???????1276??2018-06-11?08:48??SusheManage\src\student\DBConnect.java

?????文件???????4483??2018-06-13?11:02??SusheManage\WebContent\addroom.jsp

?????文件???????4821??2018-06-11?11:04??SusheManage\WebContent\addstudent.jsp

?????文件???????1818??2018-06-11?08:48??SusheManage\WebContent\checklogin.jsp

?????文件?????175583??2018-06-11?10:52??SusheManage\WebContent\images\bg.png

?????文件?????136517??2018-06-11?09:29??SusheManage\WebContent\images\login-img.png

?????文件???????2308??2018-06-11?09:29??SusheManage\WebContent\images\login_logo.png

?????文件???????2398??2018-06-11?09:30??SusheManage\WebContent\login.css

?????文件???????1624??2018-06-13?09:16??SusheManage\WebContent\login.jsp

?????文件???????1001??2018-06-11?11:12??SusheManage\WebContent\main.jsp

?????文件?????????39??2018-06-11?08:48??SusheManage\WebContent\meta-INF\MANIFEST.MF

?????文件???????3934??2018-06-14?09:12??SusheManage\WebContent\query_house.jsp

?????文件???????6577??2018-06-11?11:05??SusheManage\WebContent\query_student.jsp

?????文件?????512707??2018-06-11?08:48??SusheManage\WebContent\WEB-INF\lib\mysql-connector-java-5.0.5-bin.jar

?????文件???????1115??2018-06-11?08:48??SusheManage\WebContent\WEB-INF\web.xml

?????文件?????587264??2019-01-09?18:49??課設(shè)報告.doc

?????目錄??????????0??2018-06-14?07:59??SusheManage\build\classes\student

?????目錄??????????0??2018-06-12?09:13??SusheManage\WebContent\WEB-INF\lib

?????目錄??????????0??2018-06-14?07:59??SusheManage\build\classes

?????目錄??????????0??2018-06-12?09:13??SusheManage\src\student

?????目錄??????????0??2018-06-12?09:13??SusheManage\WebContent\images

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