import Java.io.FileInputStream; import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; import org.apache.poi.hssf . usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi . poifs.filesystem.POIFSFileSystem; public class POITest {private static Connection conn = null; private static Statement stmt = null; private static boolean connectDB2 {String url = ""; String username = "username"; String password = "password"; / / load the driver to connect to the database try {/ / add the class library driver package db2jcc.jar and db2jcc_license_cu.jar Class.forName; url = "JDBC: db2: / / 192.168.0.1:50000 / dbname"; / / add library driver package db2java.jar / / Class.forName.newInstance; / / url = "jdbc: db2: njtcdata"; conn = DriverManager.getConnection; stmt = conn.createStatement;} / / catch exception catch {load the driver System.err.println; cnfex.printStackTrace; return false;} / / capture connect to database exception catch {System.err.println; sqlex.printStackTrace; / / System.exit; / / terminate program return false;} return true;} private static boolean readExcelToDB2 {POIFSFileSystem fs = null; HSSFWorkbook wb = null; try {fs = new POIFSFileSystem); wb = new HSSFWorkbook;} catch {e.printStackTrace; return false;} HSSFSheet sheet = wb.getSheetAt; HSSFRow row = null ; HSSFCell cell = null; String name = ""; int id = 0; int rowNum, cellNum; int i; rowNum = sheet.getLastRowNum; for {row = sheet.getRow; / / cellNum = row.getLastCellNum; cell = row . getCell 0); name = cell.getStringCellValue; cell = row.getCell 1); id = cell.getNumericCellValue; String sql = "insert into TEST values"; try {stmt.executeUpdate;} catch {e1.printStackTrace; return false ;}} return true;} public static void main {if == true) {if == true) System.out.println; elseSystem.out.println;} else {System.out.println;}}}
Palmisano, IBM chairman and CEO will be the performance of services called "outstanding", but acknowledged that IBM must reorganize the hardware business. Sales software business for 47 billion U.S. dollars, an increase of 7%. Taking into account exchange rates, this growth rate will decline to 3%. In the first three quarters, IBMs profit was 64.7 billion U.S. dollars, earnings per share of $ 4.42 on sales of 69.9 billion U.S. dollars. Microsoft is to withdraw its request for a court in Korea, the Korea Fair Trade Commission antitrust ruling appeal. Microsoft said in a statement, Microsoft tried to withdraw his appeal. With the KFTC and our cooperation in the Seoul High Court, but the case is accepted by the court, we do not comment on the case. KFTC said it had received notice of the High Court: Microsoft decided to withdraw its appeal. KFTC, a representative said, KFTC has not decided the next step taken.