PreparedStatement.setTimestamp(1,datetime)

Trong sqlserver có 1 cột DateTime

Trong java nếu dùng preparedStatement rồi thiết lập giá trị cho tham số cho field dateTime này thì nên dùng setTimestamp method.

Ví dụ:
// xem ky hai dong nay
java.sql.Timestamp tstamp = new java.sql.Timestamp(00-00-00);
ps.setTimestamp(5,tstamp.valueOf(“1986-04-02 00:00:00.0″));

Toàn bộ sourcecode


//http://www.roseindia.net/jdbc/jdbc-mysql/SetTimetamp.shtml

import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Timestamp;

public class SinhVien
{
public static void main(String args[]) throws Exception
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:odbc:QUANLY_SINHVIEN");
PreparedStatement ps;

String sql="insert into tbSV(HoLot,Ten,Nu,DChi,NgSinh,NamVaoHoc,MaLop) ";
sql+=" values(?,?,?,?,?,?,?)";
ps = conn.prepareStatement(sql);
ps.setString(1,"abcxyz");
ps.setString(2,"jguru");
ps.setBoolean(3,false);
ps.setString(4,"Phu Nhuan");

// xem ky hai dong nay
Timestamp tstamp = new Timestamp(00-00-00);
ps.setTimestamp(5,tstamp.valueOf("1986-04-02 00:00:00.0"));

ps.setInt(6,2004);
ps.setString(7,"TH04");
ps.executeUpdate();

ps = conn.prepareStatement("select * from tbSV");
ResultSet rs = ps.executeQuery();
viewTable(rs);

rs.close();
ps.close();
conn.close();
}

static void viewTable(ResultSet rs) throws Exception
{
ResultSetMetaData md = rs.getMetaData();
int n = md.getColumnCount();
while(rs.next())
{
for(int i=1;i<=n;i++)
System.out.printf("\t %s",rs.getString(i));
System.out.println();
}
}
}