hsqldbtest.java

是Eclipse web开发从入门到精通的源码

package hsqldb.test;

import java.sql.ResultSet;
import java.sql.SQLException;

import hsqldb.dbo.ScoreDAO;
import hsqldb.dbo.ScoreDAOFactory;
import hsqldb.javabean.Score;

public class HsqldbTest {

	static ResultSet result;

	/**
	 * @param args
	 */
	public static void main(String[] args) throws SQLException {

		ScoreDAO scoreDAO = ScoreDAOFactory.getScoreDAO();

		Score firstScore = new Score();
		firstScore.setCNO("34");
		firstScore.setSNO("1");
		firstScore.setGRADE((float) 2.5);

		Score secondScore = new Score();
		secondScore.setCNO("45");
		secondScore.setGRADE((float) 67.9);
		secondScore.setSNO("2");

		Score thirdScore = new Score();
		thirdScore.setCNO("78");
		thirdScore.setSNO("3");
		thirdScore.setGRADE((float) 89.0);

		scoreDAO.insertScore(firstScore);

		result = scoreDAO.selectAll();

		info(result);

		scoreDAO.insertScore(secondScore);
		result = scoreDAO.selectAll();
		info(result);

		scoreDAO.updateScore(secondScore, thirdScore);
		result = scoreDAO.selectAll();
		info(result);
		scoreDAO.deleteScore(firstScore);

		result = scoreDAO.selectAll();
		info(result);
		
		ScoreDAOFactory.closeConnection();

	}

	private static void info(ResultSet result) {
		try {
			while (result.next()) {
				System.out.println("学号＝" + result.getString(1) + ",课程编号＝"
						+ result.getString(2) + ",分数＝" + result.getFloat(3));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		System.out.println("**********************************");
	}

}