数据库与文件.

[yxqc]

怎么样从一个文件中读取一行插入数据库中.
文件中的一行里的每个字段以空格分开.
请问代码怎么实现???

[yxqc]

按照我的写法行不通啊.
能否帮我改改???


<%

Connection con = null;
Statement stmt = null;
ResultSet rs = null;

try
{
Class.forName("sun.jdbc.odb.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{

}

try
{

con=DriverManager.getConnection("jdbc:odbc:sun");
stmt=con.createStatement();

File file=new File("F:/JavaFile","text.txt");
FileReader filein=new FileReader(file);
BufferedReader bufferin=new BufferedReader(filein);

int k=1;
String[]option=new String[7];
String temp=null,
str=null;
String contion=null;
StringTokenizer tokenizer=null;

String logname=null,
realname=null;

while((str=bufferin.readLine())!=null)
{
temp=str;
out.print("<br>"+temp);
tokenizer = new StringTokenizer(temp);

}



while(tokenizer.hasMoreTokens())
{
option[k]=tokenizer.nextToken();
k++;
logname=option[1];
realname=option[2];
String condition=" INSERT INTO user VALUES ( "+"'"+logname+"','"+realname+"'"+")";
stmt.executeUpdate(condition);

}

rs=stmt.executeQuery(" SELECT * FROM USER ");
bufferin.close();
con.close();
out.println("<h2>"+"Ok!"+"</h2>");
}

catch(IOException e1)
{
out.println("<h2>"+"No!"+"</h2>");
}

%>

• 打赏
• 举报

回复 赞