derby测试
package core.dao;import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;public class DerbyUtilTest {private static DerbyUtil util;public static void main(String[] args) {util = DerbyUtil.getInstance();createTable();}public void selectTable(){util.execute(new Processor() {public void execute(Connection conn) {try {ResultSet rs = conn.prepareStatement("select * from t_user").executeQuery();while (rs.next()) {System.out.println(rs.getString(1));}} catch (SQLException e) {e.printStackTrace();}}});}public static void createTable(){util.execute(new Processor() {public void execute(Connection conn) {try {conn.createStatement();System.out.println(conn.getWarnings());} catch (Exception e) {e.printStackTrace();}}});}}package core.dao;import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;public class DerbyUtilTest {private static DerbyUtil util;public static void main(String[] args) {util = DerbyUtil.getInstance();createTable();}public void selectTable(){util.execute(new Processor() {public void execute(Connection conn) {try {ResultSet rs = conn.prepareStatement("select * from t_user").executeQuery();while (rs.next()) {System.out.println(rs.getString(1));}} catch (SQLException e) {e.printStackTrace();}}});}public static void createTable(){util.execute(new Processor() {public void execute(Connection conn) {try {conn.createStatement();System.out.println(conn.getWarnings());} catch (Exception e) {e.printStackTrace();}}});}}
页:
[1]