inceptd.java

来自「实现在线的增删改查和一些基本的功能！这是一个简单的网页！」· Java 代码 · 共 66 行

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.Incept;

import Util.DBHelper;

public class InceptD {
	private PreparedStatement ps;
	private ResultSet rs;
	/*****
	 * 获得所有收货人的信息
	 * ********/
	public  List getAllIncept(){
		List list=new ArrayList();
		Connection conn=DBHelper.getCon();
		String sql="select*from Incept";
		try {
			ps=conn.prepareStatement(sql);
			rs=ps.executeQuery();
			while(rs.next()){
				Incept ipt=new Incept();
				ipt.setInceptid(rs.getInt("inceptid"));
				ipt.setInceptname(rs.getString("inceptname"));
				ipt.setUserid(rs.getInt("userid"));
				list.add(ipt);
			}
		} catch (SQLException e) {
			
			e.printStackTrace();
		}
		return list;
		
	}
	/*****
	 * 根据收货人编号获得一个收货人的信息
	* ********/
	public Incept getIncept(int Inceptid){
		Incept inpt=null;
		Connection conn=DBHelper.getCon();
		String sql="select*from Incept where Inceptid=?";
		try {
			ps=conn.prepareStatement(sql);
			ps.setInt(1, Inceptid);
			rs=ps.executeQuery();
			while(rs.next()){
				inpt=new Incept();
				inpt.setInceptid(rs.getInt("inceptid"));
				inpt.setInceptname(rs.getString("inceptname"));
				inpt.setUserid(rs.getInt("userid"));
			}
		} catch (SQLException e) {
			
			e.printStackTrace();
		}
		return inpt;
	}
	

}