How to Retrieve a Text File From Table of Database in 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 retrieve text file from table of databasehow to retrieve text file from table of database in java jdbcjava database connectivityjava jdbcretrieve text file from table of database in java jdbc
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.