JavaÐÅÏ¢Ìáʾ¿ò - Java / Java SE
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
Connection conn=DBUtil.getConnection();
Statement stmt=null;
try{
stmt=conn.createStatement();
String sql="select * from user";
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
if(jTextField1.getText().equals(rs.getString("username"))){
JOptionPane.showMessageDialog(null,"¸ÃÓû§ÃûÒѾ´æÔÚ£¬²»¿ÉÒÔʹÓá£");
}else if(jTextField1.getText().equals("")){
JOptionPane.showMessageDialog(null,"Óû§Ãû²»ÄÜΪ¿Õ£¬ÇëÖØÐÂÌîд£¡");
}else if(!jTextField1.getText().equals(rs.getString("username"))){
JOptionPane.showMessageDialog(null,"¸ÃÓû§Ãû²»´æÔÚ£¬¿ÉÒÔʹÓá£");
}
}
}catch(SQLException e){
e.printStackTrace();
}finally{
try{
stmt.close();
DBUtil.close(conn);
}catch(SQLException e){
e.printStackTrace();
}
}
}
ÕâÀïµÄwhileÓï¾ä¶ÔÐÅÏ¢Ìáʾ¿ò(³öÏÖ´ÎÊý)ÓÐÓ°Ï죬Äܲ
Ïà¹ØÎÊ´ð£º
µ±ÖªµÀÒ»¸öÈÕÆÚ£¬ÈçºÎ°ÑÕâ¸öÈÕÆÚËùÔÚÑ®µÄǰºóÁ½¸öÈÕÆÚÈ¡³ö
±ÈÈçÊäÈë20090905£¬¾ÍÊäÈë20090901 20090910
Êä³ö20090901 20090910
È¡µÃÌìÊýºó×÷Ò»ÏÂÅжÏÔÙ°ÑÕâ¸ö·½·¨ÓÃÏÂvoid set(int field, int value)
......
±¾ÈËÕýÔÚÓÃJava×öÒ»¸öC/S¼Ü¹¹µÄÏîÄ¿£¬
¿ÉÊÇÓÉÓÚÏîÄ¿±È½Ï´ó£¬Ç°ÆÚ¶Ô¼Ü¹¹µÄÉè¼ÆÓÈÆäÖØÒª£¬ÒòΪºóÆÚ¿ÉÄÜËæÊ±»á¼Ó¸ö¹¦ÄÜ»òÕßÈ¥µôijЩ¹¦ÄÜ¡£
ËùÒÔÌØµØÑ°ÇóÈçºÎÉè¼ÆC/SµÄ¼Ü¹¹Ê¹³ÌÐò¸ü¼ÓÃæÏò¶ÔÏó¸ü¼ÓÒ×ÓÚά ......
ΪʲôHTMLÒÔ¼°Ò»Ð©ÆäËü±êÇ©»áÏÔÊ¾Ò»Ð©ÌØ¶¨±íÏÖÐÎÊ½ÄØ£¿ÈçHTMLÖеĻ»ÐбêÇ©<BR/>ÔڵײãÊÇÔõÑùʵÏÖµÄÄØ£¿ÏÖʵµÄÔÀíÊÇÊ²Ã´ÄØ
È¥W3C¹Ù·½ÍøÕ¾ÉÏ£¬¿´¿´°É£¡ÎÒÏëÒ»¿´Äã¾ÍÃ÷°×ÁË
ÎҲºͱàÒëÔÀíÓйأ¬ä¯ÀÀÆ÷Àï¿É ......
id name datetime
1 a 2010-05-13 10:15:00
2 b 2010-05-14 09:10:00
3 d 2010-05-14 10:10:00
ÈçºÎ½«¾àÀëĿǰ×î½üµÄÄǸö¼Ç¼µÄname ¸üÐÂΪ¡°x¡±ÄØ
лл¿© °¡ ºÇºÇ
update table_n ......