package?com.jzbr.ST57;

import?java.sql.*;

public?class?BasoDao?{
	public?static?final?String?DRIVER?=?“com.microsoft.sqlserver.jdbc.SQLServer“;

	public?static?final?String?URL?=?“jdbc.sqlserver://localhost:1433;databaseName=bbs“;

	public?static?final?String?UID?=?“sa“;

	public?static?final?String?PASS?=?“sa2005“;

	public?Connection?con?=?null;

	public?PreparedStatement?ps?=?null;

	public?ResultSet?rs?=?null;

	//?得到數(shù)據(jù)庫的連接方法
	public?Connection?getcon（）?{
		try?{
			Class.forName（DRIVER）;
			con?=?DriverManager.getConnection（URL?UID?PASS）;
		}?catch?（ClassNotFoundException?e）?{

			e.printStackTrace（）;
		}?catch?（SQLException?e）?{

			e.printStackTrace（）;
		}
		return?con;
	}

	//?關閉數(shù)據(jù)庫的連接法
	public?void?CloseAll（Connection?con?PreparedStatement?p

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

?????文件???????1206??2010-10-19?20:40??java連接sql?server數(shù)據(jù)庫增刪改查\BasoDao.java

?????文件???????1133??2012-05-10?15:57??java連接sql?server數(shù)據(jù)庫增刪改查\dao\impl\SqlServerBasoDao.java

?????文件???????5477??2012-05-10?16:58??java連接sql?server數(shù)據(jù)庫增刪改查\dao\impl\StudentDaoImpl.java

?????文件????????608??2012-05-10?15:27??java連接sql?server數(shù)據(jù)庫增刪改查\dao\StudentDao.java

?????文件????????954??2010-10-19?20:40??java連接sql?server數(shù)據(jù)庫增刪改查\Delete.java

????..A.SHR????????10??2010-12-28?13:38??java連接sql?server數(shù)據(jù)庫增刪改查\Desktop_1.ini

????..A.SHR????????10??2010-12-28?13:38??java連接sql?server數(shù)據(jù)庫增刪改查\Desktop_2.ini

?????文件???????1822??2012-05-10?14:57??java連接sql?server數(shù)據(jù)庫增刪改查\entity\Student.java

?????文件????????789??2010-10-19?20:40??java連接sql?server數(shù)據(jù)庫增刪改查\Insert.java

?????文件??????13925??2012-05-10?16:40??java連接sql?server數(shù)據(jù)庫增刪改查\prod.sql

?????文件???????1007??2010-10-19?20:40??java連接sql?server數(shù)據(jù)庫增刪改查\Select.java

?????文件?????537303??2012-03-15?22:11??java連接sql?server數(shù)據(jù)庫增刪改查\sqljdbc4.jar

?????文件????????796??2010-10-19?20:40??java連接sql?server數(shù)據(jù)庫增刪改查\Update.java

?????目錄??????????0??2012-07-21?23:48??java連接sql?server數(shù)據(jù)庫增刪改查\dao\impl

?????目錄??????????0??2012-07-21?23:48??java連接sql?server數(shù)據(jù)庫增刪改查\dao

?????目錄??????????0??2012-07-21?23:48??java連接sql?server數(shù)據(jù)庫增刪改查\entity

?????目錄??????????0??2012-07-21?23:48??java連接sql?server數(shù)據(jù)庫增刪改查

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

???????????????565040????????????????????17