宿舍信息管理系统附报告书

javaweb课程设计——宿舍信息管理系统（附带报告书）

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  课设报告.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个文件信息