📄 liulan1.java
字号:
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.event.*;
import javax.swing.table.*;
import java.util.*;
import java.sql.*;
/////////进货浏览
public class Liulan1 extends JFrame implements ActionListener
{
JTable table;
DefaultTableModel dtm;
Vector title=new Vector();
JScrollPane p1;
JPanel p2=new JPanel();
String sql;
JButton b1=new JButton("首页");
JButton b2=new JButton("上一页");
JButton b3=new JButton("下一页");
JButton b4=new JButton("底页");
JLabel bb=new JLabel(" ");
int count=0; //记录数
int pagesize=6; //页大小
int pagecount=0; //页数
int page=1; //当前
Statement s;
ResultSet rs;
public Liulan1()//1
{
sql="select spmc as 商品名称, dj as 单价,sl as 数量,je as 收入,sj as 时间,jsr as 接手人 from out1 order by spmc";
try//2
{
String url="jdbc:odbc:Test";
Connection con=DriverManager.getConnection(url);
s=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=s.executeQuery(sql);
count=getcount();
pagecount=(int)count/pagesize+(count%pagesize==0?0:1);
ResultSetMetaData dbmd=rs.getMetaData();
for(int i=1;i<=dbmd.getColumnCount();i++)
{
title.addElement(dbmd.getColumnName(i));
}
dtm=new DefaultTableModel(null,title);
table=new JTable(dtm);
initTable();
table.setRowHeight(20);
p1=new JScrollPane(table);
if(pagecount!=0)
{
bb.setText(""+page);
}
b1.addActionListener(this);
b2.addActionListener(this);
b3.addActionListener(this);
b4.addActionListener(this);
p2.add(b1);
p2.add(b2);
p2.add(b3);
p2.add(b4);
p2.add(bb);
this.getContentPane().add(p1,"Center");
this.getContentPane().add(p2,"South");
}//2
catch(Exception e)
{
}
this.addWindowListener(new WindowAdapter()
{
public void windowClosing(WindowEvent e)
{
try
{
rs.close();
s.close();
}catch(Exception wwww)
{
}
}
} );
super.setTitle("出货记录浏览");
super.setVisible(true);
super.setSize(500,300);
}//1
void initTable()
{
dtm.setRowCount(0);
try
{//1
rs.beforeFirst();
for(int i=1;i<1+pagesize*(page-1);i++)
rs.next();
int j=0;
while(j<pagesize&&rs.next())
{
j++;
Vector v1=new Vector();
for(int i=1;i<=title.size();i++)
v1.addElement(rs.getString(i));
dtm.addRow(v1);
}
}//1
catch(Exception eee)
{
}
dtm.fireTableStructureChanged();
}
public int getcount()
{
int n=0;
try
{
if(rs.last())
{
n=rs.getRow();
rs.beforeFirst();
return n;
}
else return 0;
}
catch(Exception eeww){return 0;}
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==b1){page=1;}
else if(e.getSource()==b2){if(page>1)page=page-1;}
else if(e.getSource()==b3){if(page<pagecount)page=page+1;}
else if(e.getSource()==b4){page=pagecount;}
initTable();
bb.setText("<html><font color=blue>第"+page+"页</font></html>");
}
// public static void main(String args[])
// {
// new Liulan1();
// }
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -