deptd.java

实现在线的增删改查和一些基本的功能！这是一个简单的网页！

package Dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import model.Dept;

import Util.DBHelper;

public class DeptD {
	
	private PreparedStatement ps;
	private ResultSet rs;
	/*****
	 *获得所有的类别信息
	 * ******/
	public List getAllObject(){
		List list=new ArrayList();
		Connection conn=DBHelper.getCon();
		String sql="select*from Dept";
		try {
			ps=conn.prepareStatement(sql);
			rs=ps.executeQuery();
			while(rs.next()){
				Dept dp=new Dept();
				dp.setDeptsortid(rs.getInt("deptsortid"));
				dp.setSortid(rs.getInt("sort"));
				dp.setSortname(rs.getString("sortname"));
				list.add(dp);
				
			}
		} catch (SQLException e) {
			
			e.printStackTrace();
		}
		return list;
	}
	/*****
	 * 根据类别编号获得一种类别的信息
	 * *****/
	public Dept getSortid(int Sortid){
		Dept dpt=null;
		Connection conn=DBHelper.getCon();
		String sql="select*from Dept where Sortid=?";
		try {
			ps=conn.prepareStatement(sql);
			ps.setInt(1, Sortid);
			rs=ps.executeQuery(); 
			while(rs.next()){
				dpt=new Dept();
				dpt.setDeptsortid(rs.getInt("deptsortid"));
				dpt.setSortid(rs.getInt("sort"));
				dpt.setSortname(rs.getString("sortname"));
			}
		} catch (SQLException e) {
			
			e.printStackTrace();
		}
		
		return dpt;
		
	}
	

}