tphmtype.java

HW-中国移动企业信息机,请查看

package com.sxit.phonemanager;
import java.util.*;
import java.sql.*;
/**
 * <p>类名: Tphmtype</p>
 * <p>功能: 类型</p>
 * <p>公司: 深讯信科</p>
 * <p>版本: 1.0</p>
 * @程序 sxit
 * @日期 2005-03-22
 * @修改纪录
 */
public class Tphmtype extends TphmtypeImpl
{
     public Tphmtype()
     {
          super();

     }
     public void create(Connection con, String typename) throws SQLException {
  PreparedStatement stmt = null;
  ResultSet rs = null;
  String sql = "";
  try {
    sql =
        "select typeid,brandid,modeid,typename,statusid from tphmtype where typename='"+typename+"'";
    stmt = con.prepareStatement(sql);
    rs = stmt.executeQuery();
    if (rs.next()) {
      this.typeid = rs.getLong("typeid");
      this.brandid = rs.getLong("brandid");
      this.modeid = rs.getLong("modeid");
      typename = rs.getString("typename");
      statusid = rs.getInt("statusid");
    }
    stmt.close();
  }
  finally {
    if (stmt != null)
      stmt.close();
  }
}

}