package?com.bus;

import?java.sql.*;//add

public?class?Database?{

	//?數(shù)據(jù)庫(kù)連接數(shù)據(jù)成員
	Connection?con;

	Statement?stmt;

	//?結(jié)果集合數(shù)據(jù)成員
	public?ResultSet?rs;
	


	//?數(shù)據(jù)庫(kù)驅(qū)動(dòng)程序注冊(cè)方法
//	public?void?databaseRegist（）?throws?ClassNotFoundException?{
//		//?注冊(cè)sqlserver數(shù)據(jù)庫(kù)驅(qū)動(dòng)程序
//		Class.forName（“sun.jdbc.odbc.JdbcOdbcDriver“）;
//
//	}
	public?Database（）?throws?ClassNotFoundException{
//		?注冊(cè)sqlserver數(shù)據(jù)庫(kù)驅(qū)動(dòng)程序
		
			Class.forName（“sun.jdbc.odbc.JdbcOdbcDriver“）;
		
		
	}
	//?數(shù)據(jù)庫(kù)連接方法
	//
	public?void?connction（）?throws?SQLException{

		//?設(shè)置連接字符串（使用odbc數(shù)據(jù)源）
		String?url?=?“jdbc:odbc:chong“;
		//?用戶標(biāo)識(shí)
		String?user?=?“sa“;
		//?使用密碼
		String?password?=?““;
		//?創(chuàng)建Connection對(duì)象
		con?=?DriverManager.getConnection（url?user?password）;
		stmt?=?con.createStatement（ResultSet.TYPE_SCROLL_SENSITIVE
				ResultSet.CONCUR_UPDATABLE）;
	}

	//?執(zhí)行sql語(yǔ)句方法
	public?void?sqlExcuteQuery（String?mysql）?throws?SQLException

	{?//?執(zhí)行sql語(yǔ)句
		rs?=?stmt.executeQuery（mysql）;
		//return?true;
	}

	public?int?sqlExcuteUpdate（String?mysql）?throws?SQLException

	{
		//?執(zhí)行sql語(yǔ)句
		int?i?=?stmt.executeUpdate（mysql）;
		return?i;
	}
	
	//執(zhí)行存儲(chǔ)過(guò)程
	public?void?execQueryPro（String?call）?throws?SQLException{
		CallableStatement?st=con.prepareCall（call）;
		rs=st.executeQuery（）;
	}
	
	public?int?execUpdatePro（String?call）?throws?SQLException{
		CallableStatement?st=con.prepareCall（call）;
		int?i=st.executeUpdate（）;
		return?i;
	}
	
	public?void?close（）?throws?SQLException{
			//rs.close（）;
			stmt.close（）;
			con.close（）;
	}

}

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

?????文件????????226??2009-03-11?01:08??StuManage\StuManage\.classpath

?????文件????????385??2009-03-11?01:08??StuManage\StuManage\.project

?????文件???????2096??2010-03-14?00:07??StuManage\StuManage\com\bus\Database.class

?????文件???????1671??2010-03-14?00:07??StuManage\StuManage\com\bus\Database.java

?????文件????????659??2010-03-13?23:50??StuManage\StuManage\com\dis\CalcuteNum$1.class

?????文件???????1113??2010-03-13?23:50??StuManage\StuManage\com\dis\CalcuteNum$2.class

?????文件???????1105??2010-03-13?23:50??StuManage\StuManage\com\dis\CalcuteNum$3.class

?????文件???????1109??2010-03-13?23:50??StuManage\StuManage\com\dis\CalcuteNum$4.class

?????文件???????6841??2010-03-13?23:50??StuManage\StuManage\com\dis\CalcuteNum.class

?????文件???????8127??2010-03-13?23:50??StuManage\StuManage\com\dis\CalcuteNum.java

?????文件????????636??2010-03-13?23:47??StuManage\StuManage\com\dis\FindStu$1.class

?????文件????????641??2010-03-13?23:47??StuManage\StuManage\com\dis\FindStu$2.class

?????文件???????1091??2010-03-13?23:47??StuManage\StuManage\com\dis\FindStu$3.class

?????文件???????1093??2010-03-13?23:47??StuManage\StuManage\com\dis\FindStu$4.class

?????文件???????1091??2010-03-13?23:47??StuManage\StuManage\com\dis\FindStu$5.class

?????文件???????9193??2010-03-13?23:47??StuManage\StuManage\com\dis\FindStu.class

?????文件??????10861??2009-03-12?17:01??StuManage\StuManage\com\dis\FindStu.java

?????文件???????1103??2010-03-13?23:47??StuManage\StuManage\com\dis\Mainframe$1.class

?????文件???????1105??2010-03-13?23:47??StuManage\StuManage\com\dis\Mainframe$2.class

?????文件???????1128??2010-03-13?23:47??StuManage\StuManage\com\dis\Mainframe$3.class

?????文件???????1792??2010-03-13?23:47??StuManage\StuManage\com\dis\Mainframe.class

?????文件???????2984??2009-03-12?17:01??StuManage\StuManage\com\dis\Mainframe.java

?????文件????????622??2010-03-13?23:52??StuManage\StuManage\com\dis\StuManage$1.class

?????文件????????653??2010-03-13?23:52??StuManage\StuManage\com\dis\StuManage$2.class

?????文件????????653??2010-03-13?23:52??StuManage\StuManage\com\dis\StuManage$3.class

?????文件????????653??2010-03-13?23:52??StuManage\StuManage\com\dis\StuManage$4.class

?????文件????????648??2010-03-13?23:52??StuManage\StuManage\com\dis\StuManage$5.class

?????文件???????1105??2010-03-13?23:52??StuManage\StuManage\com\dis\StuManage$6.class

?????文件???????1099??2010-03-13?23:52??StuManage\StuManage\com\dis\StuManage$7.class

?????文件???????1103??2010-03-13?23:52??StuManage\StuManage\com\dis\StuManage$8.class

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