testtxt.java

来自「JDBC,指定数据库,打开数据库连接 数据库查询、修改、增加或删除等」· Java 代码 · 共 22 行

import java.sql.*;
public class TestTxt{

	public static void main(String[] args) {
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
			Connection con = DriverManager.getConnection("jdbc:odbc:testText", "", ""); 
			Statement stmt=con.createStatement();
			ResultSet rs=stmt.executeQuery("select * from test.txt");
			while(rs.next()){
				System.out.print("\t编号：" + rs.getString(1));
				System.out.print("\t姓名：" + rs.getString(2));
				System.out.print("\t性别：" + rs.getString(3));
				System.out.println();
			}
			con.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}
}