JAVA连接数据库，并写入到txt文件
package Hello;
import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileOutputStream;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.RandomAccessFile;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class Hello
{
public static void main(String[] args)
{
// String connectionUrl =
// "jdbc:sqlserver://localhost:1433;databaseName=AdventureWorks;integratedSecurity=true;";
String url = "jdbc:sqlserver://127.0.0.1:1433;databaseName=ZBFERPNew;user=sa;password=123456";// sa身份连接
// String url2 =
// "jdbc:sqlserver://127.0.0.1:1368;databaseName=mydbdemo;integratedSecurity=true;";//windows集成模式连接
// Declare the JDBC objects.
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try
{
System.out.println("begin.");
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
con = DriverManager.getConnection(url);
System.out.println("end.");
// Create and execute an SQL statement that returns some data.
String SQL = "SELECT top 1000 * FROM blackBox";
stmt = con.createStatement();
rs = stmt.executeQuery(SQL);
// Iterate through the data in the result set and display it.
while (rs.next())
{
// System.out.println(rs.getString(0));
System.out.print(rs.getString(1));
System.out.print("|");
System.out.print(rs.getString(2));
System.out.print("|");
System.out.print(rs.getString(3));
System.out.print("|");
System.out.print(rs.getString(4));
System.out.print("|");
System.out.print(rs.getString(5));
System.out.print("|");
System.out.println(rs.getString(6));
String dataStr = rs.getString(1) + "|" + rs.getString(2) + "|" + rs.getString(2) + "|" + rs.getString(3)
+ "|" + rs.getString(4) + "|" + rs.getString(5) + "|" + rs.getString(6) + "\n";
contentToTxt("C:\\Users\\Administrator\\Desktop\\as.txt", dataStr);
}
} catch (Exception e)
{
e.printStackTrace();
} finally
{
if (rs != null)
try
{
rs.close();
} catch (Exception e)
{
}
if (stmt != null)
try
{
stmt.close();
} catch (Exception e)
{
}
if (con != null)
try
{
con.close();
} catch (Exception e)
{
}
}
}
/**
* 创建文件
*
* @param fileName
* @return
*/
public static boolean createFile(File fileName) throws Exception
{
boolean flag = false;
try
{
if (!fileName.exists())
{
fileName.createNewFile();
flag = true;
}
} catch (Exception e)
{
e.printStackTrace();
}
return true;
}
/**
* 读TXT文件内容
*
* @param fileName
* @return
*/
public static String readTxtFile(File fileName) throws Exception
{
String result = null;
FileReader fileReader = null;
BufferedReader bufferedReader = null;
try
{
fileReader = new FileReader(fileName);
bufferedReader = new BufferedReader(fileReader);
try
{
String read = null;
while ((read = bufferedReader.readLine()) != null)
{
result = result + read + "\r\n";
}
} catch (Exception e)
{
e.printStackTrace();
}
} catch (Exception e)
{
e.printStackTrace();
} finally
{
if (bufferedReader != null)
{
bufferedReader.close();
}
if (fileReader != null)
{
fileReader.close();
}
}
System.out.println("读取出来的文件内容是：" + "\r\n" + result);
return result;
}
public static boolean writeTxtFile(String content, File fileName) throws Exception
{
RandomAccessFile mm = null;
boolean flag = false;
FileOutputStream o = null;
try
{
o = new FileOutputStream(fileName);
o.write(content.getBytes("GBK"));
o.close();
flag = true;
} catch (Exception e)
{
// TODO: handle exception
e.printStackTrace();
} finally
{
if (mm != null)
{
mm.close();
}
}
return flag;
}
public static void contentToTxt(String filePath, String content)
{
String str = new String(); // 原有txt内容
String s1 = new String();// 内容更新
try
{
File f = new File(filePath);
if (f.exists())
{
System.out.print("文件存在");
} else
{
System.out.print("文件不存在");
f.createNewFile();// 不存在则创建
}
BufferedReader input = new BufferedReader(new FileReader(f));
while ((str = input.readLine()) != null)
{
s1 += str + "\n";
}
System.out.println(s1);
input.close();
s1 += content;
BufferedWriter output = new BufferedWriter(new FileWriter(f));
output.write(s1);
output.close();
} catch (Exception e)
{
e.printStackTrace();
}
}
}
