d026b6871e3c001d111782b9be622526

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

package com.daoImpl;

import com.dao.CheciDAO;
import com.vo.CheciVO;
import java.sql.*;
import com.jdbc.*;

public class CheciDAOImpl implements CheciDAO {

	public CheciVO selectByNumber(String checiNumber) {
		DataBaseConnection dbc = new DataBaseConnection();
		PreparedStatement psmt =null;
		CheciVO vo =new CheciVO();
		ResultSet rs =null;
		String sql = "select * from checi where cinumber =?";
		try
		{
			psmt=dbc.getConnection().prepareStatement(sql);
			psmt.setString(1,checiNumber);
			rs=psmt.executeQuery();
			while(rs.next()){
				
				vo.setCheciNumber(rs.getString(1));
				vo.setCheciStart(rs.getString(2));
				vo.setCheciEnd(rs.getString(3));
				vo.setCheciStartTime(rs.getString(4));
				vo.setCheciEndTime(rs.getString(5));
				vo.setCheciLength(rs.getInt(6));
				vo.setCheciType(rs.getString(7));
				
			}
		}
		catch(Exception e){
		}
		return vo;
	}

}