relationdaoimpl.java

自己做的一个火车票售票网站是课程设计 用的是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 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 dbo.relationView1.cinumber from dbo.relationView1,dbo.relationView2 where dbo.relationView1.cznumber=? and dbo.relationView2.cznumber=? and dbo.relationView1.number<dbo.relationView2.number and dbo.relationView1.cinumber=dbo.relationView2.cinumber";
		try{
			psmt = dbc.getConnection().prepareStatement(sql);
			psmt.setInt(1,start);
			psmt.setInt(2,end);
			rs=psmt.executeQuery();
			while(rs.next()){
				al.add(rs.getString(1));
			}
		}
		catch(Exception e){
			
		}
		return al;
		
	}
}