e03c9e31713b001d12f483999dc4cf57

自己做的一个火车票售票网站是课程设计 用的是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=null;
		PreparedStatement psmt =null;
		ResultSet rs=null;
		String sql = "select * from chezhan where czname=?";
		try{
			dbc=new DataBaseConnection();
			psmt=dbc.getConnection().prepareStatement(sql);
			psmt.setString(1,chezhanName);
			rs=psmt.executeQuery();
			if(rs.next()){
				vo.setChezhanNumber(rs.getInt(1));
				vo.setChezhannName(rs.getString(1));
			}
		}
		catch (Exception e){
			e.printStackTrace();
			
		}
		
		return vo;
	}

}