-
大小: 3KB文件類型: .java金幣: 1下載: 0 次發(fā)布日期: 2021-01-07
- 語言: Java
- 標(biāo)簽: java??txt??數(shù)據(jù)庫??
資源簡介
java 讀取txt文本文件中的數(shù)據(jù)并保存到數(shù)據(jù)庫中源代碼,假設(shè)txt已有格式,并以","分隔。其中的sql包需要自己去微軟官網(wǎng)下載。
代碼片段和文件信息
/*
?*?To?change?this?template?choose?Tools?|?Templates
?*?and?open?the?template?in?the?editor.
?*/
package?homework4database;
import?java.io.*;
import?java.sql.*;
/**
?*
?*?@author?Administrator
?*/
public?class?Main?{
????/**
?????*?@param?args?the?command?line?arguments
?????*/
????public?static?void?main(String[]?args)?{
????????TxtUpdate.Update(“students.txt“);
????}
}
class?TxtUpdate{
????public?static?void?Update(String?fileName){
????????try?{
????????????//創(chuàng)建連接
????????????String?connectionUrl?=?“jdbc:sqlserver://WWW-40CF488624B\\LPF:1433;“?+?“databaseName=Students;username=sa;password=123“;//連接字符串
????????????Class.forName(“com.microsoft.sqlserver.jdbc.SQLServerDriver“);//驅(qū)動程序包
????????????Connection?con?=?DriverManager.getConnection(connectionUrl);
評論
共有 條評論