java操作sql

 

import java.io.BufferedReader;
import java.io.File;
import java.io.FileReader;
import java.io.IOException;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import org.jdom.JDOMException;

public class readTh {
    public static void main(String args[]) throws IOException, SQLException, JDOMException , JDOMException, IOException{
        String driver = "com.mysql.jdbc.Driver";
        String url = "jdbc:mysql://localhost:3306/book"; 
        String userName = "root";
        String passWd = "123456";
        Connection conn = null;
        try {
            try {
                Class.forName(driver);
            } catch (ClassNotFoundException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
            conn = DriverManager.getConnection(url, userName, passWd);
            
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        List<String> list = new ArrayList<String>();
        String sql1 = "select distinct qid from qrel13; ";
        Statement stm = conn.createStatement();
        ResultSet rset = stm.executeQuery(sql1);
        while(rset.next()){
            list.add(rset.getString(1));
        }
        for(String tmp:list){
            
            String sql3 = "select count(num) from bsorg13 where bookId in(select bookId from qrel13 where qid="+tmp+")and qid="+tmp+";";
            Statement stm3 = conn.createStatement();
            ResultSet rset3 = stm3.executeQuery(sql3);
            String count1 = null;
            while(rset3.next()){
                 count1 = rset3.getString(1);
            }
        
            String sql2 = "select count(num) from bsorg5000 where bookId in(select bookId from qrel13 where qid="+tmp+")and qid="+tmp+";";
            Statement stm2 = conn.createStatement();
            ResultSet rset2 = stm2.executeQuery(sql2);
            while(rset2.next()){
                String count2 = rset2.getString(1);
                System.out.println(tmp+"    "+count2+"    "+count1);
            }
        }    
        
        File file = new File("/home/13.topics");
        BufferedReader bf = new BufferedReader(new FileReader(file));
        String tmpLine = null;
        while((tmpLine = bf.readLine())!=null){
            String[] id = tmpLine.split(" ");
            String qid = id[0];
            String q0 = id[1];
            String bookId = id[2];
            String sim = id[3];
            String sql = "insert into qrel13(qid,q0,bookId,sim) values(?,?,?,?)";
            PreparedStatement ps = conn.prepareStatement(sql);
            ps.setString(1, qid);
            ps.setString(2, q0);
            ps.setString(3, bookId);
            ps.setString(4, sim);
            ps.addBatch();
            ps.execute();
            ps.close();
        }

    }
}