Date dt_startdate = new Date(); DateFormat df1 = DateFormat.getDateInstance(DateFormat.SHORT); String s1 = df1.format(dt_startdate);insert into company (com_id, start_date) values ("com1", ?)ps.setDate(1, s1);
import java.util.*; import java.sql.*; import java.text.*; class test_0415 { public static void main(String[] args) throws Exception { try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection Con = DriverManager.getConnection("jdbc:odbc:a","sa","sa"); PreparedStatement Pst = Con.prepareStatement("INSERT INTO Temp(Id,to_date) VALUES(1,?)");
java.util.Date b = new java.util.Date(); java.util.Date a = new java.util.Date(b.getYear(),b.getMonth(),b.getDay(),b.getHours(),b.getMinutes(),b.getSeconds()); DateFormat df = DateFormat.getDateInstance(); String s = df.format(a); java.sql.Date now = java.sql.Date.valueOf(s); Pst.setDate(1,now);
DateFormat df1 = DateFormat.getDateInstance(DateFormat.SHORT); String s1 = df1.format(dt_startdate);insert into company (com_id, start_date) values ("com1", ?)ps.setDate(1, s1);
import java.sql.*;
import java.text.*;
class test_0415
{
public static void main(String[] args) throws Exception
{ try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection Con = DriverManager.getConnection("jdbc:odbc:a","sa","sa");
PreparedStatement Pst = Con.prepareStatement("INSERT INTO Temp(Id,to_date) VALUES(1,?)");
java.util.Date b = new java.util.Date();
java.util.Date a = new java.util.Date(b.getYear(),b.getMonth(),b.getDay(),b.getHours(),b.getMinutes(),b.getSeconds()); DateFormat df = DateFormat.getDateInstance();
String s = df.format(a);
java.sql.Date now = java.sql.Date.valueOf(s); Pst.setDate(1,now);
}
catch(Exception e){
System.out.println(e.toString());
}
}
}