/*
i don't know why my dbf file cannoy load ntx this is my prgms
*/
import java.sql.*;
import java.util.Properties;
import com.hxtt.*;
public class test {
public static void main(String[] args) {
try {
Class.forName("com.hxtt.sql.dbf.DBFDriver").newInstance();
Properties p= new Properties();
//p.setProperty("DefaultExtension","NTX");
p.setProperty("Default Index Suffix","NTX");
p.setProperty("DefaultNTXExtension","AFAIRER.NTX");// the file is AFAIRER.NTX
p.setProperty("loadIndices","true");
//p.setProperty("Incremental Index","NTX");
//p.setProperty("COMPACTEDINDEX","false");
Connection conn = DriverManager.getConnection("jdbc:dbf:///s:/Tempo/Chen/AG.mloc/DATA/GLO",p);
String sql ="Select * from AFAIRE";
PreparedStatement stmt=conn.prepareStatement(sql);
ResultSet rs = stmt.executeQuery(sql);
ResultSetMetaData resultSetMetaData = rs.getMetaData();
int iNumCols = resultSetMetaData.getColumnCount();
Object colval;
for (int i = 1; i <= iNumCols; i++) {
System.out.println(resultSetMetaData.getColumnLabel(i)
+ " " +
resultSetMetaData.getColumnTypeName(i));
}
while (rs.next()) {
for (int i = 1; i <= iNumCols; i++) {
colval = rs.getObject(i);
System.out.print(colval + " ");
}
System.out.println();
}
rs.close();
stmt.close();
conn.close();
}catch (Exception e) {
System.out.println(e.getMessage());
e.printStackTrace();
}
}
}
|
>p.setProperty("DefaultNTXExtension","AFAIRER.NTX")
p.setProperty("DefaultNTXExtension","NTX");//You can skip that property since NTX is default value.
Select * from AFAIRE;//But your NTX file is AFAIRER.NTX?
If so, you should use a AFAIRE.CGP file which contains one text line: AFAIRER.NTX
|