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
Ïà¹ØÎĵµ£º
ͨ³£Í¨¹ýrequest.getRemoteAddr()
È¡µÃ¿Í»§¶ËµÄIPµØÖ·£¬×ö¼øÈ¨ºÍУÑ飬Â߼ûÎÊÌ⣬ÄÇô¿Ï¶¨request.getRemoteAddr()³öÁËÎÊÌ⣬googleÏ£¬·¢ÏÖÓÐÈËÓöµ½ÀàËÆµÄÎÊÌâ¡£
×îÖÕ¶¨Î»Îªrequest.getRemoteAddr()ÕâÖÖ·½·¨Ôڴ󲿷ÖÇé¿ö϶¼ÊÇÓÐЧµÄ¡£µ«ÊÇÔÚͨ¹ýÁËApache,SquidµÈ·´Ïò´úÀíÈí¼þ¾Í²»ÄÜ»ñÈ¡µ½¿Í»§¶ËµÄÕæÊµIPµØÖ·ÁË¡£
......
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 ......
1¡¢Oracle8/8i/9iÊý¾Ý¿â£¨thinģʽ£©
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@localhost:1521:orcl"; //orclΪÊý¾Ý¿âµÄSID
String user="test";
String password="test";
Connection conn= DriverManager.getC ......