csvjdbc的应用
代码
下载地址
http://www.sourceforge.net/projects/csvjdbc .
cvs格式
代码
java 代码
- <%@ page import="java.sql.*"%>
- <%@ page import="java.util.*"%>
- <%@ page import="org.relique.jdbc.csv.CsvDriver"%>
- CVS WUHAHA
- <%
- try{
- // 加载驱动
- Class.forName("org.relique.jdbc.csv.CsvDriver");
-
- // 定位文件夹位置
- Connection conn = DriverManager.getConnection("jdbc:relique:csv:E:\\222\\");
-
- Statement stmt = conn.createStatement();
-
- //注意 sample 就是cvs文件
- ResultSet results = stmt.executeQuery("SELECT ID,NAME FROM sample");
-
- while (results.next())
- {
- out.println("id= " + results.getString("ID") + " Name= " + results.getString("NAME")+"
"); - }
- results.close();
- stmt.close();
- conn.close();
- }catch(Exception e){
- System.out.println("- " + e);
- }
- %>
下载地址
http://www.sourceforge.net/projects/csvjdbc .
cvs格式