chezhandaoimpl.java

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

package com.daoImpl;

import com.dao.ChezhanDAO;
import com.vo.ChezhanVO;
import com.jdbc.*;
import java.sql.*;

public class ChezhanDAOImpl implements ChezhanDAO {

	public ChezhanVO cheZhanNumber(String chezhanName) {
		ChezhanVO vo = null;
		DataBaseConnection dbc = new DataBaseConnection();
		PreparedStatement psmt = null;
		ResultSet rs = null;
		String sql = "select * from chezhan where czname= ?";
		try {

			psmt = dbc.getConnection().prepareStatement(sql);
			psmt.setString(1, chezhanName);
			rs = psmt.executeQuery();
			if (rs.next()) {
				vo = new ChezhanVO();
				vo.setChezhanNumber(rs.getInt(1));
				vo.setChezhannName(rs.getString(2));

			}

		} catch (Exception e) {

		}

		return vo;
	}

}