public String connectAs(Student student) { try { connectWithMySql(); String sql = "SELECT * FROM webservicedemo WHERE Roll = ? AND Pass=?"; PreparedStatement ps = conn.prepareStatement(sql); ps.setString(1, student.getRoll()); ps.setString(2, student.getPass()); ResultSet rs = ps.executeQuery(); while (rs.next()) { student.setName(rs.getString(1)); student.setMobile(rs.getString(3)); student.setEmail(rs.getString(4)); // student.setPass(rs.getString(5)); ret = "SUCCESS"; } } catch (SQLException e) { ret = "ERROR"; } finally { if (conn != null) { try { conn.close(); } catch (Exception e) { e.printStackTrace(); } } } return ret; }