javasqljtable表格查询.docx
- 文档编号:6248260
- 上传时间:2023-01-04
- 格式:DOCX
- 页数:13
- 大小:18.10KB
javasqljtable表格查询.docx
《javasqljtable表格查询.docx》由会员分享,可在线阅读,更多相关《javasqljtable表格查询.docx(13页珍藏版)》请在冰豆网上搜索。
javasqljtable表格查询
javaswingsql->jtable表格查询
分类:
java2010-08-1119:
371132人阅读评论(0)收藏举报
swingjavastringnulllistobject
数据库连接类
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.SQLException;
publicclassDBConnection{
publicstaticConnectiongetConnection(){
Connectionconn=null;
Stringdriver="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(ClassNotFoundExceptione){
e.printStackTrace();
}catch(SQLExceptione){
e.printStackTrace();
}
returnconn;
}
}
业务类
publicclassCountry{
privateStringname;
privateStringregion;
privateStringarea;
privateStringpopulation;
privateStringgdp;
publicStringgetName(){
returnname;
}
publicvoidsetName(Stringname){
this.name=name;
}
publicStringgetRegion(){
returnregion;
}
publicvoidsetRegion(Stringregion){
this.region=region;
}
publicStringgetArea(){
returnarea;
}
publicvoidsetArea(Stringarea){
this.area=area;
}
publicStringgetPopulation(){
returnpopulation;
}
publicvoidsetPopulation(Stringpopulation){
this.population=population;
}
publicStringgetGdp(){
returngdp;
}
publicvoidsetGdp(Stringgdp){
this.gdp=gdp;
}
}
表格模型类
importjavax.swing.table.AbstractTableModel;
publicclassTableModelextendsAbstractTableModel{
public finalstaticString[]columnHeaders={
"国家名称","所属地区","国家面积","人口数量","国家GDP"
};
privateObject[][]datavalues={
{"","","","",""}
};
publicintgetColumnCount(){
returndatavalues[0].length;
}
publicintgetRowCount(){
returndatavalues.length;
}
publicObjectgetValueAt(introwIndex,intcolumnIndex){
returndatavalues[rowIndex][columnIndex];
}
publicStringgetColumnName(intcolumn){
returncolumnHeaders[column];
}
publicvoidsetDatavalues(Object[][]datavalues){
this.datavalues=datavalues;
}
}
数据库操作类
importjava.sql.Connection;
importjava.sql.PreparedStatement;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjava.sql.Statement;
importjava.util.ArrayList;
importjava.util.List;
publicclassCountryOperate{
staticinti=1;
staticintx=0;
publicstaticList
Stringsql="selecttop5*frombbcorderbyname";
List
returnlist;
}
publicstaticList
inty=queryCount();
List
intcount=0;//总页数
if(y%5==0){
count=y/5;
}else{
count=y/5+1;
}
if(i x=((++i)-1)*5; Stringsql="selecttop" +x +"*from(select*frombbcwherenamenotin(selecttop" +x+"namefrombbcorderbyname))asA"; list=query(sql); }elseif(i>=count){ list=null; } returnlist; } publicstaticintqueryCount(){ intcount=0; Connectionconn=DBConnection.getConnection(); Stringsql="selectcount(*)frombbc"; Statementstmt=null; ResultSetrs=null; try{ stmt=conn.createStatement(); rs=stmt.executeQuery(sql); while(rs.next()){ count=rs.getInt (1); } }catch(SQLExceptione){ e.printStackTrace(); }finally{ try{ if(rs! =null) rs.close(); if(stmt! =null) stmt.close(); if(conn! =null) conn.close(); }catch(SQLExceptione){ e.printStackTrace(); } } returncount; } publicstaticList Connectionconn=DBConnection.getConnection(); List Statementstmt=null; ResultSetrs=null; try{ stmt=conn.createStatement(); rs=stmt.executeQuery(sql); while(rs.next()){ Countrycou=newCountry(); cou.setName(rs.getString (1)); cou.setRegion(rs.getString (2)); cou.setArea(rs.getString(3)); cou.setPopulation(rs.getString(4)); cou.setGdp(rs.getString(5)); list.add(cou); } }catch(SQLExceptione){ e.printStackTrace(); }finally{ try{ if(rs! =null) rs.close(); if(stmt! =null) stmt.close(); if(conn! =null) conn.close(); }catch(SQLExceptione){ e.printStackTrace(); } } returnlist; } publicstaticList List if(i>2){ x=((--i)-1)*5; Stringsql="selecttop" +x +"*from(select*frombbcwherenamenotin(selecttop" +x+"namefrombbcorderbyname))asA"; list=query(sql); }elseif(i==2){ list=queryFirst(); i--; }elseif(i<2){ list=null; } returnlist; } publicstaticbooleanadd(Countrycou){ Connectionconn=DBConnection.getConnection(); PreparedStatementpstmt=null; Stringsql="insertintobbcvalues(? ? ? ? ? )"; intx=0; try{ pstmt=conn.prepareStatement(sql); pstmt.setString(1,cou.getName()); pstmt.setString(2,cou.getRegion()); pstmt.setString(3,cou.getArea()); pstmt.setString(4,cou.getPopulation()); pstmt.setString(5,cou.getGdp()); x=pstmt.executeUpdate(); }catch(SQLExceptione){ e.printStackTrace(); }finally{ try{ if(pstmt! =null) pstmt.close(); if(conn! =null){ conn.close(); } }catch(SQLExceptione){ e.printStackTrace(); } } if(x==1){ returntrue; }else{ returnfalse; } } publicstaticbooleandel(Stringkey){ Connectionconn=DBConnection.getConnection(); PreparedStatementstmt=null; Stringsql="deletefrombbcwherename=? "; intx=0; try{ stmt=conn.prepareStatement(sql); stmt.setString(1,key); x=stmt.executeUpdate(); }catch(SQLExceptione){ e.printStackTrace(); }finally{ try{ if(stmt! =null) stmt.close(); if(conn! =null) conn.close(); }catch(SQLExceptione){ e.printStackTrace(); } } if(x==1){ returntrue; }else{ returnfalse; } } publicstaticbooleanmodify(Countrycou){ Connectionconn=DBConnection.getConnection(); PreparedStatementpstmt=null; Stringsql="updatebbcsetRegion=? Area=? Population=? Gdp=? wherename=? "; intx=0; try{ pstmt=conn.prepareStatement(sql); pstmt.setString(1,cou.getName()); pstmt.setString(2,cou.getArea()); pstmt.setString(3,cou.getPopulation()); pstmt.setString(4,cou.getGdp()); pstmt.setString(5,cou.getName()); x=pstmt.executeUpdate(); }catch(SQLExceptione){ e.printStackTrace(); } if(x==1){ returntrue; }else{ returnfalse; } } } 主界面类 importjava.awt.Rectangle; importjava.awt.event.ActionEvent; importjava.awt.event.ActionListener; importjava.util.List; importjavax.swing.JButton; importjavax.swing.JComboBox; importjavax.swing.JFrame; importjavax.swing.JLabel; importjavax.swing.JOptionPane; importjavax.swing.JPanel; importjavax.swing.JScrollPane; importjavax.swing.JTable; importjavax.swing.JTextField; importjavax.swing.SwingUtilities; publicclassCountryInfoGuiimplementsActionListener{ privateJFramejFrame; privateJPaneljContentPane; privateJLabellblName=null; privateJTextFieldtfName=null; privateJLabellblRegion=null; privateJComboBoxcbRegion=null; privateJLabellblArea=null; privateJTextFieldtfArea=null; privateJLabellblPopu=null; privateJTextFieldtfPopu=null; privateJLabellblGdp=null; privateJTextFieldtfGDP=null; privateJButtonbtnAdd=null; privateJButtonbtnDel=null; privateJButtonbtnModify=null; privateJButtonbtnQuery=null; privateJButtonbtnUpPage=null; privateJButtonbtnDownPage=null; privateJTabletable=null; TableModeltm=null; JScrollPanejsp=null; privateJTextFieldgetTfName(){ if(tfName==null){ tfName=newJTextField(); tfName.setBounds(newRectangle(89,17,173,27)); } returntfName; } privateJComboBoxgetCbRegion(){ if(cbRegion==null){ String[]str={"请选择","亚洲","欧洲","非洲","北美洲","南美洲","大洋洲", "南极洲"}; cbRegion=newJComboBox(str); cbRegion.setBounds(newRectangle(360,17,229,28)); } returncbRegion; } privateJTextFieldgetTfArea(){ if(tfArea==null){ tfArea=newJTextField(); tfArea.setBounds(newRectangle(89,61,173,27)); } returntfArea; } privateJTextFieldgetTfPopu(){ if(tfPopu==null){ tfPopu=newJTextField(); tfPopu.setBounds(newRectangle(360,61,229,28)); } returntfPopu; } privateJTextFieldgetTfGDP(){ if(tfGDP==null){ tfGDP=newJTextField(); tfGDP.setBounds(newRectangle(89,105,173,27)); } returntfGDP; } privateJButtongetBtnAdd(){ if(btnAdd==null){ btnAdd=newJButton(); btnAdd.setBounds(newRectangle(46,152,71,30)); btnAdd.addActionListener(this); btnAdd.setText("添加"); } returnbtnAdd; } privateJButtongetBtnUpPage(){ if(btnUpPage==null){ btnUpPage=newJButton("上一页"); btnUpPage.addActionListener(this); btnUpPage.setBounds(200,390,80,30); } returnbtnUpPage; } privateJButtongetBtnDownPage(){ if(btnDownPage==null){ btnDownPage=newJButton("下一页"); btnDownPage.addActionListener(this); btnDownPage.setBounds(300,390,80,30); } returnbtnDownPage; } privateJButtongetBtnDel(){ if(btnDel==null){ btnDel=newJButton(); btnDel.setBo
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- javasqljtable 表格 查询