資源描述：
《java_sql_jtable表格查詢》由會員上傳分享，免費在線閱讀，更多相關(guān)內(nèi)容在教育資源-天天文庫。
1、javaswingsql->jtable表格查詢分類:java2010-08-1119:371132人閱讀評論(0)收藏舉報swingjavastringnulllistobject數(shù)據(jù)庫連接類importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.SQLException;publicclassDBConnection{??publicstaticConnectiongetConnection(){??Connectionconn=null;??Stringdriv
2、er="com.microsoft.jdbc.sqlserver.SQLServerDriver";??Stringurl="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Instane";??Stringusername="sa";??Stringpassword="";????try{???Class.forName(driver);???conn=DriverManager.getConnection(url,username,password);??}catch(ClassNot
3、FoundExceptione){???e.printStackTrace();??}catch(SQLExceptione){???e.printStackTrace();??}??returnconn;?}}業(yè)務(wù)類????publicclassCountry{?privateStringname;?privateStringregion;?privateStringarea;?privateStringpopulation;?privateStringgdp;?publicStringgetName(){??returnname;?}?publi
4、cvoidsetName(Stringname){??this.name=name;?}?publicStringgetRegion(){??returnregion;?}?publicvoidsetRegion(Stringregion){??this.region=region;?}?publicStringgetArea(){??returnarea;?}?publicvoidsetArea(Stringarea){??this.area=area;?}?publicStringgetPopulation(){??returnpopulatio
5、n;?}?publicvoidsetPopulation(Stringpopulation){??this.population=population;?}?publicStringgetGdp(){??returngdp;?}?publicvoidsetGdp(Stringgdp){??this.gdp=gdp;?}}表格模型類???importjavax.swing.table.AbstractTableModel;publicclassTableModelextendsAbstractTableModel{?public?finalstatic
6、String[]columnHeaders={??"國家名稱","所屬地區(qū)","國家面積","人口數(shù)量","國家GDP"?};??privateObject[][]datavalues={???{"","","","",""}?};??publicintgetColumnCount(){??returndatavalues[0].length;?}?publicintgetRowCount(){??returndatavalues.length;?}?publicObjectgetValueAt(introwIndex,intcolumnIndex)
7、{??returndatavalues[rowIndex][columnIndex];?}??publicStringgetColumnName(intcolumn){??returncolumnHeaders[column];?}?publicvoidsetDatavalues(Object[][]datavalues){??this.datavalues=datavalues;?}}數(shù)據(jù)庫操作類??importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.R
8、esultSet;importjava.sql.SQLException;importjava.sql.St
