JAVAѧϰµÄÊý¾Ý¿âÁ¬½Ó£¬Àý×ÓÒ»Ö»¡¡
³õѧJAVA£¬ºÃ²»ÈÝÒ×½â¾öÁËÕâ¸öÊý¾Ý¿âÁ¬½ÓÎÊÌ⣬Õâ¸öÖ÷ÒªÊÇÓÐÁ½¸öÎÊÌ⣬һ¸öÊÇJDBC-odbcµÄÎÊÌ⣬Èç¹ûûÓнâ¾öºÃÊý¾ÝÔ´ÅäÖ㬾ø¶ÔÊÇÓÐÈÝÒ׳öÎÊÌâµÄ£¬¼ÙÉèÄãʹÓõÄÊÇaccessµÄÊý¾Ý¿â£¬ÕâÊÇÍøÉϵÄÒ»¸öÀý×ÓµÄÓï¾ä
String dburl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=database.mdb";
Æäʵ²¢²»ÐèÒªÄÇô³¤£¬¼ÙÉèÄãµÄÊý¾ÝÔ´ÃûΪbook,String dburl="jdbc:odbc:book";ÕâÑù¾ÍÄÜ·ÃÎÊÁË£¬ÉÏÃæµÄд·¨Ó¦¸ÃÒ²¿ÉÒÔ£¬µ«ÊDZ¾ÈËû³É¹¦£¬
¹À¼ÆÊÇÒòΪʹÓÃÁ˾ø¶Ô·¾¶µÄÔÒò¡£
ÎÒдÁ˰ëÌ죬ÒòΪÊǸö²ËÄñ£¬ËùÒÔʵÔÚÊÇÄÑÊÜ£¬×ÜËãд³ö¸öÄÜÓõÄÁ½¸öÊý¾Ý¿âµÄ²éѯµ÷Óã¬ÆäʵÔÚÕâÀïÎÒÖ»ÓÃÁËÒ»¸öÊý¾Ý¿â£¬²»¹ýÁ½¸öÒ²ÊÇÍêÈ«¿ÉÒԵġ£
ÕâÀï¾ÍÉæ¼°µ½ÁíÒ»¸öÎÊÌ⣬Êý¾ÝÀàÐ͵ÄÎÊÌ⣬ÎÒÊÇ×ÔѧµÄ£¬¶ÔÓÚÕâ¸öʵÔÚÊÇûÓоÑ飬Ȩµ±Êǽ»ÁËѧ·ÑÁË……Ô´´úÂëÈçÏ£º
import java.sql.*;
public class Sms {
String str1="";
public String myforum(){
try{
String strurl="jdbc:odbc:myforum";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection(strurl);
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select id from tdcode WHERE sim='13461544271'");
while(rs.next()){
str1=rs.getString(1);
}
rs.close();
stmt.close();
}catch(Exception e){
}return str1;
}
public void myforum2(String str1){
try{
String strurl="jdbc:odbc:myforum";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection(strurl);
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select user from tdcode WHERE id="+str1+"");
while(rs.next()){
System.out.println(rs.getString(1));
}
rs.close();
stmt.close();
}catch(Exception e){
e.printStackTrace();
}
}
public void run(){
myforum();
myforum2(str1);
}
public static void main(Strin
Ïà¹ØÎĵµ£º
4¡¢ TimerºÍTimerTaskµÄʹÓÃ
TimerÊÇÒ»ÖÖ¶¨Ê±Æ÷¹¤¾ß£¬ÓÃÀ´ÔÚÒ»¸öºǫ́Ï̼߳ƻ®Ö´ÐÐÖ¸¶¨ÈÎÎñ£¬ÕâЩÈÎÎñ¿ÉÒÔ±»Ö´ÐÐÒ»´Î£¬Ò²¿ÉÒÔ±»¶¨ÆÚÖ´ÐС£Ã¿¸ö Timer ¶ÔÏó¶ÔÓ¦Ò»¸öºǫ́Ị̈߳¬Ë³ÐòµØÖ´ÐÐËùÓмÆÊ±Æ÷ÈÎÎñ¡£Èç¹ûÍê³Éij¸ö¼ÆÊ±Æ÷ÈÎÎñµÄʱ¼äÌ«³¤£¬ÄÇôËü»á“¶ÀÕ¼”¼ÆÊ±Æ÷µÄÈ ......
< type="text/javascript"> ÖÚËùÖÜÖª£¬ÔÚ³ÌÐò¿ª·¢ÖУ¬ÄÑÃâ»áÓöµ½ÐèҪƥÅä¡¢²éÕÒ¡¢Ìæ»»¡¢ÅжÏ×Ö·û´®µÄÇé¿ö·¢Éú£¬¶øÕâЩÇé¿öÓÐʱÓֱȽϸ´ÔÓ£¬Èç¹ûÓô¿±àÂ뷽ʽ½â¾ö£¬ÍùÍù»áÀ˷ѳÌÐòÔ±µÄʱ¼ä¼°¾«Á¦¡£Òò´Ë£¬Ñ§Ï°¼°Ê¹ÓÃÕýÔò±í´ïʽ£¬±ã³ÉÁ˽â¾öÕâһì¶ÜµÄÖ÷ÒªÊֶΡ£
´ó ¼Ò¶¼ÖªµÀ£¬ÕýÔò±í´ïʽÊÇÒ»ÖÖ¿ÉÒÔÓÃÓÚÄ£Ê ......