leveldao.java

应用struts技术开发的java的多表关系的增删改应用程序

package com.xaccp.dao;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.List;
import java.util.Vector;

import com.xaccp.db.DBManager;
import com.xaccp.vo.LevelVo;

public class LevelDao {
	/**
	 * 该类为员工等级的dao
	 */

	public List getAll(){
		//1 连接
		Connection con=DBManager.getConnection();
		//2 sql
		String sql="select * from [level] l order by l.levelId";
		try {
			//3 execute sql
			Statement st=con.createStatement();
			ResultSet rs=st.executeQuery(sql);
			
			List lvo=new Vector();
			while(rs.next()){
				LevelVo levelvo=new LevelVo();
				levelvo.setLevelId(rs.getInt("levelId"));
				levelvo.setLevelName(rs.getString("levelName"));
				lvo.add(levelvo);
			}
			rs.close();
			st.close();
			con.close();
			return lvo;
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
			return null;
		}
	}
}