How to Insert Text File in Database using Java JDBC
by TechVidvan Team
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);
}
}
}
Tags: advanced javaadvanced java practicaladvanced java programhow to insert text file in database using java jdbcinsert text file in databaseinserting text file in database using java jdbcjava database connectvity
TechVidvan Team
TechVidvan Team provides high-quality content & courses on AI, ML, Data Science, Data Engineering, Data Analytics, programming, Python, DSA, Android, Flutter, full stack web dev, MERN, and many latest technology.