package FS;
import java.sql.*;
public class UpdateStu {
static Connection con;
static PreparedStatement sql;
static ResultSet res;
public Connection getConnection() {
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con = DriverManager.getConnection(
"jdbc:microsoft:sqlserver://localhost:1433;"
+ "DatabaseName=newdb", "sa", "data");
} catch (Exception e) {
e.printStackTrace();
}
return con;
}
public static void main(String[] args) {
UpdateStu c = new UpdateStu();
con = c.getConnection();
try {
// sql = con.prepareStatement("delete from newtable where birthday < ?");
// sql.setString(1, "2000-09-01");
// sql.executeUpdate();
// sql = con.prepareStatement("select * from uep.dbo.A_experiment");
// String sql = "select * from uep.dbo.A_experiment";
sql = con.prepareStatement("select * from uep.dbo.A_experiment");
// executeQuery(sql);
ResultSet rs =sql.executeQuery();
while (rs.next())
{
// for(int i =0;i<17;i++)
// {
// String result = rs.getString(i+1);
// System.out.println(result);
// }
//rs.getDate(13);
Date date = rs.getDate(5);
System.out.println(date);
date.getYear();
date.getMonth();
System.out.println(date.getYear());
System.out.println(date.getMonth());
System.out.println(date.getDay());
// System.out.println(date.getHours());
// System.out.println(date.getMinutes());
// System.out.println(date.getSeconds());
}
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
System.out.println("fail");
}
}
}