Java Swing JScrollPane,JTable
ͬÊÂÒªÒ»¸öºÍAccess¹¦ÄÜÀàËÆµÄÈí¼þ£¬µ«ÊÇÒªÂú×ãËýÌá³öµÄ¸÷ÖÖÒªÇó¡£ËýÖªµÀÎÒÊÇ×öÈí¼þµÄ£¬ËùÒÔÈÃÎÒ¸øÐ´Ò»¸ö£¬ÏëÏëËýµÄÌáµÄÐèÇóºÜÈÝÒ×ʵÏÖ£¬ËùÒԾʹðÓ¦ÁË¡£ÒòΪAccessµÄ¹¦ÄÜËý¾ÍÓÃÀ´¹ÜÀí±í¸ñ£¬ÈÕ³£µÄºÜ¶à±í¸ñºÜ¶à£¬¶¼ÐèÒª½øÐеç×ÓµµµÄµÇ¼Ç¡£´ËÈí¼þ¿Ï¶¨ÒªÊµÏÖ±í¸ñ²Ù×÷µÄ¹¦ÄÜ£¬ËäÈ»¸ãJAVAÒѾ¿ìÁ½ÄêÁË£¬µ«ÊÇ»ù±¾É϶¼ÊÇдB/S¼Ü¹¹µÄ¡£ÕûÒ»¸öJScrollPaneÓëJTableã¶ÊÇ»¨ÁËÎÒÒ»¸öСʱ£¬Ö÷Òª¾Í¿¨ÔÚ±í¸ñµÄˮƽ¹ö¶¯ÌõÎÞ·¨¹ö¶¯¡£
ÒÔÏÂÊÇÁ½ÕßµÄ×éºÏʾÀý,Ô´ÂëÖÐÒѾ¼ÓÈë±ØÒªµÄ×¢ÊÍ£º
1.Ö÷½çÃæ
package ibees.swing;
import java.awt.HeadlessException;
import java.awt.Toolkit;
import javax.swing.JFrame;
import javax.swing.JScrollPane;
import javax.swing.JTable;
/**
*JScrollPaneºÍJTableµÄʹÓÃʾÀý
* @author hhzxj2008
*/
public class JScrollPaneSample extends JFrame{
/**
* @param args the command line arguments
*/
public static void main(String[] args) {
java.awt.EventQueue.invokeLater(new Runnable(){
public void run() {
new JScrollPaneSample("¹ö¶¯Ê¾Àý").setVisible(true);
}
});
}
public JScrollPaneSample(String title) throws HeadlessException {
super(title);
setDefaultCloseOperation(EXIT_ON_CLOSE);
JTable table = new JTable(new SampleTableModel(20000,40));
table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);//¹Ø±Õ±í¸ñÁÐ×Ô¶¯µ÷Õû£¬´Ëʱˮƽ¹ö¶¯Ìõ¿É¼û
JScrollPane jscrollPane = new JScrollPane(table);//½«TableÌí¼Óµ½¿É¹ö¶¯Paneµ±ÖÐ
add(jscrollPane);
//ÉèÖÃJFrame´°ÌåµÄ´óСΪ·Ö±æÂÊ-50£¬²¢ÉèÖô°ÌåµÄ×óÉϽǵÄλÖÃ
setBounds(25,25,(int)Toolkit.getDefaultToolkit().getScreenSize().getWidth()-50,(int)Toolkit.getDefaultToolkit().getScreenSize().getHeight()-50);
}
}
2.TableModel
package ibees.swing;
import javax.swing.table.AbstractTableModel;
/**
* ±í¸ñÄ£°å£¬Ö¸¶¨Ê¹ÓôËÄ£°åµÄ±í¸ñµÄÐÐÊýºÍÁÐÊý£¬²¢Ö¸¶¨ÁкÍÐн»»ã´¦µÄÖµ¡£
* @author hhzxj2008
*/
public class SampleTableModel extends AbstractTableModel{
private int rowNum
Ïà¹ØÎĵµ£º
ÏÖÔÚUrlRewriter¼¼ÊõÓÐÁ½¸ö¼¼Êõƽ̨µÄ£¬Ò»¸ö¾ÍÊÇÔÚJava·½ÏòµÄ£¬ÁíÒ»¸ö¾ÍÊÇ.NET·½ÏòµÄ¡£Õâ´ÎÊÇJava·½ÏòµÄÓ¦Óá£
Ê×ÏÈÈÃÎÒÃÇÁ˽âËüµÄ¹¤×÷ÔÀí£¬Ëµ°×ÁËËü¾ÍÊÇÒ»¸ö¼òµ¥µÄ¹ýÂËÆ÷£¨Filter£©£¬¿´¿´Ô´ÂëÄã¾Í»áºÜ¿ìµÄÃ÷°×£¬Ëü¾ÍÊÇͨ¹ýÎÒÃÇÔÚjspÖг£ÓõÄÁ½¸ö·½·¨ÊµÏÖµÄforward(),sendRedirect().
ÏÂÃæÎÒÃǾͿìËÙµÄΪÄãµÄÍøÕ¾´î½¨U ......
System.out.println(2|0); //0010 0000 =>0010 = 2
System.out.println(2|1); //0010 0001 =>0011 = 3
System.out.println(3|2); //0011 0010 =>0011 = 3
System.out.println(3&2); //0011 0010 =>0010 = 2
/*
ÔÚjavaÖÐ0´ú±í¼Ù, 1´ú±íÕæ
00011|0010 ´ÓÓÒµ½×ó±È½Ï0|1 = 1, 1|0 = ......
jar Ó¦Óà ÏÈ´ò¿ªÃüÁîÌáʾ·û(win2000»òÔÚÔËÐпðÀïÖ´ÐÐcmdÃüÁwin98ΪDOSÌáʾ·û)£¬ÊäÈëjar
-help,È»ºó»Ø³µ(Èç¹ûÄãÅÌÉÏÒѾÓÐÁËjdk1.1»òÒÔÉϰ汾)£¬¿´µ½Ê²Ã´£º
Ó÷¨£ºjar {ctxu}[vfm0Mi] [jar-Îļþ]
[manifest-Îļþ] [-C Ŀ¼] ÎļþÃû ...
Ñ¡Ï
-c ´´½¨ÐµĴ浵
-t Áгö´æµµÄÚÈݵÄÁбí
-x
Õ¹¿ª´æµµÖеÄÃüÃûµ ......
create or replace procedure updateProject is
begin
update project p set p.total_intend_gather =
(select sum(ig.gather_sum) from intend_gather ig where ig.project_number=p.project_number);
up ......