//获得当前系统时间:
java.util.Date date = new java.util.Date();
//将它转换为java.sql.Timestamp类型(因为SQL Server数据库的datetime字段对应为JAVA中的java.sql.Timestamp类型)java.util.Calendar cal = java.util.Calendar.getInstance();
cal.setTime(date);
String str = cal.get(java.util.Calendar.YEAR) + "-";
str += cal.get(java.util.Calendar.MONTH) + "-";
str += cal.get(java.util.Calendar.DATE) + " 00:00:00.000000000";
java.sql.Timestamp t = java.sql.Timestamp.valueOf(str);
//然后插入到数据库
java.util.Date date = new java.util.Date();
//将它转换为java.sql.Timestamp类型(因为SQL Server数据库的datetime字段对应为JAVA中的java.sql.Timestamp类型)java.util.Calendar cal = java.util.Calendar.getInstance();
cal.setTime(date);
String str = cal.get(java.util.Calendar.YEAR) + "-";
str += cal.get(java.util.Calendar.MONTH) + "-";
str += cal.get(java.util.Calendar.DATE) + " 00:00:00.000000000";
java.sql.Timestamp t = java.sql.Timestamp.valueOf(str);
//然后插入到数据库
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String mDateTime=formatter.format(cal.getTime());
Date today = new Date();
String dateString = formatter.format(today);//录入日期
~~
这个字段是datetime型
stmt.executeUpdate(selCode);
怎么差不进去呀
prestmt =DbaObj.Conn.prepareStatement(mSql);
prestmt.setString(1, "aaa");
prestmt.setString(2, "0000");
prestmt.setInt(3, fileSize);
prestmt.setString(4, DbaObj.GetDateTime());
prestmt.setBinaryStream(5,fis,(int)file.length());
DbaObj.Conn.setAutoCommit(true) ;
prestmt.executeUpdate();
DbaObj.Conn.commit();
import java.util.*;
import java.text.*;
public class getdata
{
public static void main(String[] args)
{
try
{
String address = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=上海炼油厂";//本机ip
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");//申明
Connection con = DriverManager.getConnection(address,"sa","sss");//建立链接
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
java.util.Date date = new java.util.Date();
//String dateString = formatter.format(date);//录入日期
String insertsql="INSERT INTO 上海炼油厂 VALUES (?,?,?,?)";
PreparedStatement stmt=con.prepareStatement(insertsql);
int dateString=13;
stmt.setInt(1,dateString);
stmt.setInt(2,dateString); //第一二个字段为int型 为什么有问题呀
con.setAutoCommit(true) ;
stmt.executeUpdate();
con.commit();
System.out.println("ok");
}
catch(Exception e)
{
System.out.println(e);//捕捉异常
}
}
} //
setDate
public void setDate(int parameterIndex,
Date x)
throws SQLException