public List<String> getPlayerDetailsByName(String player_Name) throws MyDAOException {
Connection con = null;
try {
con = MyConnectionFactory.getConnection();
Statement stmt = con.createStatement();
// PreparedStatement
// ps=con.prepareStatement("select * from players where names like 'm%'");
// ps.setString(2, player_Name);
// ResultSet rS =
// stmt.executeQuery("select * from players where names like 'm%'");
ResultSet rS =
stmt.executeQuery(
"select * from players where EMPLOYEE_NAME like '" + player_Name + "%'");
// ResultSet rs=ps.executeQuery();
List<String> list = new ArrayList<String>();
while (rS.next()) {
// PlayerDetails details = new PlayerDetails();
// details.playerName=rs.getString(2);
list.add(rS.getString(2));
}
con.close();
// System.out.println("Players list :" + list);
return list;
} catch (SQLException e) {
System.out.println("Error:\n\t" + e.getMessage());
throw new MyDAOException("Exception while getting data fromm DB");
}
}
public Blob getImage(Integer teamId) {
Connection con;
try {
con = MyConnectionFactory.getConnection();
String getimage = "select teamlogo from team where team_id=? ";
PreparedStatement ps = con.prepareStatement(getimage);
ps.setInt(1, teamId);
ResultSet resultSet = ps.executeQuery();
if (resultSet.next()) {
return (Blob) resultSet.getBlob(1);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}
public boolean insertTeamDetails(TeamRegistration teamRegistration) throws MyDAOException {
InputStream inputStream = null;
FormFile file = teamRegistration.getTeamLogo();
int filesize = file.getFileSize();
// String fname= file.getFileName();
try {
inputStream = file.getInputStream();
} catch (FileNotFoundException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} catch (IOException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
Connection con = null;
try {
con = MyConnectionFactory.getConnection();
String inserQuery =
"insert into team(team_id,team_name,TEAM_CAPT,TEAM_VICE_CAPT,TEAM_CAPT_ID,TEAM_VICE_CAPT_ID,PLAYER_ID,teamlogo) values(?,?,?,?,?,?,?,?)";
PreparedStatement ps = con.prepareStatement(inserQuery);
ps.setString(2, teamRegistration.getTeamName());
ps.setInt(1, teamRegistration.getTeamID());
ps.setString(3, teamRegistration.getCaptainName());
ps.setString(4, teamRegistration.getViceCaptainName());
ps.setInt(5, teamRegistration.getCaptainID());
ps.setInt(6, teamRegistration.getViceCaptainID());
ps.setString(7, teamRegistration.getSelectPlayers());
// ps.setNull(8,Types.BLOB);
ps.setBinaryStream(8, inputStream, filesize);
// ps.setString(9,teamRegistration.getSelectedPlayers());
ps.executeUpdate();
return true;
} catch (SQLException e) {
e.printStackTrace();
// System.out.println("**Exception**"+e.getMessage());
}
// TODO Auto-generated method stub
return false;
}