20e220dd5d3b001d12f483999dc4cf57

自己做的一个火车票售票网站是课程设计 用的是servlet+jsp 数据库是ms

package com.daoImpl;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.*;

import com.dao.RelationDAO;
import com.jdbc.DataBaseConnection;
import com.sun.xml.internal.bind.v2.schemagen.xmlschema.List;
import com.vo.ChezhanVO;
import com.vo.RelationVO;

public class RelationDAOImpl implements RelationDAO {

	public Collection getRelationVO(int chezhanNumber) {
		Collection all =new ArrayList() ;
		DataBaseConnection dbc = null;
		PreparedStatement psmt = null;
		ResultSet rs = null;
		String sql = "select cinumber from relation where cznumber=?";
		try {
			psmt = dbc.getConnection().prepareStatement(sql);
			psmt.setInt(1, chezhanNumber);
			rs = psmt.executeQuery();
			while (rs.next()) {
				/*RelationVO vo = null;
				vo.setCheciNumber(rs.getString(1));
				vo.setChezhanNumber(rs.getInt(2));
				vo.setNumber(rs.getInt(3));
				vo.setLength(rs.getInt(4));
				all.add(vo);*/
			}
		} catch (Exception e) {

		} finally {
			dbc.close();
		}
		return all;
	}
}