Program 1
package view;
import java.io.*;
import java.sql.*;
public class TestFileMain
{
public static void main(String[] args)
{
try
{
File F=new File("F://myfile/myjdbc.txt");
FileReader fr=new FileReader(F);
Class.forName("com.mysql.cj.jdbc.Driver");
System.out.println("Driver load......");
Connection con=null;
PreparedStatement ps=null;
con=DriverManager.getConnection("jdbc:mysql:/dataflair", "root", "root@data");
System.out.println("Database connect.....");
String sql="insert into filedata values(?,?)";
ps=con.prepareStatement(sql);
ps.setString(1, "jdbcfile");
ps.setCharacterStream(2, fr);
if(ps.executeUpdate()>0)
System.out.println("File Save in table.......");
}
catch(Exception e)
{
System.out.println(e);
}
}
}
