第1个回答 2010-12-08
access 操作
delete from tbl_Record where IOTime<#2009-8-1#
select * from tbl_Record where IOTime<#2009-9-1#
update tbl_record set iotime=DateAdd("m", 1,iotime)
你查类型,长度,空进库看不就可以了.另附java代码
package test;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class RAccess{
public static void main(String[] args){
try{
Driver driver = (Driver) Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
DriverManager.registerDriver(driver);
//String url = "jdbc:odbc:Driver=MDBToolsODBC;DSN=ATD";
Connection connection = DriverManager.getConnection(args[0]);
Statement statement = connection.createStatement();
ResultSet set = statement.executeQuery("SELECT * FROM RECORD WHERE FORMAT(IOTime,'yyyymmddHhNnSs')>'20090910000000'");
while(set.next()){
System.out.println(set.getObject(1));
}
set.close();
statement.close();
connection.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
第3个回答 2019-08-21
1、如果优差生表存在
insert
into
优差生
select
学号,科目,成绩
from
考试
2、优差生表不存在,这个在sqlserver中运行,access我这里没装,没法测试了
select
学号,科目,成绩
into
优差生
from
考试