src/service/service1.java

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

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

package service;

import java.sql.ResultSet;

import model.kehu;

import db.DB;

public class service1
{
	public static String getUserName(String id)
	{
		String name="";
		
		String sql="select * from t_user where id=?";
		Object[] params={id};
		DB mydb=new DB();
		try
		{
			mydb.doPstm(sql, params);
			ResultSet rs=mydb.getRs();
			rs.next();
			name=rs.getString("loginname");
			rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		mydb.closed();
		return name;
	}
	

	public static kehu get_kehu(int id)
	{
		kehu kehu=new kehu();
		
		String sql="select * from t_kehu where id=?";
		Object[] params={id};
		DB mydb=new DB();
		try
		{
			mydb.doPstm(sql, params);
			ResultSet rs=mydb.getRs();
			rs.next();
			
			kehu.setId(rs.getInt("id"));
			kehu.setMingcheng(rs.getString("mingcheng"));
			kehu.setDizhi(rs.getString("dizhi"));
			kehu.setLianxiren(rs.getString("lianxiren"));
			kehu.setDianhua(rs.getString("dianhua"));
			kehu.setYoubian(rs.getString("youbian"));
			kehu.setChuanzhen(rs.getString("chuanzhen"));
			kehu.setYouxiang(rs.getString("youxiang"));
			
			rs.close();
		}
		catch(Exception e)
		{