我的第五个java程序 每过10秒读取一次天气 并把天气更新到mysql数据库里

 

 

import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.net.HttpURLConnection;
import java.net.URL;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
import java.util.Arrays;
import java.sql.*;
import java.util.Timer;
import java.io.IOException;


public class Weather {
 String urlString;
 String array;
 String tianqi;
 StringBuffer sb=new StringBuffer("");
  
 public static void main(String[] args) throws Exception {
  
  
  Timer timer = new Timer();
        timer.schedule(new MyTask(), 1000, 10000);
        while (true) {
            try {
                int ch = System.in.read();
                if (ch - 'c' == 0) {
                    timer.cancel();
                }
            } catch (IOException e) {
               e.printStackTrace();
            }
        }
 }
 
 
 
 
 static class MyTask extends java.util.TimerTask {
        @Override
        public void run() {
            // TODO Auto-generated method stub
            Weather client = new Weather("http://www.weather.com.cn/weather/101181201.shtml");
			try { 
			client.run();
			}catch(Exception e) {


            e.printStackTrace();


           } 
        }
    }
 
 
 
 
 
 
 
 public Weather(String urlString) {
  this.urlString = urlString;
 }
 
 
 
 public void run() throws Exception {
 
  URL url = new URL(urlString);
  
  HttpURLConnection urlConnection = (HttpURLConnection) url.openConnection();
  
  BufferedReader reader = new BufferedReader(new InputStreamReader(urlConnection
    .getInputStream(),"utf8"));
  String line;

  while ((line = reader.readLine()) != null){
  Pattern p = Pattern.compile("<p class=\"wea\">(.+?)</p>");
    Matcher m = p.matcher(line);
    while(m.find()) { 
        array = m.group(1);
        sb.append(array+","); 
    }
  }
  
    String arr = sb.toString();
    String[] s = arr.split("\\,");
    tianqi=s[s.length - 7];
	
	
	
	
	
	
	  String driver = "com.mysql.jdbc.Driver";
      String urls = "jdbc:mysql://127.0.0.1:3306/scutcs";
      String user = "root"; 
	  String password = "root";
	  
	  
           try { 
            
            Class.forName(driver);

           
            Connection conn = DriverManager.getConnection(urls, user, password);

            if(!conn.isClosed()) 
             System.out.println("Succeeded connecting to the Database!");

            
            Statement statement = conn.createStatement();

           
            String sql = "UPDATE  `scutcs`.`student` SET  `SNAME` =  '"+tianqi+"' WHERE  `student`.`SNO` =  '2';";
			System.out.println(sql);

            
            //ResultSet rs = statement.executeQuery(sql);   
			statement.executeUpdate(sql);   
		

            //rs.close();
            conn.close();

           } catch(ClassNotFoundException e) {


            System.out.println("Sorry,can`t find the Driver!"); 
            e.printStackTrace();


           } catch(SQLException e) {


            e.printStackTrace();


           } catch(Exception e) {


            e.printStackTrace();


           } 
		   
		   
    
 }
 

}