e0751deae43d001d1121d366989590b0

来自「自己做的一个火车票售票网站是课程设计 用的是servlet+jsp 数据库是m」· 代码 · 共 40 行

package com.daoImpl;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

import com.dao.LiuyanDAO;
import com.jdbc.DataBaseConnection;
import com.vo.LiuyanVO;

public class LiuyanDAOImpl implements LiuyanDAO {

	public List selectAll() {
		ArrayList al = new ArrayList();
		DataBaseConnection dbc =new DataBaseConnection();
		PreparedStatement psmt =null;
		ResultSet rs =null;
		String sql =null;
		LiuyanVO vo =null;
		try{
			sql="select * from liuyan";
			psmt=dbc.getConnection().prepareStatement(sql);
			rs=psmt.executeQuery();
			while (rs.next()){
				vo.setType(rs.getString(1));
				vo.setName(rs.getString(2));
				vo.setContent(rs.getString(3));
				vo.setLiuyanTime(rs.getString(4));
				al.add(vo);
			}
			
		}
			catch(Exception e){
			}
		
		return al;
	}
}