2空间数据库实验指导书_JDBC

《2空间数据库实验指导书_JDBC》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、JDBC实验1、新建javaI程FileEditSourceRefactorNavigateSearchProjectMyEdipseRunWindowHelptf,PackageNWebServiceProject7jProject..F3F4AJuShift・W»CtrUCCtrkVDeleteNewrSPackageExploOpenOpenWith諾njsdzMatcbOpenTypeHierarchy▲QpostgresjcShowIn▲凸src直Copy▲ffi(defdt>[T]p—CopyQu

2、alifiedName>l[?

3、T]Paste0■JRESyslXDelete>ReferenBuildPath㈠SocketServSourceRefactorAlt・ShifHS►Ah-ShifuT►右磐出癖*mport-Export.ReferencesDeclarations命RefreshF5AssignWorkingSets...dEJBProject一-EnterpriseApplicationProjectGWebProjectGClassOInterfaceGEnum@Annotationd

4、SourceFolder号JavaWorkingSetC3FolderFileUntitledTextFileReportTemplateabru输入工程名称，记住工程存放的路径便于代码备份QNewJavaProject下一步，在libraries页血点击“addexternalJars”，加载postgres的JDBC开发包“postgresql-921003.jdbc4.jar”，然后finish即可选择TesttI程的src目录，右键，新建class对象儒PackageExplorer為°□U]SQLS

5、erver.java,J]TestKV.java丄Field.java①inf匚1*▽一importjava.sql.Connection;▲QpostAJF>aKR:£Sock▲BTestt&siNew►OpeninNewWindowOpenTypeHierarchyF4ShowInAlt+Shift+W►38)CopyCtrl+C謹CopyQualifiedName肃PasteCtrl+VXDeleteDeleteiBuildPath►1SourceAlt+Shift+S►Refacto

6、rAlt+Shift+T►込Import...必Export...夸RefreshF5JavaProjectReportWebProjectEJBProjectEnterpriseApplicationProjectWebProjectWebServiceProjectProject...PackageInterfaceEnumAnnotationSourceFolderJavaWorkingSetFolderleK输入相关信息再建立新java类填入代码-importjava.sql.Connection;i

7、mportjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;publicclassPostGISDB{Connectionconn=null;-publicPostGISDB(){try{Class./or/Vame(Morg.postgresql.Driver*1);Stringurl=°jdbc:postgresql://localhost:5432/po

8、stgis";try{conn=DriverManage厂.getCorimu七io/i(u厂1$°postgres'Hadmin");}catch(SQLExceptione){e•printStackTrxe();}}catch(ClassNotFoundExceptione){e・pr^intStackTrace();}}-publicvoidttt(){St厂ingsql=,fSelectcity_name,st_astext(geom)FromCities,r;Statementstmt=null

9、;ResultSetrs=null;try{stmt=conn.CTeateStatement()；rs=stmt.executeQuery(sql);while(rs.next()){System.out.println(厂s•getString(l));System・outpQint丄n(rs・08七5上厂1.门0(2jj;}}catch(SQLExceptione){e・printStack