慧慧-
这里有一个参考，你可以看一下
*
导入数据类型列值保存类型对应：
* (1)
VARCHAR,INTEGER,FLOAT
-->java.lang.String
* (2)
DATE
-->java.sql.Date
* (3)
TIME
-->java.sql.Time
* (4)
TIMESTAMP
-->java.sql.Timestamp
*/
package xls.core;
public class Cell {
public final
static Cell NULL_CELL = new Cell(null, -1, -1, null);
private
Object value;
private
Schema schema;
private int
rowNum;
private int
colNum;
public
Cell(Schema schema, int rowNum, int colNum, Object value) {
this.schema
= schema;
this.value =
value;
this.rowNum
= rowNum;
this.colNum
= colNum;
}
public
boolean validate() {
Column col =
schema.getColumn(colNum);
Type colType
= col.getType();
if
(Type.VARCHAR.equals(colType)) {
if (value !=
null && value.toString().length()
> col.getLength()) {
return
false;
}
}
return
true;
}
public
Schema getSchema() {
return
schema;
}
public int
getRowIndex() {
return
rowNum;
}
public int
getColumnIndex() {
return
colNum;
}
public
Object getValue() {
return
value;
}
public
boolean isNull() {
return
schema == null;
}
public
String toString() {
if
(isNull()) {
return
"[Cell] <null>";
}
String
string = "[Cell] row=" + rowNum + ",column=" + colNum
+ ",value="
+ value;
return
string;
}
}
package xls.core;
public class Column {
public final
static Column NULL_COLUMN = new Column(-1, null);
private int
columnIndex;
private Type
type;
private Type
inType;
private Type
outType;
private
String name;
//
需要时候用于列长度检查
private int
length;
//
某些列将不从EXCEL/JDBC 中获取的数值
private
Object defaultValue;
public
Column(int index_, String name_) {
this(index_,
null, name_, Integer.MAX_VALUE, null);
}
public
Column(int index_, Type type_, String name_) {
this(index_,
type_, name_, Integer.MAX_VALUE, null);
}
public
Column(int index_, Type type_, String name_, Cell defaultValue)
{
this(index_,
type_, name_, Integer.MAX_VALUE, defaultValue);
}
public
Column(int index_, Type type_, String name_, int length_,
Cell
defaultValue) {
this(index_,
type_, null, null, name_, length_, null);
}
public
Column(int index_, Type type_, Type in_, Type out_, String name_)
{
this(index_,
type_, in_, out_, name_, Integer.MAX_VALUE);
}
public
Column(int index_, Type type_, Type in_, Type out_, String
name_,
int length_)
{
this(index_,
type_, in_, out_, name_, length_, null);
}
public
Column(int index_, Type type_, Type in_, Type out_, String
name_,
int length_,
Cell defaultValue) {
this.columnIndex = index_;
this.type =
type_;
this.inType
= in_;
this.outType
= out_;
this.name =
name_;
this.length
= length_;
this.defaultValue = defaultValue;
}
public
String getName() {
return
name;
}
public Type
getType() {
return
type;
}
public
boolean isNull() {
return name
== null;
}
public void
setType(Type colType) {
type =
colType;
}
public Type
getInType() {
return
inType;
}
public void
setInType(Type inType_) {
inType =
inType_;
}
public Type
getOutType() {
return
outType;
}
public void
setOutType(Type outType_) {
outType =
outType_;
}
public int
getIndex() {
return
this.columnIndex;
}
public void
setIndex(int index_) {
this.columnIndex = index_;
}
public int
getLength() {
return
length;
}
public void
setLength(int length_) {
length =
length_;
}
public
Object getDefaultValue() {
return
defaultValue;
}
public void
setDefaultValue(Object defValue) {
this.defaultValue = defValue;
}
public
boolean useDefault() {
return
defaultValue != null;
}
public
String toString() {
if
(isNull()) {
return
"[Column] <null>";
}
String
string = "[Column] index=" + columnIndex + ",name=" + name
+ ",type={"
+ type + "}" + ",inType={" + inType + "}"
+
",outType={" + outType + "}" + ",length=" + length
+
",default=" + defaultValue;
return
string;
}
}
package xls.core;
import java.util.Vector;
public class Record {
private
Schema schema;
private int
rowNum;
private
Vector<Cell> cells;
public
Record(Schema schema_, int rowNum_) {
this(schema_, rowNum_, null);
}
public
Record(Schema schema_, int rowNum_,
Vector<Cell> cells_) {
this.schema
= schema_;
this.rowNum
= rowNum_;
this.cells =
cells_;
if
(this.cells == null) {
cells = new
Vector<Cell>();
}
}
public void
addCell(Cell cell) {
cells.addElement(cell);
}
public Cell
getCell(int index) {
return
(Cell) cells.elementAt(index);
}
public int
getRowNum() {
return
rowNum;
}
public int
getCellCount() {
return
cells.size();
}
public
Schema getSchema() {
return
schema;
}
public void
setRowIndex(int rowIndex) {
this.rowNum
= rowIndex;
}
public int
getRowIndex() {
return
this.rowNum;
}
public void
clearCells() {
cells.clear();
}
public
String toString() {
return
"[Record] row=" + rowNum + ",cells=" + cells;
}
}
package xls.core;
import java.io.File;
import java.io.FileInputStream;
import java.util.Properties;
import java.util.Vector;
import xls.util.IoUtils;
import xls.util.StoreConfig;
public class Schema {
private
String tableName;
private
String queryString;
private Type
defaultType;
private int
startRow;
private int
endRow;
private
Vector<Column> columns;
private
StoreConfig storeConfig;
private
boolean validating;
private
String pathname;
public
Schema() {
}
public void
open() throws Exception {
Properties
props = new Properties();
FileInputStream fis = new FileInputStream(configFile());
props.load(fis);
fis.close();
this.tableName = props.getProperty("schema.table.name");
this.queryString = props.getProperty("schema.table.query");
String
defType = props.getProperty("schema.column.default");
String
colCount = props.getProperty("schema.column.count");
String check
= props.getProperty("schema.column.validating");
String
firstRow = props.getProperty("schema.row.start");
String
endRow = props.getProperty("schema.row.end");
String
connURL = props.getProperty(StoreConfig.STORE_URL);
String
connDriver = props.getProperty(StoreConfig.STORE_DRIVER);
String
connType = props.getProperty(StoreConfig.STORE_TYPE);
String
connUSR = props.getProperty(StoreConfig.STORE_USERNAME);
String
connPWD = props.getProperty(StoreConfig.STORE_PASSWORD);
this.storeConfig = new StoreConfig(connType, connURL, connUSR,
connPWD,
connDriver);
this.defaultType = Type.valueOf(defType);
int
columnCount = 0;
if (colCount
!= null && colCount.length()
> 0) {
columnCount
= Integer.parseInt(colCount);
}
if (firstRow
!= null && firstRow.length()
> 0) {
this.startRow = Integer.parseInt(firstRow);
} else
{
this.startRow = 0;
}
if (endRow
!= null && endRow.length()
> 0) {
this.endRow
= Integer.parseInt(endRow);
} else
{
this.endRow
= Integer.MAX_VALUE;
}
this.validating = Boolean.valueOf(check).booleanValue();
this.columns
= new Vector<Column>();
String
colName = null;
String
colType = null;
String
inType = null;
String
outType = null;
String
colDefault = null;
String
colLength = null;
如果不懂的话，或者是如果你想了解和学习更多的JAVA编程，成为一名真正的JAVA高手，你可以来这个群，前面三个数是四二六 中间是三九六 后面是二八四 把这串数字连起来就可以了，这是一个高手的学习群，在这里你可以学习到书上学不到的知识，还有大牛相互讨论并指导你解答哦！
分享好知识！