jsp+servlet+SqlServer教务管理系统

jsp+servlet+SqlServer教务管理系统

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

public class ConnData {
	   Connection conn=null;
	   ResultSet rs=null;
	   private static String driver=“com.microsoft.jdbc.sqlserver.SQLServerDriver“;
	   private static String user_name=“sa“;
	   private static String user_password=““;
	   private static String url=“jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=jiaowuxitong“;
	   public ConnData（）{
	    
	   }
	   public Connection getconn（）{
	    try{
	    Class.forName（driver）.newInstance（）;
	    conn=DriverManager.getConnection（urluser_nameuser_password）;
	     }
	     catch（ClassNotFoundException e）{
	      e.printStackTrace（）;
	       }
	        catch（SQL

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件          0  2008-12-19 09:40  jiaowuxitong\.metadata\.lock

     文件       9455  2008-12-19 09:40  jiaowuxitong\.metadata\.log

     文件        399  2008-12-19 09:41  jiaowuxitong\.metadata\.mylyn\repositories.xml.zip

     文件          1  2008-12-19 09:41  jiaowuxitong\.metadata\.plugins\org.eclipse.core.resources\.root\.indexes\history.version

     文件        109  2008-12-19 09:40  jiaowuxitong\.metadata\.plugins\org.eclipse.core.resources\.root\.indexes\properties.index

     文件          1  2008-12-19 09:41  jiaowuxitong\.metadata\.plugins\org.eclipse.core.resources\.root\.indexes\properties.version

     文件        153  2008-12-19 09:41  jiaowuxitong\.metadata\.plugins\org.eclipse.core.resources\.root\1.tree

     文件        567  2008-12-19 09:41  jiaowuxitong\.metadata\.plugins\org.eclipse.core.resources\.safetable\org.eclipse.core.resources

     文件         73  2008-12-19 09:41  jiaowuxitong\.metadata\.plugins\org.eclipse.core.runtime\.settings\org.eclipse.core.resources.prefs

     文件        125  2008-12-19 09:40  jiaowuxitong\.metadata\.plugins\org.eclipse.core.runtime\.settings\org.eclipse.epp.usagedata.recording.prefs

     文件         83  2008-12-19 09:40  jiaowuxitong\.metadata\.plugins\org.eclipse.core.runtime\.settings\org.eclipse.equinox.p2.ui.sdk.prefs

     文件        604  2008-12-19 09:41  jiaowuxitong\.metadata\.plugins\org.eclipse.core.runtime\.settings\org.eclipse.jdt.ui.prefs

     文件         89  2008-12-19 09:40  jiaowuxitong\.metadata\.plugins\org.eclipse.core.runtime\.settings\org.eclipse.jst.j2ee.webservice.ui.prefs

     文件         93  2008-12-19 09:40  jiaowuxitong\.metadata\.plugins\org.eclipse.core.runtime\.settings\org.eclipse.mylyn.context.core.prefs

     文件         88  2008-12-19 09:41  jiaowuxitong\.metadata\.plugins\org.eclipse.core.runtime\.settings\org.eclipse.team.cvs.ui.prefs

     文件        100  2008-12-19 09:41  jiaowuxitong\.metadata\.plugins\org.eclipse.core.runtime\.settings\org.eclipse.team.ui.prefs

     文件        142  2008-12-19 09:41  jiaowuxitong\.metadata\.plugins\org.eclipse.core.runtime\.settings\org.eclipse.ui.ide.prefs

     文件         79  2008-12-19 09:40  jiaowuxitong\.metadata\.plugins\org.eclipse.core.runtime\.settings\org.eclipse.ui.prefs

     文件       2182  2008-12-19 09:40  jiaowuxitong\.metadata\.plugins\org.eclipse.core.runtime\.settings\org.eclipse.ui.workbench.prefs

     文件        532  2008-12-19 09:41  jiaowuxitong\.metadata\.plugins\org.eclipse.core.runtime\.settings\org.eclipse.wst.jsdt.ui.prefs

     文件       2764  2008-12-19 09:40  jiaowuxitong\.metadata\.plugins\org.eclipse.epp.usagedata.recording\upload0.csv

     文件       2672  2008-12-19 09:40  jiaowuxitong\.metadata\.plugins\org.eclipse.epp.usagedata.recording\upload1.csv

     文件       2589  2008-12-19 09:40  jiaowuxitong\.metadata\.plugins\org.eclipse.epp.usagedata.recording\upload2.csv

     文件       2783  2008-12-19 09:40  jiaowuxitong\.metadata\.plugins\org.eclipse.epp.usagedata.recording\upload3.csv

     文件       2692  2008-12-19 09:41  jiaowuxitong\.metadata\.plugins\org.eclipse.epp.usagedata.recording\upload4.csv

     文件       2891  2008-12-19 09:41  jiaowuxitong\.metadata\.plugins\org.eclipse.epp.usagedata.recording\upload5.csv

     文件       2757  2008-12-19 09:41  jiaowuxitong\.metadata\.plugins\org.eclipse.epp.usagedata.recording\upload6.csv

     文件        584  2008-12-19 09:41  jiaowuxitong\.metadata\.plugins\org.eclipse.epp.usagedata.recording\usagedata.csv

     文件        115  2008-12-19 09:41  jiaowuxitong\.metadata\.plugins\org.eclipse.jdt.core\variablesAndContainers.dat

     文件         60  2008-12-19 09:41  jiaowuxitong\.metadata\.plugins\org.eclipse.jdt.ui\OpenTypeHistory.xml

............此处省略421个文件信息