src/com/service/liuService.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.service;

import java.sql.ResultSet;
import com.dao.DB;
import com.orm.TOrganization;
import com.orm.Yuangong;

public class liuService
{

	public static TOrganization getOrg(int id)
	{
		TOrganization organization=new TOrganization();
		
		if(id==0)
		{
			organization.setId(0);
		}
		else
		{
			String sql="select * from t_organization where id=?";
			Object[] params={id};
			DB mydb=new DB();
			try
			{
				mydb.doPstm(sql, params);
				ResultSet rs=mydb.getRs();
				rs.next();
				organization.setId(rs.getInt("id"));
				organization.setName(rs.getString("name"));
				organization.setDescription(rs.getString("description"));
				rs.close();
			}
			catch(Exception e)
			{
				e.printStackTrace();
			}
			mydb.closed();
		}
		return organization;
	}

	public static Yuangong getYuangong(int id)
	{
		    Yuangong yuangong=new Yuangong();
		    String sql="select * from t_yuangong where id=?";
			Object[] params={id};
			DB mydb=new DB();
			try
			{
				mydb.doPstm(sql, params);
				ResultSet rs=mydb.getRs();
				rs.next();
				yuangong.setId(rs.getInt("id"));
				yuangong.setOrg_id(rs.getInt("org_id"));
				yuangong.setBianhao(rs.getString("bianhao"));
				yuangong.setName(rs.getString("name"));
				yuangong.setSex(rs.getString("sex"));
				yuangong.setAge(rs.getString("age"));
				yuangong.setZhiwei(rs.getString("zhiwei"));