public static void main(String[] args) { // TODO Auto-generated method stub GetSchemaByResultSet getSchema=new GetSchemaByResultSet(); getSchema.getSchemaTest(); }}
如何把select sum(字段) as XXX from table中返回的XXX显示在页面 request.setAttribute("XXX",re.getString("XXX"));------------------------- 显示 ${XXX}或<%String s=request.getAttribute("XXX").toString()%><%=s%>
sum(字段)和别的字段有什么不同吗?不明白楼主的意思。
假设select sum(字段) as XXX from table;假设返回的是个ResultSet rs; String sum=null; if(rs.next()) { sum=rs.getString(1); } sum就取得你的结果了
LZ是不是想说,sum是数值型的,你不知道怎么取出来??
楼主看这样对不?这样没错的,我做过这样的. <%if(Rs.next()){ int XXX; XXX=Rs.getInt("XXX"); out.println(XXX); } %>
float a=15.0; float b=30.0; String c=a/b*100+"%";
数字格式化 DecimalFormat decimalFormat = new DecimalFormat("##.0"); String s = decimalFormat.format(d);显示2个整数位和1个小数位。
如何完成一个论坛,要求图片能上传,能做缓存,语法高亮显示
--------希望能给出代码,谢谢大家了.
- -!
下面的代码不知道能不能满足你要求
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
public class GetSchemaByResultSet { public GetSchemaByResultSet() {
super();
}
private static Connection getJdbcConnection(){
Connection con = null;
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@192.168.0.0:1521:abc";
con = DriverManager.getConnection(url, "bac", "abc");
con.setAutoCommit(false);
} catch(Exception e){
System.out.println(e);
if(con != null){
try{
con.close();
} catch(SQLException ex){
System.out.println(ex);
}
}
}
return con;
} public void getSchemaTest() {
Connection con = getJdbcConnection();
try {
Statement st = con.createStatement();
String sql = "select operatorid a from t_operator";
ResultSet rs = st.executeQuery(sql);
ResultSetMetaData meta=rs.getMetaData();
System.out.println("meta.getColumnCount()"+meta.getColumnCount());
for(int i=1;i<=meta.getColumnCount();i++){
System.out.println("===========start==========="+i);
int columnDisplaySize=meta.getColumnDisplaySize(i);
String columnLabel=meta.getColumnLabel(i);
String columnName=meta.getColumnName(i);
int columnType=meta.getColumnType(i);
String columnTypeName=meta.getColumnTypeName(i);
String tableName=meta.getTableName(i);
String schemaName=meta.getSchemaName(i); System.out.println("columnDisplaySize:"+columnDisplaySize);
System.out.println("columnLabel:"+columnLabel);
System.out.println("columnName:"+columnName);
System.out.println("columnType:"+columnType);
System.out.println("columnTypeName:"+columnTypeName);
System.out.println("tableName:"+tableName);
System.out.println("schemaName:"+schemaName);
System.out.println("===========end===========");
}
rs.close();
st.close();
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void main(String[] args) {
// TODO Auto-generated method stub
GetSchemaByResultSet getSchema=new GetSchemaByResultSet();
getSchema.getSchemaTest();
}}
request.setAttribute("XXX",re.getString("XXX"));-------------------------
显示 ${XXX}或<%String s=request.getAttribute("XXX").toString()%><%=s%>
String sum=null;
if(rs.next())
{
sum=rs.getString(1);
}
sum就取得你的结果了
<%if(Rs.next()){ int XXX; XXX=Rs.getInt("XXX"); out.println(XXX); } %>
float b=30.0;
String c=a/b*100+"%";
DecimalFormat decimalFormat = new DecimalFormat("##.0");
String s = decimalFormat.format(d);显示2个整数位和1个小数位。