f05e82fcfd3b001d111782b9be622526

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

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 ArrayList getRelationVO(int chezhanNumber) {
		ArrayList al = new ArrayList();
		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()) {

				al.add(rs.getString(1));

			}
		} catch (Exception e) {

		} finally {
			dbc.close();
		}
		return al;
	}
	
	public ArrayList getRelationCinumber(int start,int end){
		ArrayList al = new ArrayList();
		DataBaseConnection dbc = new DataBaseConnection();
		PreparedStatement psmt = null;
		ResultSet rs = null;
		String sql = "select cinumber from relation where cznumber=?";
		return al;
		
	}
}