package com.service.customerlogin;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import com.database.util.DatabaseConn;

public class MSSQLcustomerDAO implements customerDAO {

public customerDTO getCustomer(String loginName) throws Exception {
customerDTO dto = new customerDTO();
String sql_str = "";
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet result = null;

sql_str = "SELECT companyName,companyAddress,contactName,email,"
+ "mobile,phone,loginName,registeredTime,description "
+ "FROM T_user where loginName=?";

try {
conn = DatabaseConn.getConnection();
pstmt = conn.prepareStatement(sql_str);
pstmt.setString(1, loginName);
result = pstmt.executeQuery();
if (result.isBeforeFirst()) {
while (result.next()) {
dto.setCompanlyAddress(result.getString(1));
dto.setLoginName(result.getString(2));
dto.setPassWord(result.getString(3));
dto.setCompanlyName(result.getString(4));
dto.setContactName(result.getString(5));
dto.setDescription(result.getString(6));
dto.setEmail(result.getString(7));
dto.setMobile(result.getString(8));
dto.setPhone(result.getString(9));
}
}
} catch (Exception sqle) {
throw sqle;
} finally {

}
return dto;
}
}