<%@ page import="java.lang.*,java.sql.*,java.util.Calendar,java.text.*" %>
<%Date startDate=Date.valueOf("2004-1-1");
Date endDate=Date.valueOf("2004-12-31");//数据库连接代码 Statement stmt=...;
while(startDate.before(endDate)){
strsql="insert into date values('"+startDate+"'";
stmt.executeUpdate(strsql);
Calendar cDate = Calendar.getInstance(); //java.util°ü
cDate.setTime(startDate);
cDate.add(cDate.DATE, 1);
String meStrDate=strDate.get(strDate.YEAR) + "-" +String.valueOf(strDate.get(strDate.MONTH)+1) + "-" + strDate.get(strDate.DATE);
startDate=Date.valueOf(meStrDate);
}
%>试一试吧
<%Date startDate=Date.valueOf("2004-1-1");
Date endDate=Date.valueOf("2004-12-31");//数据库连接代码 Statement stmt=...;
while(startDate.before(endDate)){
strsql="insert into date values('"+startDate+"'";
stmt.executeUpdate(strsql);
Calendar cDate = Calendar.getInstance(); //java.util°ü
cDate.setTime(startDate);
cDate.add(cDate.DATE, 1);
String meStrDate=strDate.get(strDate.YEAR) + "-" +String.valueOf(strDate.get(strDate.MONTH)+1) + "-" + strDate.get(strDate.DATE);
startDate=Date.valueOf(meStrDate);
}
%>试一试吧
<%@ page import="java.lang.*,java.sql.*,java.util.Calendar,java.text.*" %>
<%Date startDate=Date.valueOf("2004-1-1");
Date endDate=Date.valueOf("2004-12-31");Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection connect;
connect=DriverManager.getConnection("jdbc:odbc:news","","");
Statement stmt = connect.createStatement();while(startDate.before(endDate)){
String strsql="insert into date values('"+startDate+"')";
stmt.executeUpdate(strsql);
Calendar cDate = Calendar.getInstance(); //java.util°ü
cDate.setTime(startDate);
cDate.add(cDate.DATE, 1);
String meStrDate=cDate.get(cDate.YEAR) + "-" +String.valueOf(cDate.get(cDate.MONTH)+1) + "-" + cDate.get(cDate.DATE);
startDate=Date.valueOf(meStrDate);
}
out.println("ok");
%>
操作成功