convert.java

来自「有完整的毕业设计所需的文件和代码 没什么说的了」· Java 代码 · 共 84 行

package db;

import java.sql.ResultSet;
import java.sql.SQLException;

import vo.Admin;
import vo.D;
import vo.Pro;
import vo.User;

public class Convert {

	
	public static Pro c_pro(ResultSet re){
		Pro p=new Pro();
		try {
			p.setId(re.getInt("id"));
		p.setBianhao(re.getString("bianhao"));
		p.setDes(re.getString("des"));
		p.setImg(re.getString("img"));
		p.setIsvalue(re.getString("isvalue"));
		p.setKind(re.getString("kind"));
		p.setName(re.getString("name"));
		p.setSc_value(re.getString("sc_value"));
		p.setSj_value(re.getString("sj_value"));
		p.setState(re.getString("state"));
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return p;
	}
	public static User c_u(ResultSet re){
		User u=new User();
		try {
		u.setCardId(re.getString("cardId"));
		u.setId(re.getInt("id"));
		u.setName(re.getString("name"));
		u.setPh(re.getString("ph"));
		u.setPwd(re.getString("pwd"));
		u.setSex(re.getString("sex"));
		
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return u;
		
	}
	
	public static D c_d(ResultSet re){
		
		D d=new D();
		try {
		d.setBuy_date(re.getString("buy_date"));
		d.setId(re.getInt("id"));
		d.setIsSend(re.getString("isSend"));
		d.setPro_id(re.getInt("pro_id"));
		d.setUser_id(re.getInt("user_id"));
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return d;
		
	}
	
	public static Admin c_admin(ResultSet re){
		Admin a=new Admin();
		try{
			a.setId(re.getInt("id"));
			a.setName(re.getString("name"));
			a.setPwd(re.getString("pwd"));
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return a;
		
	}
	
}