?? jdbctypemapper.java
字號:
package quanquanqi;
import java.sql.*;
import java.text.*;
import java.math.*;
public class JDBCTypeMapper
{
//實現JDBC到Java類型的映射
static NumberFormat nf = (DecimalFormat) NumberFormat.getInstance();
static DateFormat df = DateFormat.getDateInstance(DateFormat.LONG);
//------------------------------------------------------------------------------
public static Object getColumnDataString( int col, ResultSet rs)
{
//從rs中檢索一列,將此列數據轉化為Java String型
Object obj = null;//儲存方法的返回值
int type = 0;//儲存列的數據類型
try {
type = rs.getMetaData().getColumnType(col);
switch (type) {
case Types.INTEGER:
case Types.SMALLINT:
case Types.TINYINT:
obj = rs.getObject(col).toString();
break;
case Types.DOUBLE:
case Types.DECIMAL:
case Types.NUMERIC:
case Types.FLOAT://對小數處理
nf.setMaximumFractionDigits(3);//限制結果字符串中小數數字個數為3
obj = nf.format(rs.getDouble(col));
break;
case Types.BIT:
obj = rs.getBoolean(col) ? "1" : "0";
break;
case Types.DATE:
obj = df.format(rs.getDate(col));
break;
case Types.CHAR:
case Types.VARCHAR:
case Types.LONGVARCHAR:
obj = rs.getObject(col).toString();
break;
case Types.BLOB:
case Types.CLOB:
obj = "<BLOB>";
break;
case Types.NULL:
obj = " ";//映射為空字符串
default:
obj = rs.getObject(col).toString();
break;
}
}
catch (SQLException e) {
System.out.println("SQLException in getColumnData: " + e.getMessage());
}
finally
{
return obj;
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -