package
JDBC;
import java.sql.Connection;
import java.sql.Date;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.Time;
import java.sql.Timestamp;
import java.text.SimpleDateFormat;
import java.util.Calendar;
/** */ /**
*
* @author oakertree
*
*/
public class TestScroll {
public static void main(String[] args) {
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try {
Class.forName("com.mysql.jdbc.Driver");
// new com.mysql.jdbc.Driver();
con = DriverManager.getConnection("jdbc:mysql://localhost:3307/test", "root", "admini");
stmt = con.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery("SELECT * FROM time");
rs.next();
System.out.println(rs.getDate(1));
System.out.println(rs.getTime(2));
System.out.println(rs.getTimestamp(3));
System.out.println("*******************************");
rs.last();
System.out.println(rs.getDate(1));
System.out.println(rs.getTime(2));
System.out.println(rs.getTimestamp(3));
System.out.println("*******************************");
System.out.println(rs.last());
System.out.println("*******************************");
System.out.println(rs.isAfterLast());
System.out.println("*******************************");
System.out.println(rs.isBeforeFirst());
System.out.println("*******************************");
System.out.println(rs.getRow());
System.out.println("*******************************");
rs.previous();
System.out.println(rs.getDate(1));
System.out.println(rs.getTime(2));
System.out.println(rs.getTimestamp(3));
System.out.println("*******************************");
rs.absolute(rs.getRow() - 2);
System.out.println(rs.getDate(1));
System.out.println(rs.getTime(2));
System.out.println(rs.getTimestamp(3));
System.out.println("*******************************");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if(rs != null) {
rs.close();
rs = null;
}
if(stmt != null) {
stmt.close();
stmt = null;
}
if(con != null) {
con.close();
con = null;
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
/**/ /*
+----------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+----------+------+-----+---------+-------+
| date | date | YES | | NULL | |
| time | time | YES | | NULL | |
| datetime | datetime | YES | | NULL | |
+----------+----------+------+-----+---------+-------+
*/
import java.sql.Connection;
import java.sql.Date;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.Time;
import java.sql.Timestamp;
import java.text.SimpleDateFormat;
import java.util.Calendar;
/** */ /**
*
* @author oakertree
*
*/
public class TestScroll {
public static void main(String[] args) {
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try {
Class.forName("com.mysql.jdbc.Driver");
// new com.mysql.jdbc.Driver();
con = DriverManager.getConnection("jdbc:mysql://localhost:3307/test", "root", "admini");
stmt = con.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery("SELECT * FROM time");
rs.next();
System.out.println(rs.getDate(1));
System.out.println(rs.getTime(2));
System.out.println(rs.getTimestamp(3));
System.out.println("*******************************");
rs.last();
System.out.println(rs.getDate(1));
System.out.println(rs.getTime(2));
System.out.println(rs.getTimestamp(3));
System.out.println("*******************************");
System.out.println(rs.last());
System.out.println("*******************************");
System.out.println(rs.isAfterLast());
System.out.println("*******************************");
System.out.println(rs.isBeforeFirst());
System.out.println("*******************************");
System.out.println(rs.getRow());
System.out.println("*******************************");
rs.previous();
System.out.println(rs.getDate(1));
System.out.println(rs.getTime(2));
System.out.println(rs.getTimestamp(3));
System.out.println("*******************************");
rs.absolute(rs.getRow() - 2);
System.out.println(rs.getDate(1));
System.out.println(rs.getTime(2));
System.out.println(rs.getTimestamp(3));
System.out.println("*******************************");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if(rs != null) {
rs.close();
rs = null;
}
if(stmt != null) {
stmt.close();
stmt = null;
}
if(con != null) {
con.close();
con = null;
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
/**/ /*
+----------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+----------+------+-----+---------+-------+
| date | date | YES | | NULL | |
| time | time | YES | | NULL | |
| datetime | datetime | YES | | NULL | |
+----------+----------+------+-----+---------+-------+
*/