checidaoimpl.java

自己做的一个火车票售票网站是课程设计 用的是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;
	}

}