609e805f753b001d12f483999dc4cf57

来自「自己做的一个火车票售票网站是课程设计 用的是servlet+jsp 数据库是m」· 代码 · 共 45 行

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 String[] getRelationVO(int chezhanNumber) {
		//Collection all =new ArrayList() ;
		String[] str1 = new String[];
		DataBaseConnection dbc = new DataBaseConnection();
		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()) {
				int i=0;
				str1[i]=rs.getString(i+1);
				i++;
				/*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 str1;
	}
}