Retrieve CSV file through java.


try
        {
           Class.forName("com.mysql.jdbc.Driver");
           java.sql.Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3305/supplimentry","root","root");
           String sql="LOAD DATA LOCAL INFILE 'h://inventory.csv'\n" +
            "INTO TABLE inventory\n" +
            "FIELDS TERMINATED BY ','\n" +
            "OPTIONALLY ENCLOSED BY '\"'\n" +
            "LINES TERMINATED BY '\n'";
           java.sql.PreparedStatement pst1=con.prepareStatement(sql);
           pst1.executeUpdate();
           con.close();
           pst1.close();
           JOptionPane.showMessageDialog(null,"Restore Successfully!!!!");
        }
        catch(Exception e)
        {
            System.out.println(e);
        }

Popular posts from this blog

Jtable with database manually in netbeans.

package Demo; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import java.util.Vector; import javax.swing.JOptionPane; import javax.swing.table.DefaultTableModel; import net.proteanit.sql.DbUtils; /**  *  * @author NAVJYOTI  */ public class Jtablee extends javax.swing.JFrame {     /**      * Creates new form Jtablee      */     public Jtablee() {         initComponents();         set();     }     private int getsize() { int count=0; try {Class.forName("com.mysql.jdbc.Driver");             java.sql.Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3305/commity","root","root"); Statement stmt=con.createStatement(); String query="select * from group1"; ResultSet rs= ...
Read more