今天给各位分享java文件导入数据库的知识,其中也会对java文件导入数据库怎么导入进行解释,如果能碰巧解决你现在面临的问题,别忘了关注本站,现在开始吧!
本文目录一览:
- 1、用java如何将txt文件导入mysql?
- 2、用java代码把txt文档中资料导入到数据库
- 3、Java获取网络文件并插入数据库
- 4、如何用java导入Excel数据到数据库
- 5、怎样用Java实现从文本文档中读取数据并存入数据库
用java如何将txt文件导入mysql?
Java中将txt文件导入到mysql基本困启码的思路,操作流获取到文件具体信息,然后将信息拼接成mysql插入到数据库中。
1.先读取txt文件的内容,文件内容可以按照一定的规律进行排列旁告,这样程序读取就方便。
2.java.io.IOExceptionimportjava.io.RandomAccessFileimportjava.io.UnsupportedEncodingException。
3.import java.text.SimpleDateFormat,汪哪import java.util.Date, import java.util.regex.Matcher,
import java.util.regex.Pattern
4.import com.config.Constants; import com.utils.UUIDUtil;
5.public static final String TXT_FILE_PATH =“D://testUser.txt。
public static final String openFileStyle =“r”。
用java代码把txt文档中资料导入到数据库
BufferedReader input;
try {
String s = new String();
input = new BufferedReader(new FileReader("f:\\123.txt"));
while ((s = input.readLine()) != null) { // 判断是否读到了最后一行
String info[] = s.split("培激 "败唤);
System.out.println( info[0] + " " + info[1] + " " + info[2] );
}
input.close();
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
把info[0] + " " + info[1] + " " + info[2] 这配枯袜三个值放在insert语句里就行了 经过测试
Java获取网络文件并插入数据库
抓取各大网站的数据插入数据库 这样就不用为没有数据而烦恼了
获取百度的歌曲名 歌手和链接!!
package webTools;
import java io BufferedReader;
import java io IOException;
import java io InputStreamReader;
import java io UnsupportedEncodingException;
import MalformedURLException;
import URL;
import java util ArrayList;
虚旁 import java util HashMap;
李含import java util List;
import java util regex Matcher;
import java util regex Pattern;
哪誉笑import dbTools DBTools;
public class IOTOWeb {
public String getHtmlContent(String URL) {
URL url = null;
String rowContent = ;
StringBuffer Content = new StringBuffer();
try {
url = new URL(URL);
BufferedReader in = new BufferedReader(new InputStreamReader(url
openStream() gb ));
while ((rowContent = in readLine()) != null) {
Content append(rowContent);
}
in close();
} catch (MalformedURLException e) {
// TODO Auto generated catch block
e printStackTrace();
} catch (UnsupportedEncodingException e) {
// TODO Auto generated catch block
e printStackTrace();
} catch (IOException e) {
// TODO Auto generated catch block
e printStackTrace();
}
return Content toString();
}
public List getLink(String Content) {
ArrayList listLink = new ArrayList();
String regex = td[^]*[\\(]*a[^]*href=(\ ([^\ ]*)\ |\ ([^\ ]*)\ |([^\\s]*))[^]*( *?)[\\)]*[\\s]*/td ;
Pattern pattern = pile(regex Pattern DOTALL);
Matcher matcher = pattern matcher(Content);
while (matcher find()) {
listLink add(matcher group());
}
return listLink;
}
public ListString getHref(String Content) {
String regex;
List listtHref = new ArrayList();
regex = href=(\ ([^\ ]*)\ |\ ([^\ ]*)\ |([^\\s]*))\ ;
Pattern pa = pile(regex Pattern DOTALL);
Matcher ma = pa matcher(Content);
while (ma find()) {
listtHref add(ma group() replaceFirst( href=\ ) replace( \
));
}
return listtHref;
}
public ListString getPerson(String Content) {
String regex;
List list = new ArrayList();
regex = ]*href=(\"([^\"]*)\"|\ ([^\ ]*)\ |([^\\s]*))[^]*( *?)\\ \\(a[^]*href=(\ ([^\ ]*)\ |\ ([^\ ]*)\ |([^\\s]*))[^]*( *?)\\) ;
Pattern pa = pile(regex Pattern DOTALL);
Matcher ma = pa matcher(Content);
while (ma find()) {
list add(ma group() replaceFirst( href=\ ) replace( \ ));
}
return list;
}
public ListString getSongName(String Content) {
String regex;
List listPerson = new ArrayList();
regex = a[^]*href=(\ ([^\ ]*)\ |\ ([^\ ]*)\ |([^\\s]*))[^]*( *?)/a\\s ;
Pattern pa = pile(regex Pattern DOTALL);
Matcher ma = pa matcher(Content);
while (ma find()) {
listPerson add(ma group());
}
return listPerson;
}
public String getMainContent(String Content) {
String regex = table width=\ %\ align=\ center\ cellpadding=\ \ cellspacing=\ \ class=\ list\ ( *?)/table ;
StringBuffer mainContent = new StringBuffer();
Pattern pattern = pile(regex Pattern DOTALL);
Matcher matcher = pattern matcher(Content);
while (matcher find()) {
mainContent append(matcher group());
}
return mainContent toString();
}
public String outTag(final String s) {
return s replaceAll( *? );
}
DBTools dbTools = new DBTools();
public void getFromBaiduMap (String URL) throws Throwable {
HashMap ContentMap = new HashMap();
String Content = getHtmlContent(URL);
String mainContent = getMainContent(Content);
List listLink = getLink(mainContent);
for (int j = ; j listLink size(); j++) {
String tdTag = listLink get(j) toString();
List songNameList = getSongName(tdTag);
String songName = outTag(songNameList get( ) toString());
List personList = getPerson(tdTag);
String songPerson = ;
if (personList size() != ) {
for (int n = ; n personList size(); n++) {
// System out println(personList get(n) toString());
songPerson = outTag(personList get(n) toString());
}
} else {
songPerson = 无 ;
}
// System out print(songNameList get( ) toString());
List hrefList = getHref(songNameList get( ) toString());
String songHref = hrefList get( ) toString();
System out println();
String sql = insert into song(songName songPerson songHref) values(? ? ?) ;
ArrayList list_values = new ArrayList();
list_values add(songName);
list_values add(songPerson);
list_values add(songHref);
dbTools update(sql list_values);
}
}
}
DBTools数据库链接类
package dbTools;
import java util ArrayList;
import java sql *;
public class DBTools {
private PreparedStatement preparedStatement;
private ResultSet resultSet;
private Connection connection;
public DBTools() {
try {
Class forName( mysql jdbc Driver );
} catch (ClassNotFoundException e) {
// TODO Auto generated catch block
e printStackTrace();
}
try {
connection = DriverManager getConnection(
jdbc:mysql://localhost: /TestURL root zhuyi );
} catch (SQLException e) {
// TODO Auto generated catch block
e printStackTrace();
}
}
public ArrayList query(String sql ArrayList list_values) throws Throwable {
ArrayList listRows = new ArrayList();
preparedStatement = connection prepareStatement(sql);
for (int i = ; i list_values size(); i++) {
preparedStatement setObject(i + list_values get(i));
}
resultSet = preparedStatement executeQuery();
while (resultSet next()) {
String[] rowinfo = new String[resultSet getMetaData()
getColumnCount()];
for (int i = ; i rowinfo length; i++) {
rowinfo[i] = resultSet getString(i + );
}
listRows add(rowinfo);
}
return listRows;
}
public void update(String sql ArrayList list_values) throws Throwable {
preparedStatement = connection prepareStatement(sql);
for (int i = ; i list_values size(); i++) {
preparedStatement setObject(i + list_values get(i));
}
preparedStatement executeUpdate();
preparedStatement close();
}
}
Servlet调用
代码
package controller;
import java io IOException;
import java io PrintWriter;
import java util List;
import javax servlet ServletException;
import javax servlet HttpServlet;
import javax servlet HttpServletRequest;
import javax servlet HttpServletResponse;
import webTools IOTOWeb;
public class TestURL extends HttpServlet {
/**
* Constructor of the object
*/
public TestURL() {
super();
}
/**
* Destruction of the servlet br
*/
public void destroy() {
super destroy(); // Just puts destroy string in log
// Put your code here
}
/**
* The doGet method of the servlet br
*
* This method is called when a form has its tag value method equals to get
*
* @param request
* the request send by the client to the server
* @param response
* the response send by the server to the client
* @throws ServletException
* if an error occurred
* @throws IOException
* if an error occurred
*/
public void doGet(HttpServletRequest request HttpServletResponse response)
throws ServletException IOException {
try {
IOTOWeb iotoWeb = new IOTOWeb();
iotoWeb getFromBaiduMap ( ?id= ?top );
} catch (Throwable e) {
// TODO Auto generated catch block
e printStackTrace();
}
}
/**
* The doPost method of the servlet br
*
* This method is called when a form has its tag value method equals to
* post
*
* @param request
* the request send by the client to the server
* @param response
* the response send by the server to the client
* @throws ServletException
* if an error occurred
* @throws IOException
* if an error occurred
*/
public void doPost(HttpServletRequest request HttpServletResponse response)
throws ServletException IOException {
response setContentType( text/ );
PrintWriter out = response getWriter();
out
println( !DOCTYPE HTML PUBLIC \ //W C//DTD HTML Transitional//EN\ );
out println( HTML );
out println( HEADTITLEA Servlet/TITLE/HEAD );
out println( BODY );
out print( This is );
out print(this getClass());
out println( using the POST method );
out println( /BODY );
out println( /HTML );
out flush();
out close();
}
/**
* Initialization of the servlet br
*
* @throws ServletException
* if an error occurs
*/
public void init() throws ServletException {
// Put your code here
}
}
获取金书网的图书名
代码
package webTools;
import java io BufferedReader;
import java io InputStreamReader;
import URL;
import java util ArrayList;
import java util List;
import java util regex Matcher;
import java util regex Pattern;
import dbTools DBTools;
public class GetBook {
public String getHtmlContent(String URL) throws Throwable {
URL url = null;
String rowContent = ;
StringBuffer Content = new StringBuffer();
url = new URL(URL);
BufferedReader in = new BufferedReader(new InputStreamReader(url
openStream() gb ));
while ((rowContent = in readLine()) != null) {
Content append(rowContent);
}
in close();
return Content toString();
}
public String getBookName(String Content) {
String bookName = ;
String regex = span class=\ style \ [^]*/span ;
Pattern pattern = pile(regex Pattern DOTALL);
Matcher matcher = pattern matcher(Content);
if (matcher find()) {
bookName = matcher group();
}
return bookName;
}
public String outTag(final String s) {
return s replaceAll( *? );
}
DBTools dbtools = new DBTools();
public void getFromJINSHU(String URL) throws Throwable {
String Content = getHtmlContent(URL);
String bookName = outTag(getBookName(Content));
if (bookName != null ! equals(bookName)) {
System out println(bookName);
String sql = insert into bookinfo(bookName) values(?) ;
ArrayList list_values = new ArrayList();
list_values add(bookName);
dbtools update(sql list_values);
}
}
}
调用Servlet
代码
package controller;
import java io IOException;
import java io PrintWriter;
import javax servlet ServletException;
import javax servlet HttpServlet;
import javax servlet HttpServletRequest;
import javax servlet HttpServletResponse;
import webTools GetBook;
public class TestBook extends HttpServlet {
/**
* Constructor of the object
*/
public TestBook() {
super();
}
/**
* Destruction of the servlet br
*/
public void destroy() {
super destroy(); // Just puts destroy string in log
// Put your code here
}
/**
* The doGet method of the servlet br
*
* This method is called when a form has its tag value method equals to get
*
* @param request
* the request send by the client to the server
* @param response
* the response send by the server to the client
* @throws ServletException
* if an error occurred
* @throws IOException
* if an error occurred
*/
int i = ;
public void doGet(HttpServletRequest request HttpServletResponse response)
throws ServletException IOException {
GetBook bookinfo = new GetBook();
for (; i ; i++) {
String bookURL = /booksinfo/ / + i
+ l ;
try {
bookinfo getFromJINSHU(bookURL);
} catch (Throwable e) {
i++;
doPost(request response);
}
}
}
/**
* The doPost method of the servlet br
*
* This method is called when a form has its tag value method equals to
* post
*
* @param request
* the request send by the client to the server
* @param response
* the response send by the server to the client
* @throws ServletException
* if an error occurred
* @throws IOException
* if an error occurred
*/
public void doPost(HttpServletRequest request HttpServletResponse response)
throws ServletException IOException {
GetBook bookinfo = new GetBook();
for (; i ; i++) {
String bookURL = /booksinfo/ / + i
+ l ;
try {
bookinfo getFromJINSHU(bookURL);
} catch (Throwable e) {
i++;
doGet(request response);
}
}
}
/**
* Initialization of the servlet br
*
* @throws ServletException
* if an error occurs
*/
public void init() throws ServletException {
// Put your code here
}
}
lishixinzhi/Article/program/Java/hx/201311/25707
如何用java导入Excel数据到数据库
public static void main(String args[]) throws BiffException, IOException, WriteException{
//1 从Excel文件读取数据表
//缓信汪Java Excel API既可以从本地文件系统的一个文件(.xls),也可以从输入流中读取Excel数据表。
//读取Excel数据表的第一步是创建Workbook(术语:工作薄),下面的代码片段举例说明了应该如何操作:
//(完整代码见ExcelReading.java)
try
{
//构建Workbook对象, 只读Workbook对象
//直接从本地文件创建Workbook
//从输入流创建Workbook
InputStream is = new FileInputStream("D:/user.xls");
jxl.Workbook rwb = Workbook.getWorkbook(is);
//一旦创建了Workbook,我们就可以通过它来访问Excel Sheet(术语:工作表)。参考下面的代码片段:
//获取第一张Sheet表
Sheet rs = (Sheet) rwb.getSheet(0);
//我们既可能通过Sheet的名称来访问它,也可以通过下标来访问它。如果通扰仔过下标来访问的话,
//要注意的一点是下标从0开始,就像数组一样。
//一旦得到了Sheet,我们就可以通过它来访问Excel Cell(术语:单元格)。参考下面的代码片段:
//获取第一行,第一列的值
Cell c00 = ((jxl.Sheet) rs).getCell(0, 0);
String strc00 = c00.getContents();
//获取第一行,第二列的值
Cell c10 = ((jxl.Sheet) rs).getCell(1, 0);
String strc10 = c10.getContents();
//获取第二行,第二列的值
Cell c11 = ((jxl.Sheet) rs).getCell(1, 1);
String strc11 = c11.getContents();
System.out.println("Cell(0, 0)" + " value : " + strc00 + "; type : " + c00.getType());
System.out.println("Cell(1, 0)" + " value : " + strc10 + "; type : " + c10.getType());
System.out.println("Cell(1, 1)" + " value : " + strc11 + "; type : " + c11.getType());
//如果仅仅是坦辩取得Cell的值,我们可以方便地通过getContents()方法,
//它可以将任何类型的Cell值都作为一个字符串返回。示例代码中Cell(0, 0)是文本型,
//Cell(1, 0)是数字型,Cell(1,1)是日期型,通过getContents(),三种类型的返回值都是字符型。
//如果有需要知道Cell内容的确切类型,API也提供了一系列的方法。参考下面的代码片段:
String strcc00 = null;
double strcc10 = 0.00;
Date strcc11 = null;
Cell cc00 = ((jxl.Sheet) rs).getCell(0, 0);
Cell cc10 = ((jxl.Sheet) rs).getCell(1, 0);
Cell cc11 = ((jxl.Sheet) rs).getCell(1, 1);
if(c00.getType() == CellType.LABEL)
{
LabelCell labelc00 = (LabelCell)cc00;
strcc00 = labelc00.getString();
}
if(c10.getType() == CellType.NUMBER)
{
NumberCell numc10 = (NumberCell)cc10;
strcc10 = numc10.getValue();
}
if(c11.getType() == CellType.DATE)
{
DateCell datec11 = (DateCell)cc11;
strcc11 = datec11.getDate();
}
System.out.println("Cell(0, 0)" + " value : " + strcc00 + "; type : " + cc00.getType());
System.out.println("Cell(1, 0)" + " value : " + strcc10 + "; type : " + cc10.getType());
System.out.println("Cell(1, 1)" + " value : " + strcc11 + "; type : " + cc11.getType());
//在得到Cell对象后,通过getType()方法可以获得该单元格的类型,然后与API提供的基本类型相匹配,
//强制转换成相应的类型,最后调用相应的取值方法getXXX(),就可以得到确定类型的值。
//API提供了以下基本类型,与Excel的数据格式相对应,如下图所示:
//每种类型的具体意义,请参见Java Excel API Document。
//当你完成对Excel电子表格数据的处理后,一定要使用close()方法来关闭先前创建的对象,
//以释放读取数据表的过程中所占用的内存空间,在读取大量数据时显得尤为重要。参考如下代码片段:
//操作完成时,关闭对象,释放占用的内存空间
rwb.close();
}
catch (Exception e)
{
e.printStackTrace();
}
//Java Excel API提供了许多访问Excel数据表的方法,在这里我只简要地介绍几个常用的方法,
//其它的方法请参考附录中的Java Excel API Document。
//Workbook类提供的方法
//1. int getNumberOfSheets();
//获得工作薄(Workbook)中工作表(Sheet)的个数,示例:
jxl.Workbook rwb = jxl.Workbook.getWorkbook(new File("D:/user.xls"));
int sheets = rwb.getNumberOfSheets();
//2. Sheet[] getSheets();
//返回工作薄(Workbook)中工作表(Sheet)对象数组,示例:
jxl.Workbook rwb2 = jxl.Workbook.getWorkbook(new File("D:/user.xls"));
Sheet[] sheets2 = (Sheet[]) rwb2.getSheets();
//3. String getVersion();
//返回正在使用的API的版本号,好像是没什么太大的作用。
jxl.Workbook rwb3 = jxl.Workbook.getWorkbook(new File("D:/user.xls"));
String apiVersion = rwb3.getVersion();
//Sheet接口提供的方法
//1) String getName();
//获取Sheet的名称,示例:
jxl.Workbook rwb4 = jxl.Workbook.getWorkbook(new File("D:/user.xls"));
jxl.Sheet rs = rwb4.getSheet(0);
String sheetName = rs.getName();
//2) int getColumns()
//获取Sheet表中所包含的总列数,示例:
jxl.Workbook rwb5 = jxl.Workbook.getWorkbook(new File("D:/user.xls"));
jxl.Sheet rs2 = rwb5.getSheet(0);
int rsColumns = rs2.getColumns();
//3) Cell[] getColumn(int column)
//获取某一列的所有单元格,返回的是单元格对象数组,示例:
jxl.Workbook rwb6 = jxl.Workbook.getWorkbook(new File("D:/user.xls"));
jxl.Sheet rs3 = rwb6.getSheet(0);
Cell[] cell = rs3.getColumn(0);
//4) int getRows()
//获取Sheet表中所包含的总行数,示例:
jxl.Workbook rwb7 = jxl.Workbook.getWorkbook(new File("D:/user.xls"));
jxl.Sheet rs4 = rwb7.getSheet(0);
int rsRows = rs4.getRows();
//5) Cell[] getRow(int row)
//获取某一行的所有单元格,返回的是单元格对象数组,示例子:
jxl.Workbook rwb8 = jxl.Workbook.getWorkbook(new File("D:/user.xls"));
jxl.Sheet rs5 = rwb8.getSheet(0);
Cell[] cell5 = rs5.getRow(0);
//6) Cell getCell(int column, int row)
//获取指定单元格的对象引用,需要注意的是它的两个参数,第一个是列数,第二个是行数,
//这与通常的行、列组合有些不同。
jxl.Workbook rwb9 = jxl.Workbook.getWorkbook(new File("D:/user.xls"));
jxl.Sheet rs6 = rwb9.getSheet(0);
Cell cell6 = rs6.getCell(0, 0);
怎样用Java实现从文本文档中读取数据并存入数据库
不知道你要什么样的文本,文本中的内容是否是有格式的:
这里提供下思路,供参考:
1.文本文件,基本上式字符格式的了,可以用Reader io流
2.如果是格式化的文本,可以按数据的长度读取, readInt readByte...
3.保存到数据库 当然用JDBC了,如果你读取出来封装成POJO了,也可以选择 OM框架
import java.io.BufferedReader;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStreamReader;
/**
* 文件读取和写入数据库
* @author 樊云升
告皮*
*/
public class FilesReader {
public FilesReader(){
}
/**
* 读取文件内容
* @param FILE
* @return
*/
public String re_content(String FILE){
String content="";
try{ 察改
BufferedReader bufRead=new BufferedReader(new InputStreamReader(new FileInputStream(FILE)));
String str;
while((str=bufRead.readLine())!=null){
content+=str+"\r\n";
}
}catch(IOException ioe){
ioe.printStackTrace();
}
return content;
}
/**
* 将特定字符写入数据库中(原来我写的是重写文件,你这里这里将content写入数据库就OK)
* @param path
* @return
*/
public boolean writeFile(String content){
try{
//数据库写入代码
}catch(Exception e){
out.close();
return false;
}
return true;
}
public static void main(String[] args) {
String content=new FilesReader().re_content("D:\\AJAX.htm"败友判);
new FilesReader().writeFile(content);
}
}