utilcote.java

来自「spring+struts+hibernate做的银行系统」· Java 代码 · 共 44 行

/*
 * Created on 2006-4-14
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package cn.com.tym.util.tablebean;

import java.sql.ResultSet;
import java.sql.SQLException;
 
import cn.com.tym.pub.DB;

/**
 * @author jack_booth
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class UtilCote {

	
//	返回栏目的名字
	 public String getCoteName(int id,DB db)
	     throws SQLException
	 {
	 	String name="";
	      
	     
	     String strSql2 = "select card_id,card_name from mdh_cote  where card_id='"+id+"'";
	 try{
	  ResultSet  rs = db.OpenSql(strSql2);
	         if(rs.next()){
	             name=rs.getString("card_name");
	       
	         }
	 }catch(SQLException e){
	 	e.printStackTrace();
	 	throw e;
	 }
	     return name;
	 }
}