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Óï¾ä¶ÔÐÅÏ¢Ìáʾ¿ò(³öÏÖ´ÎÊý)ÓÐÓ°Ï죬Äܲ
Ïà¹ØÎÊ´ð£º
±¾ÈËÕýÔÚÓÃJava×öÒ»¸öC/S¼Ü¹¹µÄÏîÄ¿£¬
¿ÉÊÇÓÉÓÚÏîÄ¿±È½Ï´ó£¬Ç°ÆÚ¶Ô¼Ü¹¹µÄÉè¼ÆÓÈÆäÖØÒª£¬ÒòΪºóÆÚ¿ÉÄÜËæÊ±»á¼Ó¸ö¹¦ÄÜ»òÕßÈ¥µôijЩ¹¦ÄÜ¡£
ËùÒÔÌØµØÑ°ÇóÈçºÎÉè¼ÆC/SµÄ¼Ü¹¹Ê¹³ÌÐò¸ü¼ÓÃæÏò¶ÔÏó¸ü¼ÓÒ×ÓÚά ......
¾ÍÊǼòµ¥µÄ´«ÖµºÍȡֵ
ÇëÎÊÂ¥Ö÷ÏëÎÊʲô£¿
jspÒ³Ãæ²ÉÓÃ±íµ¥»òÕßjavabean´«Öµ¶¼¿ÉÒÔ£¬Ê¹ÓÃrequest.getParameter()»ñµÃʹÓÃ±íµ¥´«¹ýÀ´µÄÖµ¡£
ÎÊÎÊÌ⣬ÏȰÑÎÊÌâ˵Çå³þµã£¡£¡ ÎÊÌâ̫ģºý£¡£¡
ÎÊÎÊÌ⣬ÏȰÑÎ ......
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 ......
ÏÖÔÚ²»ÏëÓÃ<a> </a> ±êÇ© £¬ÒòΪµã»÷ºó»á³öÏÖÒ³ÃæÖØ¶¨Î»£¬¸øÎÄ×Ö¼ÓÉÏcssÑùʽ¾Í¿ÉÒÔ¿´ÆðÀ´ ÊÇhrefÔõôʵÏÖÕâÑùµÄcss
text-decoration:underline; cursor:hand;
ÒýÓÃ
text-decoration:underline; cur ......