import java.sql.*;
import java.text.DateFormat;
import java.util.Calendar;
public class TestThinApp {
public static String intToString(int value)
{
Integer integer = new Integer(value);
return integer.toString();
}
public static String trimString(String str,int n) {
String sTemp = str;
int nl = str.length();
if(nl > n) {}
else sTemp = "0" + str;
return sTemp;
}
public static void main(String args[]) throws ClassNotFoundException, SQLException {
Calendar calendar = Calendar.getInstance();
calendar.add(Calendar.MINUTE, -1480);
int y,m,d,h,mi,s;
String mo,dm,hh,mn,ss,tim;
String tim1 = null;
y=calendar.get(Calendar.YEAR);
m=calendar.get(Calendar.MONTH)+ 1;
d=calendar.get(Calendar.DATE);
h=calendar.get(Calendar.HOUR_OF_DAY);
mi=calendar.get(Calendar.MINUTE);
s=calendar.get(Calendar.SECOND);
mo = TestThinApp.intToString(m);
mo = TestThinApp.trimString(mo,1);
dm = TestThinApp.intToString(d);
dm = TestThinApp.trimString(dm,1);
hh = TestThinApp.intToString(h);
hh = TestThinApp.trimString(hh,1);
mn = TestThinApp.intToString(mi);
mn = TestThinApp.trimString(mn,1);
ss = TestThinApp.intToString(s);
ss = TestThinApp.trimString(ss,1);
tim1 = y+"-"+mo+"-"+dm+" "+hh+":"+mn+":"+ss;
String tim2 = "2009-12-08 17:11:52";
PreparedStatement sql;
Connection con;
ResultSet rs ;
// System.out.println(tim1);
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@192.168.21.193:1521:orcl", "biaoguanli", "aaa");
sql = con.prepareStatement("select * from system.d1_20091210 ");//where DAW <? and DAW >?
// sql.setString(1, tim1);
//sql.setString(2, tim2);
rs = sql.executeQuery();
while (rs.next()) {
String[] timee = null;// 时间数据
int[] value = null;// 流量数据2009-12-08 19:14:48
timee = new String[]{rs.getString(1)};
value = new int[]{rs.getInt(2)};
for(int i = 0; i < value.length; i++){
System.out.println(timee[i]+" "+value[i]);
}
}
con.close();
} }
希望大家帮帮小弟,我用jsp做的页面就想调用最后的数据,如果能是jsp的代码就好了,谢谢天下大侠!
import java.text.DateFormat;
import java.util.Calendar;
public class TestThinApp {
public static String intToString(int value)
{
Integer integer = new Integer(value);
return integer.toString();
}
public static String trimString(String str,int n) {
String sTemp = str;
int nl = str.length();
if(nl > n) {}
else sTemp = "0" + str;
return sTemp;
}
public static void main(String args[]) throws ClassNotFoundException, SQLException {
Calendar calendar = Calendar.getInstance();
calendar.add(Calendar.MINUTE, -1480);
int y,m,d,h,mi,s;
String mo,dm,hh,mn,ss,tim;
String tim1 = null;
y=calendar.get(Calendar.YEAR);
m=calendar.get(Calendar.MONTH)+ 1;
d=calendar.get(Calendar.DATE);
h=calendar.get(Calendar.HOUR_OF_DAY);
mi=calendar.get(Calendar.MINUTE);
s=calendar.get(Calendar.SECOND);
mo = TestThinApp.intToString(m);
mo = TestThinApp.trimString(mo,1);
dm = TestThinApp.intToString(d);
dm = TestThinApp.trimString(dm,1);
hh = TestThinApp.intToString(h);
hh = TestThinApp.trimString(hh,1);
mn = TestThinApp.intToString(mi);
mn = TestThinApp.trimString(mn,1);
ss = TestThinApp.intToString(s);
ss = TestThinApp.trimString(ss,1);
tim1 = y+"-"+mo+"-"+dm+" "+hh+":"+mn+":"+ss;
String tim2 = "2009-12-08 17:11:52";
PreparedStatement sql;
Connection con;
ResultSet rs ;
// System.out.println(tim1);
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@192.168.21.193:1521:orcl", "biaoguanli", "aaa");
sql = con.prepareStatement("select * from system.d1_20091210 ");//where DAW <? and DAW >?
// sql.setString(1, tim1);
//sql.setString(2, tim2);
rs = sql.executeQuery();
while (rs.next()) {
String[] timee = null;// 时间数据
int[] value = null;// 流量数据2009-12-08 19:14:48
timee = new String[]{rs.getString(1)};
value = new int[]{rs.getInt(2)};
for(int i = 0; i < value.length; i++){
System.out.println(timee[i]+" "+value[i]);
}
}
con.close();
} }
希望大家帮帮小弟,我用jsp做的页面就想调用最后的数据,如果能是jsp的代码就好了,谢谢天下大侠!
解决方案 »
- jsp页面出现红色波浪线,但是页面工作正常
- 求教 Spring MVC MultiActionController validator验证问题
- qq675046199 进进进
- jsp更新数据库一条记录中的image类型数据?
- bean中如何取得绝对路径 ???(求救)
- 用ScriptX 弹出对话框.大家一定要帮忙呀(大家帮忙呀.已经想了3天了)
- 关于文件操作的问题
- 怎样不通过post传输方式传输数据(肯定给分)
- 如何把tomcat集成入IIS中?使Tomcat和IIS用同一个默认的80端口?
- JSP访问数据库是出错了,高手请看错在哪里?
- 请会struts2的朋友帮忙看看一段用struts2的上传,为什么就上传不了???
- 一个ssh框架项目,如何加入web service功能,转变成所谓面向服务的SOA?
顶顶
大虾
急急急急急急
利用 <%@ page language="java" pageEncoding="GB2312" import="pa1.pa2.TestThinApp"%>这样在jsp页面引进TestThinApp 然后就可以可以在 <%%>里调用 TestThinApp.intToString(...) 。
<% //这里%>里面。
以后如果这块代码复用率很高的话可以编制成标签在网页里引用
<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="utf-8"%>
<%@ page import="pa1.pa2.TestThinApp"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>My JSP 'aa.jsp' starting page</title> </head>
<body>
<%
Calendar calendar = Calendar.getInstance();
calendar.add(Calendar.MINUTE, -1480);
int y,m,d,h,mi,s;
String mo,dm,hh,mn,ss,tim;
String tim1 = null;
y=calendar.get(Calendar.YEAR);
m=calendar.get(Calendar.MONTH)+ 1;
d=calendar.get(Calendar.DATE);
h=calendar.get(Calendar.HOUR_OF_DAY);
mi=calendar.get(Calendar.MINUTE);
s=calendar.get(Calendar.SECOND);
mo = TestThinApp.intToString(m);
mo = TestThinApp.trimString(mo,1);
dm = TestThinApp.intToString(d);
dm = TestThinApp.trimString(dm,1);
hh = TestThinApp.intToString(h);
hh = TestThinApp.trimString(hh,1);
mn = TestThinApp.intToString(mi);
mn = TestThinApp.trimString(mn,1);
ss = TestThinApp.intToString(s);
ss = TestThinApp.trimString(ss,1);
tim1 = y+"-"+mo+"-"+dm+" "+hh+":"+mn+":"+ss;
String tim2 = "2009-12-08 17:11:52";
PreparedStatement sql;
Connection con;
ResultSet rs ;
// System.out.println(tim1);
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@192.168.21.193:1521:orcl", "biaoguanli", "aaa");
sql = con.prepareStatement("select * from system.d1_20091210 ");//where DAW <? and DAW >?
// sql.setString(1, tim1);
//sql.setString(2, tim2);
rs = sql.executeQuery();
while (rs.next()) {
String[] timee = null;// 时间数据
int[] value = null;// 流量数据2009-12-08 19:14:48
timee = new String[]{rs.getString(1)};
value = new int[]{rs.getInt(2)};
for(int i = 0; i < value.length; i++){
out.println(timee[i]+" "+value[i]); //这里改为out
}
}
con.close();
%>
</body>
</html>
这就是什么意思啊 啊/