package?Stu;

import?java.sql.*;

/**
?*?連接數(shù)據(jù)庫的類
?*/
public?class?Database?{
	
	private?Statement?stmt=null;
	ResultSet?rs=null;
	private?Connection?conn=null;
	String?sql;
	String?strurl=“jdbc:odbc:scmanage“;
	
	public?Database（）{
	}
	
	/**
	?*?打開數(shù)據(jù)庫連接
	?*/
	public?void?OpenConn（）throws?Exception{
		try{
			Class.forName（“sun.jdbc.odbc.JdbcOdbcDriver“）;?
			conn=DriverManager.getConnection（strurl）;
		}
		catch（Exception?e）{?
			System.err.println（“OpenConn:“+e.getMessage（））;
		}
	}

	/**
	?*?執(zhí)行SQL查詢語句，返回結(jié)果集RS
	?*/
	public?ResultSet?executeQuery（String?sql）{
		stmt?=?null;
		rs=null;
		try{
			stmt=conn.createStatement（ResultSet.TYPE_SCROLL_INSENSITIVEResultSet.CONCUR_READ_ONLY）;
			rs=stmt.executeQuery（sql）;
		}
		catch（SQLException?e）{
			System.err.println（“executeQuery:“+e.getMessage（））;
		}
		return?rs;
	}

	/**
	?*?執(zhí)行SQL更新語句
	?*/
	public?void?executeUpdate（String?sql）{
		stmt=null;
		rs=null;
		try{
			stmt=conn.createStatement（ResultSet.TYPE_SCROLL_INSENSITIVEResultSet.CONCUR_READ_ONLY）;
			stmt.executeQuery（sql）;		
			conn.commit（）;
		}
		catch（SQLException?e）{
			System.err.println（“executeUpdate:“+e.getMessage（））;?
		}
	}
	
	public?void?closeStmt（）{
		try{
			stmt.close（）;
		}
		catch（SQLException?e）{
			System.err.println（“closeStmt:“+e.getMessage（））;?
		}
	}

	/**
	?*?關(guān)閉數(shù)據(jù)庫連接
	?*/
	public?void?closeConn（）{
		try{
			conn.close（）;
		}
		catch（SQLException?ex）{
			System.err.println（“aq.closeConn:“+ex.getMessage（））;?
		}
	}
	
	/*
	?*轉(zhuǎn)換編碼
	?*/
	public?static?String?toGBK（String?str）{
		try?{
			if（str==null）
				str?=?““;
			else
				str=new?String（str.getBytes（“ISO-8859-1“）“GBK“）;?
		}
		catch?（Exception?e）?{System.out.println（e）;}
		
		return?str;
	}
}

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

?????文件?????477184??2010-06-27?18:23??JAV課程設(shè)計(jì)\Java課程設(shè)計(jì)報告.doc

?????文件???????2753??2009-06-06?00:36??JAV課程設(shè)計(jì)\打包發(fā)布\icon.jpg

?????文件?????442368??2010-06-13?17:36??JAV課程設(shè)計(jì)\打包發(fā)布\scmanage.mdb

?????文件??????17958??2010-06-22?01:18??JAV課程設(shè)計(jì)\打包發(fā)布\Student.jar

?????文件?????243166??2010-05-29?23:02??JAV課程設(shè)計(jì)\打包發(fā)布\welcome.jpg

?????文件?????????66??2010-06-13?19:43??JAV課程設(shè)計(jì)\打包發(fā)布\專業(yè).txt

?????文件???????1839??2010-06-21?23:12??JAV課程設(shè)計(jì)\源代碼\Database.java

?????文件???????3807??2010-06-21?23:12??JAV課程設(shè)計(jì)\源代碼\DeleteStudent.java

?????文件???????3632??2010-06-21?23:17??JAV課程設(shè)計(jì)\源代碼\InputStudent.java

?????文件???????4108??2010-06-21?23:11??JAV課程設(shè)計(jì)\源代碼\MainWindow.java

?????文件???????5397??2010-06-22?00:42??JAV課程設(shè)計(jì)\源代碼\ModifyStudent.java

?????文件???????3663??2010-06-21?23:12??JAV課程設(shè)計(jì)\源代碼\QueryStudent.java

?????文件???????3834??2010-06-21?23:12??JAV課程設(shè)計(jì)\源代碼\StuBean.java

?????目錄??????????0??2010-06-22?01:39??JAV課程設(shè)計(jì)\打包發(fā)布

?????目錄??????????0??2010-06-23?11:07??JAV課程設(shè)計(jì)\源代碼

?????目錄??????????0??2010-06-27?18:23??JAV課程設(shè)計(jì)

-----------?---------??----------?-----??----

??????????????1209775????????????????????16