sqlserver2005數(shù)據(jù)庫連接java版

sqljdbc.jarJavajrelib\ext目錄下，在我的機器是因為我使用的是MyEclipse6.5開發(fā)工具. 要在代碼中刪除package這行語句packagejavacd參數(shù)-d不可以少packageimportpublicclass{privateStringDBDRIVER privateStringDBURL privateString privateString privateConnection =nullpublic{{

}catch(Exception{}}publicConnection{returnthis.conn}publicvoid{{}

catch(Exception{}}測試連接是否可以用的smis.sm.DBTest.JAVA packagesmis.sm;importsmis.db.dbc.*;publicclassDBTest{*@parampublicstaticvoidmain(String[]args)//TODOAuto-generatedmethodstubDataBaseConnectiondbc=null;dbc=new}{}{System.out.println("CannotgetA}}packagesmis.sm.vo;importjava.sql.*;publicclassStudent{privateStringno;privateStringname;privateStringsex;privateDatebirthday;privateStringdepartment;privateStringtelephone;publicStringgetNo(){return}publicvoidsetNo(Stringno)this.no=}publicStringgetName()return}publicvoidsetName(Stringname)=}publicStringgetSex()return}publicvoidsetSex(Stringsex)this.sex=}publicDategetBirthday()return}publicvoidsetBirthday(Datebirthday)this.birthday=}publicStringgetDepartment()return}publicvoidsetDepartment(Stringdepartment)this.department=}publicStringgetTelephone()return}publicvoidsetTelephone(Stringtelephone)this.telephone=}}packagesmis.sm.dao;importsmis.sm.vo.*;importjava.util.*;publicinterfaceStudentDAOpublicvoidinsert(Studentstudent)throwsExceptionpublicvoidupdate(Studentstudent)throwsExceptionpublicvoiddelete(Stringno)throwsExceptionpublicStudentqueryByNo(Stringno)throwsExceptionpublicListqueryAll()throwsExceptionpublicListqueryByLike(Stringcond)throwsException}packageimportimportjava.util.ArrayList;importjava.util.List;importsmis.db.dbc.*;importimportpublicclassStudentDAOImplimplementsStudentDAOpublicvoiddelete(Stringno)throwsException//Stringsql"DELETEFromSWHERE學號PreparedStatementpstmt=null;DataBaseConnectiondbc=null;dbc=newDataBaseConnection();{ pstmt.setString(1,no);pstmt.executeUpdate();pstmt.close();}catch(Exception{}{dbc.close()}}//publicvoidinsert(Studentstudent)throwsException//TODOAuto-generatedmethodStringsql"INSERTINTOS(學號,姓名,性別,出生日期,系PreparedStatementpstmt=null;DataBaseConnectiondbc=null;dbc=newDataBaseConnection();{ dbc.getConnection().prepareStatement(sql);pstmt.setString(1,student.getNo());pstmt.setString(2,student.getName());pstmt.setString(3,student.getSex());pstmt.setDate(4,student.getBirthday());pstmt.setString(6,student.getTelephone());pstmt.executeUpdate();pstmt.close()}catch(Exception{//System.out.println(e)}{dbc.close()}}//publicListqueryAll()throwsExceptionS"

//TODOAuto-generatedmethodstubListall=newArrayList();PreparedStatementpstmt=null;DataBaseConnectiondbc=null;dbc=newDataBaseConnection();{ dbc.getConnection().prepareStatement(sql);ResultSetrs=pstmt.executeQuery();{Studentstudent=newStudent();all.add(student)}rs.close();pstmt.close();}catch(Exception{}{dbc.close()}returnall}//publicListqueryByLike(Stringcond)throwsException//TODOAuto-generatedmethodstubListall=newArrayList();SWHERE學號LIKE?or姓名LIKE?or系LIKE?orLIKE?"PreparedStatementpstmt=null;DataBaseConnectiondbc=null;dbc=newDataBaseConnection();{ dbc.getConnection().prepareStatement(sql);pstmt.setString(1,"%"+cond+"%");pstmt.setString(2,"%"+cond+"%");pstmt.setString(3,"%"+cond+"%");pstmt.setString(4,"%"+cond+"%");ResultSetrs=pstmt.executeQuery();{Studentstudent=newStudent();all.add(student)}rs.close();pstmt.close();}catch(Exception{}{dbc.close()}returnall}//nopublicStudentqueryByNo(Stringno)throwsException//TODOAuto-generatedmethodstubStudentstudent=null;SWHERE學號PreparedStatementpstmt=null;DataBaseConnectiondbc=null;dbc=newDataBaseConnection();{ pstmt.setString(1,no);ResultSetrs=pstmt.executeQuery(){}rs.close();pstmt.close();}catch(Exception{}{dbc.close()}returnstudent}//publicvoidupdate(Studentstudent)throwsException//TODOAuto-generatedmethodStringsql"UPDATESSET姓名=?,性別=?,出生日期=?,PreparedStatementpstmt=null;DataBaseConnectiondbc=null;dbc=newDataBaseConnection();{ dbc.getConnection().prepareStatement(sql);pstmt.setString(1,student.getName());pstmt.setString(2,student.getSex());pstmt.setDate(3,student.getBirthday());pstmt.setString(5,student.getTelephone());pstmt.setString(6,student.getNo());pstmt.executeUpdate();pstmt.close()}catch(Exception{}{dbc.close()}}}packagesmis.sm.factory;importsmis.sm.dao.*;publicclassDAOFactory{publicstaticStudentDAO{returnnewStudentDAOImpl()}} packageimportsmis.sm.factory.*;importsmis.sm.vo.*;importjava.sql.*;importimportimportpublicclassStudentTestpublicstaticvoidmain(String[]args)//TODOAuto-generatedmethod}publicstaticvoid{Listall=null;);Studentfor(int{student=(Student)all.get(i);}}publicstaticvoid{Studentstudent=newStudent();student.setBirthdayjava.sql.Date.valueOf("2010-5-20"));}catch(Ex