Pages

Thursday, October 1, 2015

Excel to Database

import java.io.FileInputStream; import java.io.IOException; import java.sql.DriverManager; import java.sql.SQLException; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.xssf.usermodel.XSSFSheet; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import com.mysql.jdbc.Connection; import com.mysql.jdbc.PreparedStatement; public class ExlToDbase { /** * @param args */ public static void main(String[] args) { try { Class.forName("com.mysql.jdbc.Driver"); Connection conn = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/mydbase","root","ALPHAS"); conn.setAutoCommit(false); PreparedStatement...